Basic Microsoft Excel
Online | Intermediate | 4Hours
Basic Microsoft Excel
Basic Microsoft Excel
Course Overview
Demystify Microsoft Excel in four hours.
This online course contains four hours of basic Excel training split across-22 modules. If you’re new to Excel or have limited knowledge of Excel, this course is for you.
Why Excel matters:
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
• Easy to follow
• Gets you the results you want
• Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
What you get with this Microsoft Excel course:
• 22 modules of training (full syllabus below), covering the most business-relevant areas of Microsoft Excel.
• Taught via video, downloadable practice exercises and mini tests.
• You’ll have a basic understanding of Microsoft Excel after taking this course.
In this course you’ll learn:
• Data entry
• Text and number formats
• Basic mathematical functions (SUM, AVERAGE)
• Editing skills, including Flash Fill
• Basic data analysis skills through sorting and filtering.
• Printing spreadsheets
Version: Excel 2013 used in examples but applicable to all PC Excel versions
More about us:
• We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
• We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
• Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
• Our platform is award-winning and improving all the time.
If you are not 100% happy with your EwB Basic Microsoft Excel course, you have 30 days to exchange or refund.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).
Syllabus:
Section 1: Basic Skills
▸
Unit 1.1 - Excel Introduction
▸
Unit 1.2 - The Excel Interface
▸
Unit 1.3 - Accessing and Saving Files
▸
Unit 1.4 - Read and Enter Data
Section 2: Efficiency of Use
▸
Unit 2.1 - Keyboard Shortcuts
▸
Unit 2.2 - Editing
Section 3: Data Analysis
▸
Unit 3.1 - Basic Arithmetic
▸
Unit 3.2 - Sorting and Filtering
Section 4: Presentation
▸
Unit 4.1 - Setup and Printing