Microsoft Excel 2019
Share this course with friends and followers on social media.
What is Microsoft Excel 2019?
This online Microsoft excel training course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at a beginner level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel course is perfect.
This Microsoft Excel training is a great starting point to prepare for the intermediate and advanced Excel course. This course will give you a full overview of all of the most common features of Excel and how to use them.
This online Microsoft excel training is designed to provide you with the essential skills you will need to be proficient in Excel, in a work or home environment, in as short a time as possible.
Who is the Microsoft Excel 2019 Course Suitable For
This online Microsoft Excel 2019 course is suitable for anyone looking to develop their Microsoft Excel 2019 skills. The course is also suitable for anyone who manages their Microsoft Excel training, this MS training can be used for on-boarding new staff, or as part of a team training plan.
What's Included in the Microsoft Excel 2019 Course?
Awarding Body
MTA
Course Duration
7 Hours
This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.
Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.
12 Months Unlimited Access
Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7.
Course Content
The Microsoft Excel 2019 - Beginners course is organised into the following modules:
Introduction to Excel
- Intro to Excel
- What's New In Excel 2019?
- Course Overview
- Overview of the Excel Window
- Mouse Features
-
Back Stage View
Creating Workbooks
- Entering Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Module 2 - Practice Exercise
Saving Workbooks
- Working with the Save and Save As Commands
- File Extensions, Share, Export, and Publish Files
- Module 3 - Practice Exercise
Navigating Workbooks
- Opening a File
- Working with Larger Files
- Freeze Panes Option
- Split Screen Option
- Module 4 - Practice Exercise
Page Setup and Print Options
- Headers and Footers
- Print Titles
- Comments
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Module 5 - Practice Exercise
Working with Rows, Columns, and Cells
- Adding and deleting rows columns and cells
- Changing Column and Row Widths
- Module 6 - Practice Exercise
Moving Data
- Cut, Copy, and Paste
- Copying Formulas
- Module 7 - Practice Exercise
Formulas and Functions
- Overview of Formulas
- Create Formulas Using Functions - part 1
- Create Formulas Using Functions - part 2
- Absolute Values
- Module 8 - Practice Exercise
Working with Sheets
- Adding, Deleting, and Renaming Sheets
- Additional Sheet Tab Options
- 3 Dimensional Formulas
- Module 9 - Practice Exercise
Formatting Worksheets
- Formatting Cells - part 1
- Formatting Cells - part 2
- Formatting Numbers
- Borders and Shading
- Format as Table
- Using Styles
- Using Format Painter
- Protecting Sheets
- Fill Handle and Custom Lists
- Module 10 - Practice Exercise
Charts
- Creating Charts
- Types of Charts
- Editing Charts - Part 1
- Editing Charts - Part 2
- Using Graphics to Enhance Charts
- Linking Chart Titles
- Module 11 - Practice Exercise
Working with Names
- Creating Range Names
- Managing Names
- Using Names in Formulas
- Module 12 - Practice Exercise
Sorting and Filtering
- Remove Duplicates
- Sort Data
- Filter Data
- Advanced Filters
- Module 13 - Practice Exercise
Outlining and Sub-totalling
- Creating an Outline
- Subtotals
- Module 14 - Practice Exercise
Working with Views
- Arranging Files
- New Window Option
- Custom Views
- Module 15 - Practice Exercise
Linking Files
- Creating Formulas between Files
- Working with Links
- Consolidating Data
- Module 16 - Practice Exercise
Advanced Formula Creation
- If Statements
- VLookups
- Data Validation
- Formula Auditing
- Module 17 - Practice Exercise
PivotTables
- PivotTables
- Pivot Charts
- Module 18 - Practice Exercise
Additional Excel Features
- Slicers
- Goal Seeker
- Text to Columns
- Watch Window
- Customising Ribbons and Tabs
- Module 19 - Practice Exercise
Shortcuts
- Excel Shortcuts Every User Should Know
Closing
- Closing Video
Project Files Included
Assessment / Exam
There is no formal assessment on this course.
Prerequisites
Microsoft Excel 2019 installed on your device.
You don't need any prior experience of using Microsoft Excel, our Microsoft Excel 2019 training covers beginners level training to help you develop the skills you need to progress in your career.
Career Path
We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):
- Office Administrator
- Business Administrator
- Personal Assistant, Clerical Assistant
- Receptionist
- Secretary
- Customer Service Representative
- Project Officer, Project Manager
- Business Manager
- Sales Executive, Sales Manager, Sales Director
- Human Resource Officer
- Finance Assistant. Book-keeper, Accountant
- Healthcare Assistant, Nurse
- Database Administrator
Career Advice
Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including:
- How to put together a killer CV, Covering Letters and Thank You emails.
- How to gain relevant work experience.
- How to prepare for interviews.
- How to understand Job adverts.
- How to choose the right recruitment agency.
- How to look for work on LinkedIn.
- Information on dealing with redundancy.
Related Content
For short courses upon successful completion you will be awarded a personalised certificate of completion.
For accredited courses a certificate will be sent directly to you from the appropriate awarding body.
All students enrolled on this course are eligible to apply for a TOTUM PRO Card, which offers discounts in a wide range of shops and websites, helping you get money off food, holidays and flights, clothes, make-up gym memberships and much more.
The TOTUM PRO card is aimed at professional learners, giving you access to exclusive discounts.
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art e-learning platform we recommend an internet connection of 10Mbps or better.
Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.
E-learning is flexible, efficient, and cost-effective, meaning you can progress through the modules at your own pace, at your own time to fit the training in around your work and personal life.
Short online courses also help employers to demonstrate that they have fulfilled their legal duties to ensure their personnel have been adequately trained.
Once the courses have been completed, a confirmation of results can be saved or printed as evidence. This can then be kept on record as evidence of suitable training.
You will instantly receive a confirmation email with your order details and your course login details will follow within one business working day.
Please note that course bookings can not be processed outside of normal working hours, over weekends or on bank holidays and will be processed the next business working day.
Step 1
Click the 'Buy' or 'Add to cart' button and you will be taken to our payment/booking page where you can choose to pay online now using a debit/credit card or you can pay later by invoice.
Step 2
Once you have paid for your course(s), you will receive an email from our team advising how to begin your training.
Step 3
You will be provided with a username and password which will enable you to access the e-learning portal. Login to start your course, once you have completed and passed the course, you will be able to download and print your certificate straight away.
Our mission is to help you learn the skills you need to reach your full potential.
We are one of the fastest growing online training providers. We offer engaging, effective and flexible online training solutions to both individuals and businesses.
We develop courses that help individuals to prepare for and complete their certification exams with ease. Our unique, flexible approach to learning means you don’t have to put your life on hold to get certified. You can study full time and part time, from home and work and on the move; online and on mobile devices.
We provide world class education developed by highly skilled and experienced instructors. Our courses are upgraded regularly to ensure our learners are up-to-date with the latest industry requirements and best practices.
Envico is working in partnership with My Training Academy offering e-learning and is not accredited by or associated with any examination bodies, awarding bodies, institutions or organisations in any way whatsoever.