Introduction to Excel Tips and Tricks
Before starting the Excel Tips And Tricks course let us know some basic introduction. Microsoft Excel is a spreadsheet software developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software
Requirements
- No Previous Excel Knowledge is Required OR there is no pre-requisite.
- Microsoft Excel 2007, 2010, 2013, 2019, and Microsoft Excel 365 are available / installed on a Computer to follow along with tutor and practical exercises.
Description
This Microsoft Excel course combines 4 different courses.
- Microsoft Excel 01 – An Introduction to Excel
- Microsoft Excel 02 – Intermediate Level Excel
- Microsoft Excel 03 – Advanced Level Excel
- Master Microsoft Excel Macros and VBA in 10 Simple Projects
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, and 2019 & Microsoft Office Excel 365
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 15 + years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you take part in each of the 4 modules you will master Excel tools that will enable your to tackle 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 boost up with the confidence to complete any Excel tasks with confidence and grace. Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more…)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day-to-day Excel tasks by mastering the power of Macros and VBA
What’s Included?
- 18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)
- Downloadable Exercise Files to follow along and practice with
- Additional Exercise Files are provided at the end of each major section that you can download and practice the skills you’ve learned
- Section Quizzes to Test Your Knowledge of the Lecture Topics
- QA board where you can post questions, and screenshots of your progress and communicate with the instructor and fellow students in the course.
So, what are you waiting for, subscribe now and take the next step in mastering Excel to be Excel Guru!
Who MS Excel Tips And Tricks Course is for:
- These Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced, and Macros/VBA).
- If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.