Course description
Microsoft Excel 2019
This Microsoft Excel course explores and teaches you the skills that you'll need in many modern-day workplaces. Microsoft Excel can be applied to almost every industry, to speed up processes, monitor financial progress, and much more.
Microsoft Office needs no introduction. It's a widely used application in work and life for a variety of different tasks. Whether you're tracking your finances as a self-employed homeworker, preparing spreadsheets and graphics to illustrate company performance, or keeping a set of figures in an admin/finance role, proven skills in the field will help you progress and stand out from the crowd.
The standards are widely recognised, and the course is an official one, so why not make your mark and see where recognised computer skills could take you.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
Is the MS Excel 2019 online course right for me? Whether you're self-employed or working in a business, you'll need to track your finances, prepare spreadsheets, and graphs to illustrate company performance and targets. This is a great course to ensure you have the necessary skillset to carry out these tasks.
Training Course Content
This official Microsoft exam could include questions based on the following topics:
- Creation of worksheets and workbooks - including importing data from a delimited text file, adding worksheets to existing workbooks, and copying or moving a worksheet
- Navigating around worksheets and workbooks - this could look at searching for data in a workbook, navigating to specific cells, range, or a workbook element, or inserting and removing hyperlinks
- Formatting topics - renaming a worksheet, changing tab colours, modifying page setups or worksheet orders, or inserting and deleting columns/rows. You may also be tested on workbook themes and how to change them, altering the height or width of rows and columns, and inserting headers and footers into a worksheet
- Different customisation and view options - this could be hiding or un-hiding columns and rows, customising the popular quick access toolbar or modifying document properties. Other topics could focus on changing workbook and window views, different uses of the zoom tool, and display formulas
- Configuration of worksheets and workbooks - this topic is all about setting up spreadsheets for distribution, so may include setting print areas and scaling, saving workbooks in alternative file formats and inspecting workbooks for accessibility or compatibility issues
- Managing data cells and ranges - could test you on replacing data, special paste options for data, using AutoFill, and deleting cells
- Formatting cells and organising data - testing your knowledge on topics such as modifying cell alignment, using format painter, and applying number formats and cell styles. Also, look out for inserting sparklines and outline data, and applying conditional formatting
- Creating tables - you could be examined on creating Excel tables from cell ranges, inserting, or removing rows or columns, filtering records, and removing duplicate records
- Performing tasks using formulas and functions - this could include performing calculations using the SUM, COUNT or AVERAGE functions, performing logical operations using IF, SUMIF, or COUNTIF functions, and formatting text using a variety of tools
- Creating charts and objects. Become familiar with creating charts, adding additional data, switching between elements in the source data, and analysing data using Quick Analysis. You may also be tested on formatting charts and their elements, applying layouts and styles, or inserting and formatting objects
Why choose e-Careers Ltd
We have successfully trained over 610,000 learners, from over 50 countries, and growing.
We are industry leaders, with multiple awards and over 10 years experience.
Our Trainers and Tutors are industry experts in their fields
Expenses
Tuition Fee: £ 45Inc. VAT
Continuing Studies
With this course, you can enhance your current CV and take on a role where you're dealing with an Excel spreadsheet daily. This package also works well with other courses such as AAT Accounting qualifications.