Excel from A to Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2023
What you will learn
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Access to a Professional Trainer with 10+ years of Excel Training
Maintain large sets of Excel data in a list or table
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Build a solid understanding on the Basics of Microsoft Excel
Master Microsoft Excel from Beginner to Advanced
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!
Content