
Explore basic predefined functions in Excel, including min, max, average, round, left, right, length, and square root, with practical examples on balance data and column-wide applications.
Learn Excel date and time functions, including today, end of month, networkdays, and weekday. Create valid dates from year and day components and compare dates with date difference.
Explore string functions in Excel, including find, replace, substitute, mid, search, and concatenate, and apply practical data-analysis techniques using data analysis expressions.
Learn essential Excel mathematical functions for data analysis, including product, modulus, square root, factorial, rounding, and conditional sums and averages.
Explore Microsoft Excel lookup functions, including vlookup and hlookup, edge lookup, match, and index, with practical examples that show leftmost column searches, table arrays, and horizontal versus vertical lookups.
Master Excel logical and error functions to test multiple conditions with and/or/not, build derived categories using nested if blocks, and handle common errors like division by zero.
Explore Excel's statistical functions, including count, count blank, count if, mean, median, mode, correlation, standard deviation, and variance, to analyze numerical and categorical data and handle null values.
Learn how to insert and format images in Excel cells, including logos in a data table, and move and size with cells for sorting and filtering.
Learn the basics of Excel formatting, including fonts, borders, filling, alignment, and number, date, and time formats, to prepare data for analysis and beautify reports.
This training provides you everything you need to know about Microsoft Excel.
From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.
In only six hours of videos, provided to you in multiple separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:
Learn how to navigate around Excel
Learn basic, conditional & custom formatting
Learn various Datetime, Statistical & Mathematical functions in Excel
Learn how to perform Data Analysis in Excel
Learn about What-If tools
Learn VLOOKUP & HLOOKUP functions
This class is guaranteed to teach you Microsoft Excel.
Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.
Recent Student Review from my other courses
"Really great into to Tableau! Having never used it before I feel much more confident now and looking forward to the advance course."
"I think the course covers everything you need to know to get started with playing around in Tableau. The actual test of your knowledge would be when you actually use this with real-time data and develop dashboards and presentations."
"This is what i truly needed ,thank you so much for making this course so easy."
Who this course is for:
This Microsoft Excel courses will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, & Advanced)
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
This course will help you understand various concepts of MS Excel that is required to perform Data Analysis.