Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
In today’s workplace, Microsoft Excel is the de facto tool for working with data on the desktop. Knowing how to leverage Excel enables you to simplify complex tasks, essential to daily work responsibilities. In this introductory course, you gain the skills needed to create Excel worksheets, develop formulas and apply sophisticated formatting to capture and present your data.
starting and exiting Excel • the Excel screen • the Office Ribbon • the Quick Access Toolbar • the Backstage view • Using Tell Me (Excel 2016)
Creating Simple Worksheets
starting, opening and closing workbooks the cell pointer • moving around the worksheet • entering and editing data • AutoComplete • undo feature • entering values • changing columns widths/row heights • numeric values • AutoFit • Flash Fill
selecting cells • changing the font and size of data • adding borders and shading • using the format painter
Working with Calculations
writing simple formulae • copying formulae • using built-in functions • fill handle • creating formulae • AutoSum • using the formulae palette • order of precedence • quick data analysis
viewing workbooks in print preview • changing the page orientation • enlarging and reducing data • centring data on the page • adding headers and footers
Copying & Moving Data
using drag and drop to rearrange data • using copy and paste • using the fill handle
Charts – time allowing (Sway alternative)
creating a chart • recommended charts • changing the chart type • adding data • improving the appearance of a chart
Book two places on the same course and get the second place half price!*
*Applies to non-discounted fees only
19th Sep 2019 (v2010-2016) – Limited Availability
Bring Your Own Device Option
This is a BYOD (bring your own device) course.
Don’t have a laptop? No worries, we can provide a PC for training.
Scheduled Course Fee
£170 + VAT*
*Public Sector, please email us for pricing information.
Delegates must be experienced with using a mouse and working in the Windows environment.
Scheduled course · private course · tailored · 1 to 1 (all instructor led)
A comprehensive course manual provides support throughout the course and upon your return to the office.
“We have used Blue Novation for a couple of their advertised courses – feedback from the participants had been really positive and has helped the attendees in their current roles. We have also used them at our own premises to deliver a range of Microsoft courses (at different levels). The team is well organised and punctual, but more important their delivery style suits our staff and our organisational needs. We would not hesitate to use them again.”
Sarah Ammar, Education Support Officer
Catherine Howlett, Administration Assistant
Not found the course you are looking for?