Duration: 1 day
Course Aims and Objectives:
Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists.
Who should attend:
This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2013 Spreadsheets.
Assumed Knowledge
A working knowledge of PCs and a mouse is assumed.
Course Outline Summary
The Excel Introduction course covers a range of topics which will introduce you to Excel features and the steps required to use these features correctly. On completion of this course, all participants will be able to perform the following:
Creating a Basic Workbook
- Getting Started
- Signing In
- Creating a New Workbook
- Parts of a Workbook
- Opening and Saving a Workbook
Working with Data
- Selecting Data
- Entering and Deleting Data
- Using Undo and Redo
- Using Cut, Copy and Paste
- Using Paste Special
- Inserting Rows and Columns
- Merging and Splitting Cells
Using Basic Excel Tools
- Understanding Cell Reference and Formulas
- Using Basic Formulas and Functions
- Using Spell Check
- Using Sort and Filter
Using Timesaving Tools
- Using AutoFill, Flash Fill, AutoSum and Auto Calculate
Formatting Data
- Applying Text Effects
- Applying Borders and Fill
- Clearing Formatting
- Wrapping Text
- Changing the Size of Rows and Columns
- Changing Number Formats
Inserting Art and Objects
- Inserting SmartArt
- Inserting Text Boxes
- Inserting Pictures
- Drawing Shapes
Viewing, Printing and Sharing Your Workbook
- Using Views
- Saving a Workbook as PDF or XPS
- E-Mailing a Workbook
- Sharing Your Workbook on SkyDrive
Customising the Interface
- Changing Ribbon Display Options
- Customizing the Quick Access Toolbar
- Creating Custom Ribbon Tabs