Learn Excel Essentials for Reporting in 5days
This free course will give you staged access to short videos over the next 5 Days to demystify how Microsoft Excel really works.
Knowing how Excel works at a deeper level is the secret to harnessing its power and increasing your productivity. Learn Excel secrets and tips in this FREE course.
This course will teach you a methodology for working with Excel that exposes how the Excel application really works. The course highlights many shortcuts, tips and tricks to make you more productive on the job. By the end of the course participants will be able to:
Identify and Recall the new features and shortcuts in the latest versions of Excel.
Demonstrate general Excel spreadsheet skills by working with tabs, ribbons, dialogue boxes, Excel options and formats
Interpret exactly how the Excel engine works and use this knowledge in proffering solution to case studies.
Here's what you'll learn...
Introduction
How to use the Platform
Before we begin ...
Join Our Excel & Power BI Meetup Group fo free
The Reporting Infrastructure
Lab 01 - How Excel Works
Reporting Framework & the 7 Golden Rules of Data
The role of the Control & Report Sheets
How Excel Works
Managing Dates, Validations & Format Styles
Ask the Trainer
Quiz - Reporting Infrastructure
Report Building Blocks
Lab 02 - Report Building Blocks
Simple Report Template
Identify your Report Criteria
Automate with SUMIFS
SUMIFS & the Date Criteria Hack
Ask the Trainer
Quiz - Report Building Blocks
Overview of Excel Styles
Advanced Formatting in Excel
Excel Formatting Syntax
50 Excel Keyboard Shortcuts for Windows
50 Excel Keyboard Shortcuts for Mac
Instructions
More resources for you
Evaluate & get Certificate
“Quality Of The Course Fine, Course Content Great Especially Because David Simplify The Report With Excel ”
“The Course Content Was Deep And Very Applicable To My Daily Work ”
“Very Detailed And Encompassed Relevant Aspects Of Excel ”
“It Was Rich,Navigating From The Basic To The Advanced Function ”
You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.
Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.
You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.
Deferral requests are treated on a case by case basis. Please email training@dbrownconsulting.net with your request.
Our videos are only available for streaming online. But you can download all exercise files and materials.