Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Beginners Course to learn how to use Microsoft Excel, Master the Fundamentals of Microsoft Excel as a Beginner.
Excel expert Michael Bouwer helps new users of Microsoft Excel from the most fundamental and basic principles all the way to creating their own worksheets with functioning formulas and references.
This course guides you through some of the most common knowledges, that is not so common to all.
No prior knowledge of Excel required.
Michael have experienced thousands of users that simply don't know about the essential principles covered in this course, and so miss out on a multitude of Excel functionality.
If you want to become proficient or even just a great user of Microsoft Excel, then this course comes highly recommended.
Topics include:
Understanding the Excel Layout and Screen with Menus
Simple Data Entry Techniques
Creating Formulas and Common Functions
Understanding Formatting Tools and Worksheet Manipulation
Printing
Creating and Editing Charts and its elements
Adjusting your View as well as working with Multiple Worksheets and Workbooks
Some Advanced Functions, such as IF, VLOOKUP and COUNTIF Family of Functions
How to Protect your Worksheets and Workbooks
Features to do Proper Data Management
Tools for Data Analysis
Entire Module Dedicated to PivotTables, from Creation to Manipulation to Charting
An Introduction to Macros
All the Resource Files are provided which can be downloaded for free.
Course Content
- 16 section(s)
- 69 lecture(s)
- Section 1 What is Excel Used For
- Section 2 Basic Navigation around Excel Interface
- Section 3 Data Entry into Excel
- Section 4 Creating and Mastering Formulas and Functions
- Section 5 Formatting Features in Excel
- Section 6 Adjusting The Worksheet Layout to Suit You
- Section 7 Printing Basics in Excel
- Section 8 Charting Basics in Excel
- Section 9 Adjusting Worksheet Views in Excel
- Section 10 Working with Multiple Worksheets and Workbooks
- Section 11 Advanced Formulas (IF, VLOOKUP & COUNTIF family)
- Section 12 Protection and Passwords
- Section 13 Basic Data Management Features
- Section 14 Basic Data Analysis Tools
- Section 15 PivotTables Basics in Excel
- Section 16 Basic Introduction to Macros
What You’ll Learn
- How to Use Microsoft Excel as a Complete Beginner
- From Basic Navigation to Entering Data and Creating your Own Formulas and Functions
- To Understanding Formatting, and Adjusting Your Layouts and Views and Printing
- Learning How To Create Charts and Tables and Other Management Features
- Protecting Your Precious Files and Worksheets and Analysis Tools like Add-Ins
- All the Way to Everything about PivotTables and even an Introduction to Macros
Skills covered in this course
Reviews
-
DDavid Ault
Yes, I wasn't aware there were so many preset templates for Excel
-
SSarah Campbell
Yes, looking froward to learning all about Excel
-
NNiamh King
Great course
-
AAlix Dykman
Yes it was a good match.