EXCEL – ESSENTIALS Level - Fundamental
EXCEL – ADVANCED Level - Advanced
This course introduces you to the most important features of Microsoft Excel. You will learn how to design, format and print spreadsheets, how to create charts and how to develop formulas and functions. Why attend? • Use the most important Excel commands
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools. Why attend? • Use advanced functions and productivity tools to assist in developing worksheets • Manipulate data lists using outline, autofilter and PivotTables • Use consolidation to summarise and report results from multiple worksheets • Record repetitive tasks by creating macros • Use Hyperlinks to move around worksheets. Course details: 2 days 9.00am – 4.30pm
• Design and construct spreadsheets • Use simple functions and formulas • Format and print spreadsheets • Create and print charts. Course details: 1 day 9.00am – 4.30pm
EXCEL – INTERMEDIATE Level - Intermediate
EXCEL – FORMULAS AND FUNCTIONS Level - Intermediate
TOP PERFORMER
This course provides you with further skills in Microsoft Excel. You will learn
how to identify ranges with names, protect worksheets and files, apply functions, link worksheets, audit files and create templates. Why attend? • Use Excel time savers • Create advanced charts and sparklines • Attach comments to cells • Create efficient formulas with functions, relative and fixed cell references and range names • Troubleshoot formulas with worksheet auditing • Use data validation for data accuracy • Work with multiple worksheets • Create calculations across worksheets and workbooks • Protect cells, worksheets and workbooks • Create worksheet templates. Course details: 2 days 9.00am – 4.30pm
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas. Why attend? • Create well-structured formulas using relative and absolute referencing and named ranges • Understand and use various functions in formulas, including the Insert Function feature • Troubleshoot formula errors using formula auditing. Course details: 1 day 9.00am – 4.30pm
92
Powered by FlippingBook