Topic 1 Overview – Ecertte | E-Certification, Training & Education Ltd.

Introduction

0/2

What is Microsoft Excel?

Course Overview

Topic 1 – The Excel Interface

0/5

Topic 1 Overview

Lesson 1.1 – The Backstage View

Lesson 1.2 – The Ribbon

Lesson 1.3 – The Worksheet Interface

Topic 2 – Creating and modifying worksheets and workbooks

0/7

Topic 2 Overview

Lesson 2.1 – Creating worksheets and workbooks

Lesson 2.2 – Modifying Worksheets

Lesson 2.3 – Moving worksheets

Lesson 2.4 – Saving and opening workbooks

Lesson 2.5 – Undo, redo, repeat, and version history

Topic 3 – Rows, columns, and cells

0/8

Topic 3 Overview

Lesson 3.1 – Understanding rows, columns, and cells

Lesson 3.2 – Inserting rows, columns, and cells

Lesson 3.3 – Adjusting rows, columns, and cells

Lesson 3.4 – Deleting rows, columns, and cells

Lesson 3.5 – Merging and unmerging cells

Lesson 3.6 – Hiding and unhiding rows and columns

Topic 4 – Formatting and styling data

0/7

Topic 4 Overview

Lesson 4.1 – Cell formatting

Lesson 4.2 – Number formats

Lesson 4.3 – Cell styles

Lesson 4.4 – Conditional formatting

Lesson 4.5 – Themes

Topic 5 – Copying and pasting data

0/5

Topic 5 – Overview

Lesson 5.1 – Copying, cutting, and pasting data

Lesson 5.2 – Paste options

Lesson 5.3 – The Clipboard

Topic 6 – Finding and replacing data

0/4

Topic 6 – Overview

Lesson 6.1 – Finding data

Lesson 6.2 – Replacing data

Topic 7 – Basics of formulas and functions

0/5

Topic 7 – Overview

Lesson 7.1 – Formula basics

Lesson 7.2 – Cell referencing

Lesson 7.3 – Function basics

Topic 8 – Auto Fill

0/5

Topic 8 – Overview

Lesson 8.1 – Filling values, dates, and patters

Lesson 8.2 – Adjusting Auto Fill

Lesson 8.3 – Filling formulas

Topic 9 – Working with data and tables

0/6

Topic 9 – Overview

Lesson 9.1 – Sorting data

Lesson 9.2 – Filtering data

Lesson 9.3 – Table basics

Lesson 9.4 – Adjusting tables

Topic 10 – Charts and images

0/6

Topic 10 – Overview

Lesson 10.1 – Creating basic charts

Lesson 10.2 – Adjusting chart data

Lesson 10.3 – Modifying and formatting charts

Lesson 10.4 – Inserting images and objects

Topic 11 – Viewing data

0/6

Topic 11 – Overview

Lesson 11.1 – Zooming

Lesson 11.2 – Workbook views

Lesson 11.3 – Navigation

Lesson 11.4 – Freezing panes

Topic 12 – Page setup and printing

0/4

Topic 12 – Overview

Lesson 12.1 – Page setup

Lesson 12.2 – Print settings

Topic 13 – Sharing workbooks

0/5

Topic 13 – Overview

Lesson 13.1 – Exporting workbooks

Lesson 13.2 – Collaborating on workbooks

Lesson 13.3 – Commenting on workbooks

Topic 14 – Getting help

0/4

Topic 14 – Overview

Lesson 14.1 – The Search bar

Lesson 14.2 – The Help pane

Conclusion

0/2

Closing remarks

End of course checklist

Microsoft Excel for The Workplace – Level 1 – Beginner

About Lesson

In Topic 1 you will gain a comprehensive understanding of the Excel interface, which forms the foundation for effective use of the software. Through three lessons, you’ll explore key components: the Backstage View, where you manage workbooks and settings; the Ribbon, which provides quick access to essential commands; and the Worksheet Interface, where most of your work takes place. By mastering these elements, you’ll be equipped to navigate Excel confidently and efficiently as you progress through the course.

0% Complete