Advance Excel Mastery Beginner to Advanced Skills in Excel
Empower Yourself with Excel Expertise - From Basics to Advanced Techniques for Greater Productivity and Success
4.15 (88 reviews)
1,778
students
6.5 hours
content
Jan 2024
last update
$69.99
regular price
What you will learn
Advanced Functions: Master complex Excel functions for precision in calculations and data analysis.
Data Security: Protect sensitive information with validation rules and password safeguards in Excel.
Chart Customization: Create dynamic, customized charts to visualize data effectively in Excel.
PivotTable Expertise: Analyze data like a pro with advanced PivotTable techniques in Excel.
Automate with Macros: Boost efficiency by automating tasks with VBA macros in Excel.
Sophisticated Analysis: Solve complex problems and perform what-if analysis efficiently in Excel.
Database Functions: Query large datasets with ease using advanced Excel database functions
Optimization with Solver: Use Excel's Solver add-in to tackle optimization challenges effectively
Visualize Data: Enhance data presentation creatively with advanced Excel data visualization technique
Why take this course?
Comprehensive Microsoft Excel Course Bundle: From Basics to Advance
Learn Excel for Versions 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023
Recent Student Reviews:
Join this in-depth journey into Microsoft Excel, led by a Microsoft Certified Trainer with over 10 years of experience. Whether you're a beginner or looking to sharpen your skills, our four-course bundle will empower you with Excel's essential tools.
You'll start with the fundamentals, build a strong foundation, and progress to intermediate and advanced techniques. By the end of this course, you'll be a master of Excel, ready to tackle any task efficiently and confidently.
What You'll Master:
- Creating efficient spreadsheets
- Managing extensive data sets
- Utilizing Excel's popular functions like SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and more
- Crafting dynamic reports with Excel PivotTables
- Harnessing the power of Microsoft Excel's Add-In, PowerPivot
- Auditing Excel formulas for accuracy
- Automating daily tasks using Macros and VBA
What's Included:
- Over 6 hours of step-by-step video lectures by Certified Trainer
- Downloadable exercise files for hands-on practice
- Additional exercise files at the end of each major section
- A Q&A board for questions, progress updates, and instructor and peer communication
Don't miss this opportunity to transform your Excel skills. Enroll now and elevate yourself from an Excel novice to an Excel expert!
Content
Fill Series & Excel Key Shortcuts
Fill Series
FAQ's
Editing Custom List
Important Info
Excel Short keys & Golden Key
Introduction to Absolute & Relative References (Fixed & Variable)
The Marksheet
The Marksheet
Random Number Generation
Clearing Formula With Intact Values
Key Components of Marksheet
Introduction to IF-Then Conditions
Nested IF's (Looping Function)
Ranking Positions
Conditional Formatting & Data Bars
Freeze Panes
Table Formatting & Range Conversion
Sort & Filters
Max Min Average Countblank Count if and Much More
Sales & Bonus Report
Prepare a Sales and Bonus Report With Manual Totalling
Grouping and Auto totalling
Quick Reminder
Hiding and Unhiding Rows Grouping and Auto Totalling
Removing Duplicates and Sales Summary With Sum if Function
Understanding Absolute and Relative Refrencing
Applying Sumif With Absolute and Relative Refrencing
Sumif with External Sheet Refrences
IF Conditions With Multiple Logics
The Aged Debtors Analysis
Introduction to Aged Debtors Analysis
Arranging the data to get Started
FAQ's Leaving a Review
Automate data arrangement
Quick Trick Formatting
Conditional formatting Advance
Applying Advance Formatting Tricks
Formula Analysis for Aging
Absolute , Relative Functions & Date values
Live Aging Analysis
Live Aging
Quick Reminder
Advance Search Tricks
Introduction to Vlookup
Using Named Ranges and IF ERROR
Simplifying Even More With data Validation
Quick Reminder
Using Combo Boxes
The Hlookup Function
Lookup for Inverse Data
Introduction To Index Match
Quiz Assignment Remington Pharma Explanation
Invoicing System Remington Pharmaceuticals
Advance Analysis Tricks
Sum If and IFS
Forget filters - use DSUM Search Box
Amazing Advance Filters & Macros
Pivot Table & Dashboard Reporting
Introduction to Pivot tables
Grouping In Pivot Tables
Calculated Fields
FAQ's Leaving a Review
Pivot Charts
Dashboard Reporting
Some Other Amazing Tricks & Time Savers
Automated Cheque Printing System (Using Mail Merge)
Introduction to Hyperlinks
Hyperlinks With External Sheet Refrences
Columns Seperation & Concatenation
Excel Flash Fill Saves The day
Quick Reminder
Bonus Section
Bonus Is HERE
Screenshots
Reviews
Val
August 12, 2022
This course covers different functions and is very versatile. Instructons are very clear and examples are very helpful. I am now much more comfortable using excel at work and my main goal is achieved. Thanks!
Muhammad
July 1, 2022
This was a great course to be apart of. The teacher is so calm and informative whilst maintaining a high level of interaction. The teacher is extremely knowledgeable on Excel.
John
June 4, 2022
By far, this is the most comprehensive Excel course that I have come across. The course teaches a wide variety of Excel functions from beginner to advanced level. It is very organized, well-structured, and easy to follow. I particularly like the examples shared by the teacher, making the new knowledge practical and easy. Highly recommend to anyone needs to how to use Excel!
Cynthia
March 31, 2021
it is not bad but has soon as it reaches section 3 #24 explanation becomes difficult to understand for me
Richa
April 21, 2020
The course was explained very well. However, I expected few practice workbooks as well that weren't provided. So, i would advice few practice workbooks to be included as well.
Thanks
Corin
June 18, 2018
Amazingly useful! Started off not really knowing much about Excel and this course got me a job! So useful knowing these shortcuts, they've made my work so much quicker (and lazier!). Definitely recommend!
Sumit
February 20, 2018
The trainer has the right pace, right attitude. All this makes your Paisa Wasool. No regrets signing up for the course. It would be appreciated if the trainer gives a personal touch; that means he gets in touch with you and help you solve the work related sheets you require for work place. I mean attend to specific excel needs or requirements as per individual. Thanks.
Elliot
October 11, 2017
This was a really helpful course to take for small business owning and project management, before taking it I knew some of the basics of excel, but now I feel comfortable using different formulas and formatting which will save me a lot of time. Thanks Saad!
Apurv
May 26, 2017
left one star because shortcuts and tricks for excel on mac not given
left onestar because questions are not being answered
Martín
May 5, 2017
Best course on excel that I have taken so far. Really love it, hope the instructor gives in the future a more advance excel course, maybe VBA would be great.
Barzan
July 25, 2016
This course is rich of valuable information for intermediate excel students as well as the way of instructor explanation is very good.
Sherry
July 12, 2016
I thought I new all of the basics of excel but this course has shown me things that will make creating and updating spreadsheets even faster and without a mouse.
Nicholas
July 8, 2016
Great course, my 1st course in Udemy and I have a lot of take aways from this course. I would say that it will bring you to an intermittent level in Excel. No one will be able to teach you all the formula in excel but you will be able to apply the concept and search for the right one when you need it. Thank you so much hope you will throw in more content for us ! =D
Coupons
| Submit by | Date | Coupon Code | Discount | Emitted/Used | Status |
|---|---|---|---|---|---|
| - | 7/14/2022 | 425F3A3633036089BD5D | 100% OFF | 1000/863 | expired |
Charts
Price
Rating
Enrollment distribution
Related Topics
775584
udemy ID
2/27/2016
course created date
2/8/2020
course indexed date
Bot
course submited by