Microsoft Office Access – supporting your business development
John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.
Read Full Testimonial
Virtual Basic Excel Training Course Content
Our virtual basic Excel training course can be run in all versions of Microsoft.
All of our Excel courses are full day courses, and they typically run from 9:30am to 4pm. To break up this long day we allow two coffee breaks and a lunch break throughout the day. Even though we have set timings for the course on our agendas, we can alter them to fit in with your needs. As well as our standard course agendas, we can also create a bespoke course for you tailored to the training needs you have. Just let us know what you need, we’d be happy to help.
Key Content
The key content that is covered in the virtual training course can be found below:
- The Excel Screen Environment
- Ribbons, Tabs, Customisation
- Cell Selection
- Editing, Copy, Cut, Paste
- Entering Numbers and Text. Cell formatting
- Shading and borders
- Cell styles. Formatting Text
- Inserting columns and rows
- Simple Formulae. Autosum, Percentages
- Other Common Functions
- Headers & Footers
- Differences between Relative & Absolute References
- Page setup, Printing & Zoom
- Other Simple Functions for example freezing, hiding and conditional formatting
- Exercises throughout
Course Objectives
The objective of this basic Excel course is to allow the trainee to be able to build and edit individual worksheets through learning formatting skills of cells and columns. As well as formatting skills, knowledge of simple mathematical symbols and simple functions in Excel will be developed. Finally the conditional formatting feature will be covered alongside navigational features like freeze panes and hiding.
