Microsoft Excel Tutorial - Beginners Level 1

Overview

This course aims to teach beginners how to use Microsoft Excel effectively. By the end of the course, students will be able to navigate Excel's interface, input and format data, work with basic formulas and functions, create charts, and utilize various Excel features like freezing panes and currency formatting. The teaching method involves a detailed tutorial with timestamps for easy navigation. This course is intended for individuals who are new to Excel and want to build a solid foundation in spreadsheet management.

Syllabus

Start.
Starting up.
Recent documents and pinning documents.
Templates.
Layout - Tabs, ribbons, and groups in Microsoft Excel.
Rows, Columns, Cells and Ranges.
Worksheets in Microsoft Excel.
View and zooming.
Inputting Data.
Formatting Data.
Wrapping Text.
Insert Row/ Merge & Center cells.
Currency formatting.
Print view.
Add cell borders and colors.
Basic formulas in Microsoft Excel.
Copy formula.
Freeze Pane.
Basic Microsoft Excel functions.
“Tell Me” in Microsoft Excel.
Inserting charts in Microsoft Excel.