£79.00
Description
Our Online Intermediate Excel Course is provided in partnership with a Microsoft Certified Academy. It aims to give you a strong foundation in using Microsoft Excel, which is vital for Finance, Bookkeeping, and Accounting careers. Excel is a vital skill for anyone looking to work in Finance. This increases your ability to work with numbers and large data sets. There are very few financial jobs that will not require strong Excel skills.
Intermediate Excel Course
This is an online Excel course. Our Excel Courses are delivered using a Virtual Tutor function inside the program. The training system uses a state-of-the-art live server. It will instruct you, provide exercises and worked examples, and correct your exercises. A CPD Assessment is available upon completion.
Course Content
The Intermediate Level Excel Course includes:
- Perfecting charts
- How to build and control tables
- Managing data in a table
- Automatic filtering and calculations in a table
- Duplicates and empty cells
- Data Analytics
- Filtering using a range of criteria
- Range of criteria
- Filtered rows
- Display several lines of data in a single cell.
- Edit formula with absolute referencing
- Values can be copied, linked, or transposed.
- Shift, copy, and conceal sheets.
- Move, copy, delete, and select items.
- Text in charts should be changed
- Chart templates.
- Establish and maintain sparklines
- Modify a text box or a drawing.
- Stack, rotate, align, and group objects.
- Implement and control conditional custom formats
- Validation Criteria
- Data conversion and data series creation
- Cell ranges are used in functions.
- Describe data in summary.
- Make a cell commendable.
- Using the copied values, calculate.
Dates and Duration
This training course is entirely flexible and can be commenced at any time. You can study when you like and have access to the learning system for 12 months. The average learning hours for completion are 8 hours.
Course Requirements
This is at the intermediate level, so you must have already acquired the skills from the Beginner Excel Course. We offer more advanced levels.
Benefits
- The interactive course is delivered using a state-of-the-art training system in partnership with a Microsoft Certified Academy.
- MOS experts and Finance professionals have developed the course content
- Gain vital skills to build your career in Finance or similar industry
- Increase your efficiency at work and open up opportunities
- Gain a certificate with CPD points for the accounting or professional body that you belong to
- CPD Accredited Certification in Microsoft Excel on successful completion