⚡

10 POWERFUL EXCEL FEATURES 

When: TBD
Location: Teams/Zoom Meeting

00
Days
00
Hours
00
Minutes
00
Seconds

⚡

Learn Excel Power Shortcuts, Tips, and Tricks

Are you tired of seeing your team spend hours manually sorting and analyzing data in Excel? Do you want to increase their productivity and efficiency, and ultimately drive more business success? Excel may seem like a basic tool, but in reality, it's a powerful software that can transform the way your team works. From data analysis to consolidating your spreadsheet reports, Excel can save your team valuable time and help them make better-informed decisions. Investing in your team's Excel skills is a must if you want to stay ahead of the competition. By doing so, you'll not only increase their productivity but also boost their confidence, job satisfaction, and overall effectiveness. Don't let your team miss out on the benefits of Excel. Equip them with the skills they need to succeed and watch your business thrive.
Click on any of the topics to expand its contents.

  • The Order of Operations
  • Please Excuse My Dear Aunt Sally
  • Relative Reference
  • Absolute Reference
  • F4 is Your Friend

1-2_FORMULA_BASICS.xlsx

  • =(A2*B2) or =PRICE*TAX - change the way you program Excel.
  • Defined Range examples.

1-2_FORMULA_BASICS.xlsx

  • Quit wasting time summing your sheets individually.
  • SUM multiple sheets just using your mouse!

3D_REFERENCING.xlsx

  • 3D Referencing without formulas!
  • Combine data from multiple sheets into one.

4_CONSOLIDATE.xlsx

  • Put charts inside of single cells.
  • Win/Loss, Column, and Line charts.

5_MINIATURE_CHARTS.xlsx

  • The Easy way to highlight your KPI's.
  • Learn to create your own RULE!

6_CONDITIONAL_FORMATTING.xlsx

  • Did you know Excel has built-in AI?
  • Charts, Tables, and Analysis - made for you.
  • Insert your desired results, and that's it - done!
  • The Future of Work - AI as your Copilot!

7_DISCOVER_AI.xlsx

  • Easily move text values from one cell and combine with text from other cells - no formula!
  • Put your data in the right place, fast.

8_FLASH_FILL.xlsx

  • Need a Geographic representation of your data? Easy, insert a map!
  • Track multiple stock metrics in real-time.

9_DATA_VISUALIZATION.xlsx

  • Find the secret, Camera Tool in Excel.
  • Work with your data in one worksheet, and view on another.

10_CAMERA_TOOL.xlsx

Discover The Power Of This Amazing

Tool… And Start Using It TODAY!

This workshop is a guide for all users of Excel, whether you are experienced or new to the program.
********
We cover many features that you may not be familiar with and provide you with a few tips to help you become more productive in your work.
********
Excel has so many amazing features that you will wonder why you didn’t know about them sooner. After this workshop, you will be able to do more than you ever thought possible with this software.

Custom Excel Files

Access the exact files used in the workshop, enabling participants to follow along and practice effectively after the workshop.

Workshop Recording

Obtain a high-quality video to review and share, maximizing learning and retention for your team members.

Up to 200 Participants

Encourage large-scale collaboration and skill development, ensuring a consistent growth trajectory across departments.

Course Access for 60 Days

Benefit from extended access, providing ample opportunity to reinforce and master the workshop's skills.

Package

$2,997

One-time fee

  • Workshop Course Access for 60 Days
  • 200 participants
  • Workshop Recording
  • Custom Excel Files

Keep On Learning

  • List item one
  • List item two
  • List item three
  • List item four

Author

Billy "Mr. Aloha" Wigley

Microsoft Certified Trainer (MCT)

As a Microsoft Certified Trainer, Billy "Mr. Aloha" Wigley is a Microsoft Office Expert in Excel. He has traveled throughout the USA, and other countries to teach Excel skills to thousands of students. In just five years, he personally trained more than 65,000 professionals in over 100 cities.
He currently has more than 52,000 active online students.
With over 25 years of leadership experience, and from having resided in various cities worldwide, Mr. Aloha is well-known around the world. With his strong USA and Colombian heritage, Mr. Aloha takes pride in his multi-cultural background and being able to reach both English and Spanish speakers around the globe.
Think of Mr. Aloha as your Excel coach!
Teaching these skills is all he does, and he is committed to helping students like you to achieve beyond what you believe you are capable of. He maintains regular office hours to serve his students worldwide.

Microsoft Certified Trainers (MCTs) are the premier technical and instructional experts in Microsoft technologies. Click here and Verify Mr. Aloha's MCT badge.