Who Should attend?
The objective of this session is to provide the new user with a comprehensive overview of the capabilities of Microsoft Excel 2013 as well as presenting the knowledge required to begin using the program effectively. As the session is primarily hands on it will be restricted to one user per computer system and is suitable for both the novice and the person who has dabbled with Excel.
Course Content & Aims
Overview of Microsoft Excel
The Screen / The Ribbon / File Tab / Quick Access Toolbar / Slider
Excel Options Menu / Excel Shortcuts
Screen Tips / Using HELP
Overview of the Spreadsheet / Cell Addresses
Cursor Movement / GoTo / Excel Navigator
Selecting Methods
Working with Ranges & Named Ranges
Name Manager
Data Entry / Editing
Text / Numbers / Custom Lists / Fill Ranges / Flash Fill
Creating / Importing / Using Customs Lists
Cut / Copy / Paste / Paste Special Functions / Quick Copy etc
Relative / Absolute Cell Addresses
Copying between Sheets / Files
Formula /Formatting the Worksheet
Formatting Cells
Numeric / Alignment Options / Fonts / Borders / Patterns
Conditional Formatting / Using Format Painter
File Handling
Using Save / Save As – Directories / Drives / File Type.
Adding Password Protection / Protecting the Sheet / Workbook
Working with Comments
= Functions
SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF
DATE & TIME FUNCTIONS / NOW() / Date and Time Calculations
IF STATEMENTS
Named Ranges in Formula
Headers and Footers / Print Area / Page Break Preview / Orientation
Print Preview / Changing the Set Up / Freezing Panes / New Window
Working with Charts
Creating a Chart
Recommended Charts / Elements / Styles & Filters
Change Design / Layout / Colours / Format
Changing the Chart Type
QUESTIONS AND ANSWERS
Assessment & Qualification
The course is devoted to a practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained. The session is fully documented, and each person attending will have unlimited access to our after training back up service. A certificate of attendance will be issued.