This Microsoft Excel Certificate Course The Business Management course will provide you with the tools you need to master Excel in depth, from the basics to advanced use of features and tools such as Power BI. In a world where efficient data management is key to business success, having strong Excel skills is essential. And that’s where we come in! With an industry that’s constantly growing and rising demand for professionals with Excel skills and Business Intelligence, this diploma course will open the door to career opportunities. Through this remote, online programme, you’ll learn how to work with data efficiently, create striking visualisations and automate tasks.
Cross-cutting
Digital Skills
65 hours
Microsoft Excel for Business Management
Digital Skills
65 hours
Introduction
Objectives
-
Mastering the environment of Excel to manage documents efficiently.
-
Apply formatting and conditional statements to present data effectively.
-
Learning formulas for carrying out advanced calculations.
-
Create customised graphics to present data in a visually appealing way.
-
Use advanced features to analyse data accurately.
-
Understanding data visualisation using tools such as Power BI.
-
Managing tables and lists data to organise the information clearly.
Table of Contents
TEACHING UNIT 1. THE EXCEL INTERFACE AND THE RIBBON
General concepts
The Excel Environment
Saving and opening documents
TEACHING UNIT 2. BASIC TASKS WHEN WORKING WITH DATA
Working with data
Getting Started
Data entry
Insert, delete and move
Undo and redo
Spelling check
TEACHING UNIT 3. BASIC AND CONDITIONAL FORMATS
Presentation of the data
Title formats
Background
Conditional formatting
Styles and themes
Protect the blade
TEACHING UNIT 4. WORKING WITH FORMULAS I
An Introduction to Formulas
What is a formula?
Automatic calculations
Formula editions
Names and titles
TEACHING UNIT 5. WORKING WITH FORMULAS II
An Introduction to Functions
What is a function?
Introduction to functions
Function categories
TEACHING UNIT 6. PRINTING AND SHARING SPREADSHEETS
Printing or publication
Printing
Publication
TEACHING UNIT 7. GRAPHICAL REPRESENTATION OF DATA
Create a Chart
Customising the Chart
TEACHING UNIT 8. WORKING WITH DATA SPREAD ACROSS SEVERAL SHEETS
Data spread across several sheets
Sample invoice
3D references
Managing the pages of a book
References to other books
TEACHING UNIT 9. LISTS AND DATA TABLES
Data entry
Sorting and Grouping Data
Data filtering
Data tables
TEACHING UNIT 10. HOW TO RECORD AND USE MACROS
An Introduction to Macros
What is a macro?
Enter sequences of days
Assigning a macro to a button
Define new functions
Macros and security
TEACHING UNIT 11. INTRODUCTION TO DATA VISUALISATION
What is data visualisation?
The importance of data visualisation and the tools involved
Data visualisation: Basic principles
TEACHING UNIT 12. POWER BI
Introduction to Power BI
Installing Power BI
Data modelling
Data visualisation
Dashboards
Data sharing
More related courses
Cross-cutting
Cross-cutting
Cross-cutting
Cross-cutting
55 hours