search
About this course

Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.

But using it can still be a mystery.

This video will show you everything you need to know about using Excel and getting more productive and efficient with it.

The topics include:
- Sorts
- Filters
- Advanced Filters
- Formatted Tables
- The Total Row in Formatted Tables
- Using Slicers in Formatted Tables
- The Sumif, Countif, and Averageif Formulas
- The Vlookup Formulas
- Subtotals
- Charts
- Pivot Tables
- Dashboards in Pivot Tables
- Power Pivot and PowerQuery
- Automating tasks with Macros

What you will learn?
You will learn
Sorts
Filters
Advanced Filters
Formatted Tables
The Total Row in Formatted Tables
Using Slicers in Formatted Tables
The Sumif, Countif, and Averageif Formulas
The Vlookup Formulas
Subtotals
Charts
Pivot Tables
Dashboards in Pivot Tables
Power Pivot and PowerQuery
schedule
4.5 hours on-demand video
emoji_events
Certificate of completion
bar_chart
Intermediate level
error_outline
No prerequisites
check_circle
No preparation required
lock
1 year access

US$80.66

verified 100% moneyback guarantee
If you cancel within 10 days and you’re not completely satisfied, we’ll give you all your money back. No questions asked.
Training 2 or more people?

Get your team access to top CPE QAS for CPAs courses anytime, anywhere.

Browse course content
2 Video
|
schedule
4.5 hours
Guide
Section 1.
lock
Excel Boot Camp
4h 27m 57s
play_arrow PREVIEW
The Excel Boot Camp: Everything You Need to Know to Be Productive
44s
Learn from the best
Tom Fragale /INSTRUCTOR
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall

Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.