Online Course Microsoft Excel
Microsoft Excel is popular in almost every office, school, and home across the globe
Whether you want to document data and records at work or keep track of expenses at home, our Excel training will help you to do so quickly and easily.
Excel's full potential can be utilised by taking the following approach:
Explore the Excel landscape and understand the primary tools it features.
Employ the most essential Excel equations and functions.
Classify, examine, and discuss information
Create tables, documents, graphs, and graphs.
Create your worksheets and statistics with a visual approach.
Recommended Study Duration: 30 hours. Completion grants you 30 CPD points. See the Certification section for more information.
Module 1: Understanding Your Excel Software
When it's appropriate to utilise Excel.
How to traverse its complex interface
How to comprehend the organisation
How to utilise the ribbon in Excel.
Common format
Module 2: The Execution of Formulas and Functions
Learning the Basics of Excel Formulas
Mathematical Operations and Conditions
Functional Statistics
Date and Time
Philosophical Functions
Exercise: Using formulas in the real world.
Module 3: Organising and Evaluating Data
How to Organise Data and utilize Filters
Using Macros to automate tasks.
Creating Pivot Tables
Auditing the formulas and tasks
Module 5: Exposure
Font and Numbering
Implementing Borders
Incorporating colour into the data is more effective than simply adding numbers.
Merging, Wrap, and Indents
Conditional formatting
Handling of sheets, sections, and tables.
Module 5: Creating Charts and Graphs
Creating and Reading Excel Charts in an overview
Column Charts and Bar Graphs
Line graphs
Pie Datasets
How to Transform Your Charts into a Powerful Presentation.
Career
Who is this educational program intended for?
All employees in the office and administrative category
Business owners and executives
Anyone who wishes to collect and maintain data, regardless of its purpose, must learn how to do so.
Career route
Study Excel online and utilise it as a stepping stone to a career as an administrative assistant, accountant, project manager, or financial or business analyst.
