Microsoft Excel – Introduction
Get to grips with the basics of Excel. This course will enable you to perform simple calculations with confidence using formulas, navigate around the the Excel ribbon quicker and easier and learn the Excel shortcuts that will make your mouse redundant. See how to format your data to look professional both on screen or printed.
Program Fundamentals
Starting Excel
What’s New in Excel
Understanding the Excel Program Screen
Giving Commands
Using Command Shortcuts
Creating a New Workbook
Opening a Workbook
Previewing and Printing a Worksheet
Saving a Workbook
Closing a Workbook
Using Help
Exiting Excel
Getting Started with Worksheets
Navigating a Worksheet
Entering Labels and Values
Selecting a Cell Range and Entering Data in a Cell Range
Overview of Formulas and Cell References
Entering Formulas
Entering Content Automatically
Referencing External Data
Editing a Worksheet
Editing Cell Contents
Copying and Moving Cells
Controlling How Cells Are Moved or Copied
Collecting Items to Move or Copy
Checking Your Spelling
Inserting Cells, Rows, and Columns
Deleting Cells, Rows, and Columns
Using Undo and Redo
Finding and Replacing Content
Adding Comments to Cells
Tracking Changes
Formatting a Worksheet
Formatting Text
Formatting Values
Adjusting Row Height and Column Width
Working with Cell Alignment A
dding Cell Borders and Background Colors
Copying Formatting
Applying and Removing Cell Styles
Creating and Modifying Cell Styles
Using Document Themes
Applying Conditional Formatting
Creating and Managing Conditional Formatting Rules
Finding and Replacing Formatting
