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.

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

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 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 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

Related Courses

Microsoft Excel – Intermediate

Once your conversant with the basics of Excel this course aims to provide you with the knowledge to use more advanced lookup and logical formulas to find and compare data. You will organise your raw data in Tables, possibly the “must know” formatting feature in Excel, before learning how to analyse it with sorting and advanced filtering. You will also learn how to get started with Pivot Tables and present you data as charts.

Microsoft Excel – Advanced

Turn unorganized data into useful information and quickly make spreadsheets your friends. Train IT Midlands’s lets people of any technical level learn exactly what they need to know at their own pace. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.