Accredited Microsoft Excel Complete Course - Beginner, Intermediate & Advanced Levels - CPD Certified
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Class hours
31h
-
Duration
Flexible
-
Start date
Different dates available
Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is a useful software you can use to solve your problem. If you want to learn the complete guide on how to become a professional user on Microsoft Excel, then this is the course for you.
With Microsoft Excel, you can manage more data than ever, with increased worksheet and workbook sizes. Build great charts, use conditional formatting, help identify the trends and bring data together by using Excel. Gain access to new features such as sparklines, improved pivot charts, slicer, Access spreadsheets from anywhere and much more.
Whether you are a beginner or an advanced level user at Microsoft Excel, this course will help you. You will be able to learn all the relevant information on how to analyze numbers, keep track of data, and graphically represent your information using various charts.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Excel
- Access
- Auditing
- Microsoft Excel
- Accredited
- Microsoft excel training
- Using excel
- MS Excel
- Macros
- Sharing Workbooks
- Using Quick Analysis
- Solving Formula Errors
Teachers and trainers (1)
iStudy iStudy
Instructor
Course programme
COURSE CURRICULUM
Microsoft Excel - Beginners
- Module One – Getting Started
- Module Two – Opening and Closing Excel
- Module Three – Working with the Interface
- Module Four – Your First Worksheet
- Module Five – Viewing Excel Data
- Module Six – Building Formulas
- Module Seven – Using Excel Functions
- Module Eight – Using Quick Analysis
- Module Nine – Formatting Your Data
- Module Ten – Using Styles, Themes, and Effects
- Module Eleven – Printing and Sharing Your Workbook
- Module Twelve – Wrapping Up
- Activities – Microsoft Excel for Beginners-
Microsoft Excel - Intermediate Level
- Module One – Getting Started
- Module Two – Working with Permissions and Options
- Module Three – Sharing Workbooks
- Module Four – Performing Advanced Formula and Function Tasks
- Module Five – Working with Array Formulas
- Module Six – Working With Macros
- Module Seven – Working With Forms
- Module Eight – Applying Advanced Chart Features
- Module Nine – Working With Slicers and Timelines
- Module Ten – Working With Multiple Tables, Relationships, and External Data
- Module Eleven – Working With PowerView
- Module Twelve – Wrapping Up
- Activities- Microsoft Excel Intermediate Level-CPD QS & IAO Accredited
Microsoft Excel - Advanced Level
- Module One – Getting Started
- Module Two – SmartArt and Objects
- Module Three – Auditing
- Module Four – Creating Charts
- Module Five – Working with Charts
- Module Six – Creating Pivot Tables and Pivot Charts
- Module Seven – Macros
- Module Eight – Solving Formula Errors
- Module Nine – Using What If Analysis
- Module Ten – Managing Your Data
- Module Eleven – Grouping and Outlining Data
- Module Twelve – Wrapping Up
- Activities-Microsoft Excel Advanced Level
Accredited Microsoft Excel Complete Course - Beginner, Intermediate & Advanced Levels - CPD Certified