Excel Tips & Tricks For Intermediate Excel Users with Eg.

You can learn advanced excel data analysis tricks on, Pivot Tables, Flash Fill, Data Cleaning & more in 38 mins

Who this course is for:

What you’ll learn

  • Best – Features of Data Cleaning i.e. Flash FILL (Basic – Intermediate).
  • Top 7 awesome Pivot Table Dashboard Tricks in 1 video.
  • Clean & Restructure data 10x faster with Go To (Special) with Ctrl Enter.
  • Hidden Tricks of Find & Replace.
  • Use Slabs based Lookup (Vlookup with TRUE) to avoid complex Nested IF statements.
  • 2D Lookups (Vlookup with Match).

Course Content

  • Introduction –> 7 lectures • 38min.
  • May 2018 Update – New eBook –> 1 lecture • 1min.

Excel Tips & Tricks For Intermediate Excel Users with Eg.

Requirements

  • The learner should be an Intermediate user of MS Excel with version 2007 and above.
  • Excel 2013 & above for Flash Fill trick.
  • Excel 2010 & above for Pivot Table Slicer.

Who this course is for:

This course is for Excel users who have the knowledge of VLOOKUP, Text to Columns & Pivot Table

Advanced Excel, Data analysis in Excel, Become Excel Expert

You will learn the best tricks in MS Advanced Excel and its real life application like never before:

No 1.  Flash Fill – It saves hours of time. It fills in data based on pattern recognition. You have to show few samples. It can also can extract and insert as well as format and concatenate. It is based on “Programming by Example (PBE)”.

>> How to train the algorithm of Flash Fill better?

  • No blank column between Input & Output columns
  • Take more samples
  • Take tough samples
  • Use Apostrophe / Single quote marks for [Date & Time, Nos. with preceding zeroes]

No 2. Pivot Table

  • Grouping [Dates, Numbers]
  • Slicers & related settings
  • Pivot Chart Shortcut
  • Disable Autofit Column widths
  • Disable =GETPIVOTDATA() for formula writing
  • 2-D Table data consolidation
  • Creating 100s of Pivot Table reports in < 1 minute

No 3. Go To (Special)

  • Filling blank cells in between rows of data
  • Selecting cells with errors
  • Detecting cells with formulas

No 4. Find & Replace (Ctrl + H)

  • How to use Asterisk (*) to clean data 10x faster
  • How to remove Asterisk (*)
  • Why Find & Replace of MS Word is more powerful

No 5. VLOOKUP() with TRUE (1)

  • Saves hours of your time by condensing multi-level complex  nested IF statements in one simple VLOOKUP() formula.

When is VLOOKUP() with TRUE used? When the [Date or Number] values are:

  • in logical slabs (e.g. 0-100, 101-200 etc.)
  • listed in ascending order, and
  • listed in order of [at least, onwards, not less than, WEF, >=]

Excel Course For Expert (VLOOKUP, Pivot Table, Gotospecial)

Application areas: Financial Modeling, Accounting (Debtors’ ageing), Incentive calculations, Ranking etc.

No 6. VLOOKUP() with MATCH() saves hours of your time by condensing multi-level complex  nested IF & AND/OR statements in one simple combination formula. It helps pull data based on two variables (vertical & horizontal). It’s called 2-D lookup.

——————————————–

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I’ll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Access to all videos 24 x 7 – learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied)

———————————————

If you have read this far, next action is JOINING this course. Invest 38 mins. for the benefit of lifetime Ninja status on Advanced Excel Course.

Advanced Excel, Data analysis in Excel, Become Excel Expert

Get Tutorial