Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

Microsoft Excel Introduction Training Course

Microsoft  Excel Training Courses

This course is for new or users with little Excel experience. The course is designed to introduce the basic concepts of an excel spreadsheet. We look at spreadsheet terminology and become familiar with the Excel interface.

 

Delegates will learn to navigate worksheets and workbooks and how to get help when needed. They will learn to enter and edit text, values and formulas and to save their work and open other workbooks.

 

Delegates will also learn how to move and copy data on a wrksheet and between workbooks, as well as learning about absolute and relative references and their usage in formulas.

 

This course also covers simple functions like SUMm MAX, MIN and average as well as basic formatting techniques and printing.

 

Finally, delegates will learn how to create and format simple charts and learn how to handle large workbooks.

 

 

Target audience

This course is for new or users with little Excel experience. The course is designed to introduce the basic concepts of an excel spreadsheet.

 

 

Course Content

(Content may vary depending on software version)

 

 

Module 1: The Basics
Getting Started
Creating a New Workbook
Parts of a Workbook
Saving a Workbook
Opening a Workbook

 

Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste

Module 3: Working with Data
Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells

Module 4: Using Basic Excel Tools
Understanding Cell References and Formulas
Using Basic Formulas
Using Basic Functions
Using Advanced Functions
Using Spell Check
Using Sort and Filter

Module 5: Using Timesaving Tools
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate

Module 6: Formatting Text
Changing the Font Face, Size, and Colour
Applying Text Effects
Applying Borders and Fill
Using the Font Tab of the Format Cells Dialog
Clearing Formatting

 

Module 7: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format

Module 8: Formatting the Workbook
Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background

Module 9: Inserting Art and Objects
Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes

Module 10: Charting Data
Creating Sparklines
Inserting Charts

 

Module 11: Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
E-Mailing a Workbook
Sharing Your Workbook on SkyDrive

Module 12: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes

 

Related Courses

In House Training Courses

Interactive Dashboards Using Microsoft Excel

An Excel Dashboard provides analysis and insight into what is happening in your business. They summarise large data sets in real time. If you are required to report complex information such as...

In House Microsoft Excel VBA Training Course

By learning to write Excel VBA code, repetitive and tedious tasks in Microsoft Excel can be performed quickly and accurately. The result is increased efficiency, performance & productivity which...

Microsoft Excel Advanced Training Course

On this Microsoft Excel training course you will work with advanced database management, database functions, data validation & protection. You will learn how to work with PivotTables and...

Microsoft Excel Intermediate Training Course

This Microsoft Excel Intermediate training course is intended for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel...