Online Advanced Excel Tutorials – Become an Excel Ninja

What’s covered in the Online Advanced Excel Tutorials …


Beginner Excel Skills

✓ Data basics (Best usage of Shortcuts, Formatting tricks, cell referencing)

✓ Simple problem solving (Sort and Filter basics)

✓ Essential Business Math (Formula Warmup, Pivot table overview

Intermedia Excel Skills

✓ Build simple models (Combo Formulas, 3-dimensional lookups, Date formulas)

✓ Error-handling to avoid humiliation (data validation, auditing, track variables)

✓ Data Cleaning Techniques (Go-to-Special, Text formulas, Flashfill)

✓ Summarize your data with Pivot Tables (Slicers, Sparklines, Calcs, Differential Criteria Filters)

Advanced Excel Skills

✓ Modelling Uncertainty (Scenario, Sensitivity Analysis, Data Tables, Goal Seek)

✓ Slide-ready output (Charts and Graphs, Printing techniques)

✓ Dynamic Dashboards (Get Pivotdata, Reverse lookups, conditional calculations)

✓ Managing Data Security (Passwords, sheet protection)

More details of Online Advanced excel tutorials:


Course Duration: 11+ hrs
Excel Ninja Ebook: Yes
Course Access period: Lifetime Unlimited Access
Course Completion certificate: Yes
Lifetime Support to Queries: Yes

Course Fees: Rs 5990 (including taxes)

To enroll, using Debit/Credit Card or via Net banking, please click here:

Enroll for Rs 5990 only

or

If you wish to pay for the course in USD, Click here to enroll Advanced Excel Course for $100 only

Note: Post course enrollment, you need to create a free account at http://yodalearning.com to activate the course access.