Microsoft Excel

4.70 (10 Ratings)

Enrolled:121

Level

Beginner
Duration

8 hours
Last Updated

August 8, 2024
Enrollment validity

Enrollment validity: 365 days
Certificate

Certificate of completion

About Course

This course will equip you with the skills and knowledge to effectively utilize Excel for data analysis, financial modeling, spreadsheet creation, and various functions and calculations. From basic workbook skills to advanced data manipulation and presentation techniques, you'll learn how to perform data analysis tasks, format data, and cells, utilize formulas and functions, apply logical functions, and more. This course is part of the BFI Insights Data Analysis Expert School pathway, which also includes SQL, R, Python, Power BI, and Tableau, providing you with a comprehensive set of tools to excel in data analysis and reporting. No prior knowledge is required, as we'll start from the basics and gradually progress to more advanced topics. Get ready to enhance your data analysis skills with Microsoft Excel!

Getting started with Excel's interface, creating, saving, and managing workbooks.
Handling worksheets, columns, and rows efficiently.
Using basic formulas for calculations and formatting cells for better appearance.
Quick data entry, auto-fill, and optimizing page settings.
Sorting data, applying filters, and securing sheets/workbooks.
Adding navigation links and combining data from various ranges.
Using shortcuts for efficiency and advanced data formatting techniques.
Setting data entry rules and applying logical functions.
Exploring a wide range of Excel functions and using LOOKUPs.
Creating visual charts, graphs, and utilizing complex formulas.
Custom sorting, advanced filtering, data merging, and enhancing security.
Understanding techniques to visualize data effectively using charts and graphs.

Course Curriculum

Beginner – Introduction to Microsoft Excel

Introduction

01:01
About the Course

00:22
Course Outline

04:58
What is Microsoft Excel

00:56
Excel – Applications

01:35

Beginner – Basic Workbook Skills

Beginner – Managing Worksheets

Beginner – Working with Columns and Rows

Beginner – Creating simple formulas

Beginner – Formatting Data and Cells

Beginner – Filling

Beginner – Page Setup

Beginner – Sort & Filters

Beginner – Protection

Beginner – Hyperlink

Beginner – Consolidate

Beginner – Logical Functions

ASSESSMENTS – 1
Please download the Excel workbook provided in this session. The workbook consists of three worksheets, all containing ten tasks marked in red. Your objective is to complete these tasks. Note that you are to make input in the grey-shaded cells. It is important to note that you must fulfill these tasks in order to successfully complete the course. Once you have completed the tasks, please upload the finished workbook by clicking on the designated "Start Assignment Submit" button.

Intermediate – Keyboard shortcuts

Intermediate – Data Formatting techniques

Intermediate – Data Validation Technique and Named Range

Intermediate – Excel Functions and Formulas

Intermediate – Lookup

Download Practice File Here!
Introduction

00:30
VLOOKUP with Exact Match

08:38
VLOOKUP With Approximate Match

06:05
VLOOKUP Rules and Examples

04:26
HLOOKUP

02:45
LOOKUP Funcion

04:53
MATCH Function

03:43
INDEX Function

02:27
INDEXMATCH – Function

03:27
INDEXMATCH – Examples

04:04
XLOOKUP Function

07:11

Intermediate – Data Presentation Techniques

ASSESSMENTS – 2
Please download the Excel workbook provided in this session. The workbook consists of six worksheets, all containing ten tasks marked in red. Your objective is to complete these tasks. Note that you are to make input in the grey-shaded cells. It is important to note that you must fulfill these tasks in order to successfully complete the course. Once you have completed the tasks, please upload the finished workbook by clicking on the designated "Start Assignment Submit" button.

Microsoft Excel

About Course

What will I learn?

Course Curriculum

Beginner – Introduction to Microsoft Excel

Introduction

About the Course

Course Outline

What is Microsoft Excel

Excel – Applications

Beginner – Basic Workbook Skills

Download Practice File Here!

Introduction

The Excel Interface

Inputting Values into a cell

Open, Save and Close Workbook

Beginner – Managing Worksheets

Introduction

Naming, Adding and Deleting a Worksheet

Grouping Worksheet

Moving and Copying a Worksheet

Moving Around a Worksheeet

Beginner – Working with Columns and Rows

Download Practice File Here!

Introduction

Selecting, Inserting and Deleting Column and Row

Adjusting Column Width and Row Height

Hiding and Unhiding Column & Row

Grouping and Ungrouping Column & Row

Editing a Data

Using the Freeze Pane

Beginner – Creating simple formulas

Download Practice File Here!

Introduction

Excel Order of Operation

Sum and Autosum with Other Basic Functions

Average, Min and Max Functions

Beginner – Formatting Data and Cells

Download Practice File Here!

Introduction

Formatting

Round, Round Up, and Round Down

Comment

Beginner – Filling

Download Practice File Here!

Introduction

Copying & Filling

Fill Series

Fill Series

Flash Fill

View Files Side by Side

Comparing Two Worksheets Side by Side

Beginner – Page Setup

Introduction

Download Practice File Here!

Print Page Setup

Header and Footer

Beginner – Sort & Filters

Introduction

Download Practice File Here!

Data Sorting

Advanced Filter

Filtering Data

Beginner – Protection

Introduction

Download Practice File Here!

Protect File

Protect Workbook

Protect Worksheet

Protect Cells

Beginner – Hyperlink

Download Practice File Here!

Hyperlink to Webpage

Hyperlink to File

Hyperlink to Sheet

Beginner – Consolidate

Download Practice File Here!

Introduction

Consolidation I

Consolidation II