Introduction to Excel: A Practical Guide for Beginners

This course is designed for beginners who want to learn the basics of Excel, a powerful spreadsheet application that can help you organize, analyze and present data. By the end of this course, you will be able to:

- Create and edit worksheets and workbooks

- Format cells, rows, columns and ranges

- Apply formulas and functions to perform calculations

- Use charts, tables and pivot tables to visualize data

- Sort, filter and validate data

This course is suitable for anyone who wants to improve their productivity and efficiency with Excel. No prior knowledge of Excel is required, but you should have a basic understanding of Windows and Microsoft Office. You will need access to a computer with Excel 2019 or later installed.

The course topics are listed below:

Use the Excel Default Screen

Understanding Excel Worksheets/Workbooks

How to Navigating an Excel Workbook

How to Enter Data in to an Excel worksheet

How to Selecting Cells within and Excel worksheet

How to Editing Data in an Excel worksheet

How to Format Excel Cells to display Dates, Percentages, Currency etc

How to use the AutoSum/Average/Max/Min functions in Microsoft Excel

Understand how to use Basic Sums in Microsoft Excel

Understanding Mathematical Precedence

How to Copy and Paste Data in Microsoft Excel

Using the Auto Fill Feature in Microsoft Excel

Saving a Workbook in Microsoft Excel

How to format a Spreadsheet using the Borders Feature and format Cells in Microsoft Excel

How to create Charts using the ribbon in Microsoft Excel

How to Format Charts in Microsoft Excel

Hiding Columns in Microsoft Excel Moving Columns/Inserting Columns in Microsoft Excel

Using Database Filters in Microsoft Excel