Skip to content

Home
Courses
Sign in

Microsoft Excel Masterclass

By Courselord Academy / October 9, 2023

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Beginner’s guide for Microsoft Excel 2010, 2013, 2016, 2019.

Course Content

Expand All

Microsoft Excel Foundamentals 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Introduction to Excel Interface

Understanding the Structure of an Excel Workbook

Saving an Excel Document

Opening an Existing Excel Document

Common Excel Shortcut Keys

Entering and Editing Text and Formulas 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Entering Text to Create Spreadsheet Titles

Working with Numeric Data in Excel

Entering Date Values in Excel

Working with Cell References

Creating Basic Formulas in Excel

Relative Versus Absolute Cell References in Formulas

Working with Excel Function 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Structure of Excel Function

Working with the MIN() and MAX() Functions

Working with the AVERAGE() Function

Working with the COUNT() Function

Adjacent Cells Error in Excel Calculations

Using the AutoSum Command

Modifying an Excel Worksheet 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Moving and Copying Data in an Excel Worksheet

Inserting and Deleting Rows and Columns

Changing the Width and Height of Cells

Hiding and Unhiding Excel Rows and Columns

Renaming an Excel Worksheet

Deleting an Excel Worksheet

Moving and Copying an Excel Worksheet

Formatting Data in an Excel Worksheet 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Working with Font Formatting Commands

Changing the Background Color of a Cell

Adding Borders to Cells

Formatting Data as Currency Values

Formatting Percentages

Merging and Centering Cells

Inserting Images and Shapes into an Excel Worksheet 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Inserting Images

Inserting Excel Shapes

Formatting Excel Shapes

Creating Charts in Excel 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Creating an Excel Column Chart

Adding and Modifying Data on an Excel Chart

Formatting an Excel Chart

Working with Excel Pie Charts

Protecting Excel Worksheets and Workbooks 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Protecting Specific Cells in a Worksheet

Protecting the Structure of a Workbook

Adding a Workbook Password

Printing an Excel Worksheet 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Viewing your Document in Print Preview

Changing the Margins, Scaling and Orientation

Working with Page Layout View

Adding Header and Footer Content

Printing a Specific Range of Cells

Home
Courses
Sign in

"We are committed to transforming
lives through simplified online courses."
Utibe Inyang - Founder/CEO

© 2024 Courselord™ ~ a business of Wizkid Infotech | All Rights Reserved.

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Accept