Excel Tips & Tricks For Intermediate Excel Users with Eg

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)
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
Description
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
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
A 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
Who this course is for:
Regular Excel users who are keen to learn hidden tricks of Excel to save hours of time

Homepage

https://www.udemy.com/course/high-roi-advanced-excel-tricks/

Excel Tips & Tricks For Intermediate Excel Users with Eg Fast Download
Excel Tips & Tricks For Intermediate Excel Users with Eg Full Download