Microsoft Excel - Excel from Beginner to Advanced + Macro
Description:
Microsoft Excel in One Package :
This Microsoft Excel course combines 6 different courses.
Microsoft Excel - Overview
Microsoft Excel - Custom and conditional formatting
Microsoft Excel - Advanced functions and formulas
Microsoft Excel - Create a chart on Excel
Microsoft Excel - Data analysis
Microsoft Excel - Introduction to VBA & Macros
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023
Enroll now to go through a deep dive into the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 11+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you participate in each of the 6 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics.
At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
SUM
SUMIF
COUNT
COUNTIF
AVERAGE
ROUND
CONCATENATE
INDEX
OFFSET
MATCH
TRIM
LEN
SQRT
IF
AND
TODAY
QUICK ACCESS BAR
CONDITIONAL FORMATTING
LOGICAL EXCEL
IFERROR
IFNA
NESTED
TEXT
LOWER & UPPER
RANDBETWEEN
NAMED RANGES
VLOOKUP
HLOOKUP
TRACE PRECEDENTS AND DEPENDENTS
ERROR CHECKING
TEXT TO COLUMN
DATA VALIDATION
WHAT-IF TOOLS
DUPLICATE REMOVAL
WRAP TEXT
MERGE CELL
LARGE
CHART IN EXCEL
DATA ANALYSIS
MACRO
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel beginner to Excel professional!