Microsoft Excel Training Workshop
Microsoft Excel Training Workshop
The Microsoft Excel training courses are available on-site, or at a training room or online through live video conferencing.
Half Day or Full Day Workshop – Foundation / Intermediate / Advanced Level
This course will help those new to MS Excel learn essential features and functions to be able to confidently work within the program. Being confident in Microsoft Excel is essential for anyone who either works or aspires to work in an office environment. The course is for anyone wanting to learn how to utilise the current version of this powerful spreadsheet programme. The course will teach you how to create and format worksheets, use functions, tables, formulas and more. There are three levels: Foundation, Intermediate and Advanced. Book onto the workshop that is right for you, or contact us now to ask for guidance on which is right and to book.
Course Descriptor
The course descriptors below are a summary and indicative of topics that will be covered, however the workshops and training content can be tailored to specific requirements if required.
Microsoft Excel Foundation
- Editing Spreadsheet
- Creating Basic Formulae
- Creating a Basic Spreadsheet
- Presentation
- Lists
- Dates
- File Procedures
- Printing
- Tips & tricks
- Excel’s secrets & expert advice
- Managing Formulae
- Page Setup
- Functions
- Spreadsheet Efficiency
- Charts
- Basic Filtering
- New Office 2016 / 365 features
Microsoft Excel Intermediate
- Linking worksheets
- Consolidated formulae
- Protection
- Tips & tricks: Shortcuts
- Excel’s secrets: navigation, views & databases
- File linking
- Lists
- Charts
- New Office 2016 / 365 features
Microsoft Excel Advanced
-
Pivot Tables
-
Outlining
-
Scenario Manager
-
Advanced Functions
-
Tips & tricks
-
Excel’s secrets & expert advice
-
General Advanced Features
-
Advanced Charts
-
Introduction to Macros
- New Office 2016 / 365 features
Who Should Attend?
This course will help you learn some of the fundamental actions you can carry out in Excel before advancing your knowledge to more in-depth features. Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.course is ideal for you if you work in, or aspire to work within an office environment and want to brush up on your spreadsheet skills. No matter the role, the skills gained from this course are invaluable in an office setting. New and regular users at all levels of Microsoft Excel can participate in all of these workshops and courses.
Why should you attend?
By the end of this workshop, you will:
- Develop your ability to navigate Microsoft Excel;
- Learn essential features and functions;
- Be familiar with all the changes and updates to the newest version;
- To be confident in working with the program;
- Learn shortcuts and tips about how to use Excel in the most efficient way;
- Show your commitment to continuing professional development and help towards your career progression opportunities.
Additional Information
Delegates should, if possible, bring their own laptop to the course (though laptops will be available for those without one)
Recent Comments