Excel Advanced Basic to Advance Training Course
Excel Basics to Advance Training Course covers Vlookup , Pivot table , if conditions , dashboard reporting & more
4.37 (664 reviews)
2,409
students
20 hours
content
Jan 2025
last update
$59.99
regular price
What you will learn
Master essential keyboard shortcuts for efficient Excel navigation
Utilize Excel's built-in features like AutoSum and AutoFill for quicker data entry
Learn to manipulate lists and sequences with ease
Customize Excel settings for personalized usage
Apply Conditional Formatting to Advanced level with Custom Options
Understand the basics and advance usage of formulas, including SUM, AVERAGE, COUNT, and mor
Dive into advanced functions like IF statements, SUMIF, COUNTIF, and AVERAGEIF
Explore the power of lookup functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH
Gain insights into data analysis techniques like ranking and filtering
Freeze panes to keep headers visible while scrolling through large datasets
Utilize logical functions and nested IF statements for complex decision-making
Data visualization with Sparklines , Pivot Tables and Dashboard Reporting
Create interactive dashboards and reports using Pivot Charts
Develop proficiency in Data validation and Drop-down lists
Automate Repetitive tasks using Macros and Basic VBA programming
Protect Worksheets and Workbooks to Secure Sensitive Information
Perform error checking and tracing to ensure Data Accuracy.
Explore Advanced Formatting options for better Data presentation
Learn time-saving techniques like text-to-columns and working with links
Enhance collaboration by inserting comments and managing named ranges
Utilize various Excel tools and functions to streamline workflow and analysis
Access to a Professional Trainer with 10+ years of Excel Training
Screenshots
Related Topics
1289248
udemy ID
7/12/2017
course created date
2/8/2020
course indexed date
Bot
course submited by