Excel 365 Basic

---

Course Overview

In this course, you will learn fundamental Excel skills. You will:

Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
Update worksheets without throwing away all of the valuable work you've already done.
Format a worksheet and organize your data.
Print workbooks.
Manage the overall structure of your workbooks.

Duration: 1 day course

---

Course Content

Getting Started with Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Navigate in Excel for the Web
Enter Cell Data

Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions

Modifying a Worksheet
Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Colors, Borders, and Styles
Apply Basic Conditional Formatting

Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers

Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Email us about this courses


Telephone on 01952 938014