Register

NEW COURSE : Microsoft Excel Training ??

Orangebox Training are now in a position to offer our clients face to face training, at your place of work or our own training room in MS Excel. The training will be offered at 3 bespoke levels and each level will be run via a 1 Day Course. 

?? Microsoft Excel Training ??

? Basic
? Intermediate
? Advanced

Basics
? Opening Excel Spreadsheet
? Understanding the menus
? Understanding / Customising the components of the Ribbon
? Understanding / Customising the QuickAccess Toolbar
? Basic use of the spreadsheet
? Structure of a spreadsheet
? Entering and modifying text, numbers
? Basic formatting 
? Using basic formulae
? Shortcuts to navigate around a spreadsheet
? Basic filtering and sorting
? Creating and modifying basic charts
? Printing spreadsheets / areas in a spreadsheet
? Using predefined Excel templates

Beyond the basics (intermediate)
? Using more advanced paste options (e.g. paste special)
? Using more advanced formatting options including locking / hiding cells, basic conditional formatting
? Creating and editing lists, and using data validation
? Importing data and saving data in different formats
? More advanced options to filter and sort
? Creating and editing pivot tables
? Using more functions

Beyond the basics (advanced)
? More advanced use of conditional formatting
? Use of Lookup and Reference functions
? Use of Text and Logical Excel functions
? Introduction to other advanced Excel functions
? Tips and techniques on structuring more complex models (error checking, linking across tabs and spreadsheets, multiple users)
? Basic use of Excel Macros

Contact the team on:
☎️ 01429 874530
? glen@orangeboxtraining.com
www.orangeboxtraining.com

#MSexcel #face2face #training #orangebox

Leave a Reply

Your email address will not be published. Required fields are marked *

#iguru_soc_icon_wrap_63e4f0e54dab4 a{ color: #ffffff; }#iguru_soc_icon_wrap_63e4f0e54dab4 a:hover{ color: #e18226; }