Excel for Accountants (Basic)
This short course aims to take you from a novice to an expert in under 2 hours!
Excel is incredibly powerful, and a key skill that any budding accountant or accountancy professional should become familiar with. For financial insight and analysis, crunching numbers and compiling non-numerical data, Excel continues to be the tool of choice throughout the accounting and finance field.
Learning to excel at Excel is a great accounting career move. With so much functionality it’s easy to get overwhelmed when you are starting out. We take the pain out of mastering the basics of Excel and building a solid foundation.
In this course you will learn:
- Worksheet organisation and navigation tips
- Understanding Number and Date Formatting
- Conditional Formatting
- Constructing Formulas using Basic Functions
- The Importance of Absolute Cell References
- Sorting and Filtering Data
- Looking beyond simple Paste
- The advantages of naming Ranges
- Manipulating data with Text Functions
- The magic of Flash Fill
+ SECTION 1 | INTRODUCTION - 1 MODULE
Unit 1 | Getting Started
+ SECTION 2 | THE BASICS - 1 MODULE
Unit 2 | Setting up for Success
+ SECTION 3 | FORMATTING TEXT AND NUMBERS - 2 MODULES
Unit 3 | Working with Number and Date Formatting
Unit 4 | Formatting Based on Conditions
+ SECTION 4 | GETTING STARTED WITH FUNCTIONS AND FORMULAS - 2 MODULES
Unit 5 | Basic Functions and Formulas
Unit 6 | Absolute, Relative and Mixed Cell References
+ SECTION 5 | ORGANISING DATA - 1 MODULE
Unit 7 | Organising Data for Quicker Analysis
+ SECTION 6 | THE POWER OF PASTE - 1 MODULE
Unit 8 | Exploring Paste Options
+ SECTION 7 | A RANGE BY ANY OTHER NAME - 1 MODULE
Unit 9 | Naming Cells and Ranges
+ SECTION 8 | EXTRACT OR COMBINE DATA - 2 MODULES
Unit 10 | Manipulating Data Efficiently
1. Manipulating Data with Text Functions
2. The Magic of Flash Fill
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.
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.