Microsoft Excel (Basic)
Demystify Microsoft Excel in four hours.
In this course you will learn:
- Data entry
- Text and number formats
- Essential mathematical functions (SUM, AVERAGE)
- Editing skills, including Flash Fill
- Basic data analysis skills through sorting and filtering.
- Printing spreadsheets
+ SECTION 1 | BASIC SKILLS - 9 MODULES
Unit 1 | Excel Introduction
1. The Point of Excel
Unit 2 | The Excel Interface
1. The Excel Screen and Interface
2. Spreadsheet and Views
Unit 3 | Accessing and Saving Files
1. The File Tab
2. File Naming
3. Backup Policy
Unit 4 | Read and Enter Data
1. Entering Text and Numbers
2. Formatting Text and Numbers
+ SECTION 2 | EFFICIENCY OF USE - 7 MODULES
Unit 5 | Keyboard Shortcuts
1. Selection and Navigation
2. Common Tasks
Unit 6 | Editing
3. Inserting, Deleting, and Clearing
4. Fill Handle
5. Flash Fill
+ SECTION 3 | DATA ANALYSIS - 3 MODULES
Unit 7 | Basic Arithmetic
1. Basic Maths
Unit 8 | Sorting and Filtering
1. Sorting Data
2. Applying Filters
+ SECTION 4 | PRESENTATION - 3 MODULES
Unit 9 | Setup and Printing
1. Displaying Spreadsheets as Pages
2. Adjusting Page Setup
3. Finally, Printing!
About the author
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.