Microsoft Excel Essentials
Who is the course for?
This practical hands-on course is designed for spreadsheet users who need to acquire Excel skills quickly and effectively. Practice tasks and case studies ensure that fundamental techniques can be applied quickly in a demanding financial and business environment
Is this course suitable for me?
Take the Skills quiz
Pre-requisites
You need to have basic Windows skills, including opening and saving, copying and moving information, and working with a keyboard and mouse
What are the objective of the course?
By the end of the course, you will be able to:
-
Build effective spreadsheets using a range of efficiency features
-
Perform calculations using formulas and functions
-
Use a range of auditing techniques to verify accuracy
-
Format and print different areas of workbook
-
Create and print a range of different charts
What does the course cover?
Getting started:
Elements of the Excel workspace; quick ways to select and navigate; different ways to get help; workbook design - tips and best practice
Building workbooks:
Entering data; quick ways to enter data; managing worksheet; copying and moving data; editing and making changes; calculating with formulas; saving and opening/ closing workbooks
Calculating with formulas and function:
Creating a formula; relative and absolute references; precedence/ order of calculation; overview of functions; statistical and mathematical functions; creating and using range names; using data validation
Presentation techniques:
Formatting shortcuts; using Format Cells; changing column widths and row heights; inserting extra rows and columns; hiding rows and columns; freezing panes; conditional formatting; custom number formats
Printing:
Deciding what to print; checking output with page break preview; checking print preview; changing page setup (including headers and footers); printing
Charting:
Creating a chart quickly with the chart wizard; using the chart toolbar; range finder in charts; fine tuning your chart; adding and removing data; changing the scale; setting fill effects and special effects; printing a chart with the data; creating your own custom chart, troubleshooting charts
How long does this course last?
1 day
