Excel Tips & Tricks For Intermediate Excel Users with Eg.
Excel Tips & Tricks For Intermediate Excel Users with Eg.
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
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
You can learn advanced excel data analysis tricks on, Pivot Tables, Flash Fill, Data Cleaning & more in 38 mins
Url: View Details
What you will 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
Rating: 4.4
Level: All Levels
Duration: 38 mins
Instructor: Yoda Learning
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.
View Sitemap