top of page
strip.png
free course-min (1).png

FIN 115 Main Exam

Introduction To Excel Masterclass Course

Introduction

Videos in full course:

Beginner
Videos

Video Name
Create a New Workbook
Navigating workbooks
Using & editing a Workbook
Learning Formulas and Functions
Selecting Cell Ranges
Copying Data in Excel
Special Pasting in Excel
Moving Data in Excel
Formatting in Excel
Applying Borders in Excel
Cell Alignment in Excel
Format Rows and Columns
Formatting Numbers
Page Setup in Excel

Intermediate
Videos

Video Name
How To Use Flash Fill & Fill Series in Microsoft Excel
How To Use Relative & Absolute Formula References
How To Use Named Ranges in Microsoft Excel
The important excel formulas you need to know
Logical Functions In Excel (IF / AND / OR / Nesting)
How To Use Date and Time Functions In Excel
How To Use Conditional Formatting In Excel
Working With A Workbook
Tabs - Moving, Duplicating, Grouping - Intermediate Course
Finding and Replacing Data In Excel (Replace Blanks, formulas, formatting)
Importing and Exporting Data In Excel
Filtering & Sorting Data
Creating Charts in Excel
Chart Elements
Chart Object Formatting

Advanced
Videos

Video Name
Custom Advanced Options In Excel! - Unit 1 Advanced Excel Cours
Lookup Functions in Excel (Index Match / Offset / Indirect) - Advanced Excel Course Unit 2
Text Functions in Excel (Left / Right / Proper / Len / Find / Concatenate) - Unit 3 Advanced Course
Information Functions - Excel Advanced Unit 4
How to write complex formulas in Excel - Advanced course Unit 5
What-If Analysis In Excel - Goal Seek, Scenario Manager, Data Tables (Adv#6)
Data Linking in Excel - Unit 7 Advanced Excel Course
Data Consolidation - 3D Sum + Consolidate Feature - Excel Advanced Unit 8
How To Password Protect Excel - Advanced Excel Unit 9
gren bottom.png

Beginnners

For new users who need to learn the basics of Excel.

strip.png

Create a New Workbook

Navigating workbooks

Intermediate
gren bottom.png

Intermediate

Intermediate videos are for users who are familiar with the basics.

strip.png

How To Use Flash Fill & Fill Series in Microsoft Excel

How To Use Relative & Absolute Formula References

gren bottom.png

Advanced

Advanced videos are for those who have stronger Excel skills

Advanced
strip.png

Custom Advanced Options In Excel! - Unit 1 Advanced Excel Cours

Lookup Functions in Excel (Index Match / Offset / Indirect) - Advanced Excel Course Unit 2

logo_transparent.png

End Of Free Course

full course-min.PNG

Let's Get Started!

bottom of page