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
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?
Elements of the Excel workspace; quick ways to select and navigate; different ways to get help; workbook design - tips and best practice
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
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
Deciding what to print; checking output with page break preview; checking print preview; changing page setup (including headers and footers); printing
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?