Microsoft Excel Fundamentals
Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information.
There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you!
This course can be run using Excel 2010, 2013 or 2016. Please discuss your version requirements with us when booking.
Book your virtual training
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
wherever they are based - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
Book your place
- There are no public, Worcester-based events for this course scheduled at the moment, but you can contact us to request a date or call 0800 018 5597
- Request dates at
Worcester Training Centre
This course will introduce you to Excel and give you the skills to use the program every day.
Anyone that manages, stores or looks at data as part of their role.
- Create and customise workbooks in Excel
- Use Excel as a day to day user
- Present data graphically
If you wish to keep a copy of the exercises that you produce on this course, please remember to bring a USB memory stick along with you.
This course will enable delegates to format and present data in easier to understand ways.
An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.
Welcome to Excel
- Workbooks and Worksheets
- File types
- Spreadsheet navigation
Excel Interface
- The Quick Access Toolbar
- Excel Ribbon
- Overview of Tabs
- Command groups
Excel Basics
- Labels
- Printing
- Autosum and Autofill
- Copy/Cut/Paste
- Introduction to Formulae
Workbook Formatting
- Modification of cells and cell data
- Styles and borders
- Chart creation and modification
- Cell referencing
Functions and Formulae
- Mathematical operators
- Error checking
- Nested functions
- Array formulae
Tables
- Creation and formatting
- Sort and filter
- Excel as a database
Data as a Graphic
- SmartArt
- Symbols
- Add and edit shapes
- Sparkline
There are no prerequisites for this course.