✓ Data basics (Best usage of Shortcuts, Formatting tricks, cell referencing)
✓ Simple problem solving (Sort and Filter basics)
✓ Learn Essential Business Math (Formula Warmup, Pivot table overview
✓ Build simple models (Combo Formulas, 3-dimensional lookups, Date formulas)
✓ Error-handling to avoid humiliation (data validation, auditing, track variables)
✓ Learn Data Cleaning Techniques (Go-to-Special, Text formulas, Flashfill)
✓ Summarize your data with Pivot Tables (Slicers, Sparklines, Calcs, Differential Criteria Filters)
✓ Modeling Uncertainty (Scenario, Sensitivity Analysis, Data Tables, Goal Seek)
✓ Slide-ready output (Charts and Graphs, Printing techniques)
✓ Dynamic Dashboards (Get Pivotdata, Learn Reverse lookups, conditional calculations)
✓ Managing Data Security (Passwords, sheet protection)
These Advanced Excel Tutorials are targeted to SAVE you YEARS! This Online Course will propel you from the current proficiency level to a level where you can train professional users and explore a very satisfying and rewarding career opportunity.
Check out the Course Syllabus to see exactly what's part of this course.
We create Data Analytics and Presentation Tricks for Big Four Professionals (KPMG, E&Y, PwC and Deloitte). We offer instructional videos, practice files, and personalized learning dashboards to the learners. This empowers an individual to master use cases of the software at their own pace, anytime and anywhere. We work with industry experts who double up as an award-winning instructor for our courses.
You can enroll for this online training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
- Visa/Master Card credit card
You will have access to the online e-learning and practice worksheets along with the training.
Yes. There are some small differences in the Mac and Win interface with respect to formulas, but in general there is very good overlap between the Mac and Windows versions. The videos were recorded in Windows.
Yes, we offer course completion certificate after you successfully complete the training program.
We watch a lot of learning videos ourselves on wide variety of topics and have realized that our attention span is limited. We think people learn quickly and effectively with a no-nonsense approach that is quick, clean, and to the point.