Excel for Beginners – Rolives Tech Academy

About Course

Master the basics of Excel – Fast!

Learn essential Excel skills in a fun, beginner-friendly course. From formulas to formatting, you’ll gain the confidence to organise data, create spreadsheets and boost productivity in no time!

Whether you’re a student, job seeker, small business owner, or just tired of being confused by spreadsheets, this course is for YOU!

Excel interface & navigation
Creating and formatting spreadsheets
Entering and editing data
Formatting cells: fonts, colours, borders, alignment
Working with numbers & basic Calculations
Introduction to formulas and functions - How to write and apply formulas
Common functions: SUM, AVERAGE, MIN, MAX, and COUNT
Sorting, filtering, and organising data
Using filters to find information quickly
Basic charts and graphs - creating simple bar, column, and pie charts
Intro to conditional formatting - highlighting cells based on rules
Tips, tricks & shortcuts
...And much more.

Course Content

Welcome
Master the Basics of Excel – Fast! Learn essential Excel skills in a fun, beginner-friendly course. From formulas to formatting, you'll gain the confidence to organise data, create spreadsheets, and boost productivity in no time!

Welcome to Excel for beginners Masterclass

02:04
What is Excel?

01:15
How to get Excel

02:28

Excel Main Interface

Data Entry into Excel

Saving Workbook

Formatting, Layout and Design

Basic Formulas and Functions

Charts and Graphs

Basic Sorting and Filtering

Basics of Pivot Tables

Flash fill

Worksheet Views

Working with Multiple Worksheets and Workbooks

Share and Collaborate with Others

How to Print in Excel

Wrapping Up

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Welcome Master the Basics of Excel – Fast! Learn essential Excel skills in a fun, beginner-friendly course. From formulas to formatting, you'll gain the confidence to organise data, create spreadsheets, and boost productivity in no time!

Welcome to Excel for beginners Masterclass

What is Excel?

How to get Excel

Excel Main Interface

Excel Start screen

Workbook and worksheet

Tabs, Ribbons and Segments

Navigating a worksheet

Navigating a workbook

How to get help

Data Entry into Excel

How to enter data

Row height and column width

Basic data types

Dates and times

Select cells to enter data quickly

Saving Workbook

Save workbook

Benefits of saving a workbook in the cloud

Formatting, Layout and Design

Basic formatting – part 1

Basic formatting – part 2

Basics of Tables

Insert rows and columns

Basic conditional formatting

Hide rows and columns

Find and Replace

Basic Formulas and Functions

Basic metrics on Status bar

How to enter a basic addition and subtraction formulas

Multiplication and Division in Excel

How to repeat formulas quickly

Absolute and relative cell referencing

Order of operations

Common functions – MAX, MIN, SUM, COUNT and AVERAGE

Charts and Graphs

Charts and graphs

Insert and format charts

Pie charts

Basic Sorting and Filtering

Sort

Filter

Basics of Pivot Tables

Pivot tables

Flash fill

Separate data with flash fill

Merge data using flash fill

Worksheet Views

Worksheet views

Freeze panes

Working with Multiple Worksheets and Workbooks

Add and delete worksheets

How to rename and colour worksheets

Hide and unhide worksheets

Move and copy worksheets

Grouping worksheets

Share and Collaborate with Others

Protect worksheet

Protect workbook

Password-protect workbook

Share workbook

Version history

How to Print in Excel

Print selection

Set print area

Hide column from printing

Page settings for printing

Adjust columns for printing

Repeat column headers on pages

Hearders and footers

Show and hide gridlines

Page break view

Wrapping Up

Conclusion

Student Ratings & Reviews

Resources

Welcome
Master the Basics of Excel – Fast! Learn essential Excel skills in a fun, beginner-friendly course. From formulas to formatting, you'll gain the confidence to organise data, create spreadsheets, and boost productivity in no time!