fbpx

Microsoft Excel 2019

In this course, you will develop and improve your Microsoft Word skills, so that you are able to maximize the industry-standard word processing system.

  • 12 months Unlimited Access
  • Visual demonstrations
  • Multimedia presentations
  • Social Learning & Networking
  • Certificate of Completion
  • Expert Instructor-led training
  • Quizzes & Exam Simulators
  • Leads to a recognised qualification

What you'll learn

  • Regardless of your level of understanding, you will benefit from this Microsoft Excel 2019 training course
  • Our Microsoft Excel 2019 training course will help arm you with the knowledge to use it more effectively
  • You will maximize your progression and productivity.

Course Description

Microsoft Excel is the most popular spreadsheet application for both personal and professional use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2019 training course because it covers basic, intermediate and advanced topics. Our Microsoft Excel 2019 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built-in structure and functions of Microsoft Excel.

Course Content

  • 1.0 Intro
  • 1.1 The Ribbon
  • 1.2 Saving Files
  • 1.3 Entering and Formatting Data
  • 1.4 Printing from Excel & Using Page Layout View
  • 1.5 Formulas Explained
  • 1.6 Working with Formulas and Absolute References
  • 1.7 Specifying and Using Named Range
  • 1.8 Correct a Formula Error
  • 1.9 What is a Function
  • 1.10 Insert Function & Formula Builder
  • 11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
  • 1.12 Create and Customize Charts
  • 2.0 Recap
  • 2.1 Navigating and editing in two or more worksheets
  • 2.2 View options Split screen, view multiple windows
  • 2.3 Moving or copying worksheets to another workbook
  • 2.4 Create a link between two worksheets and workbooks
  • 2.5 Creating summary worksheets
  • 2.6 Freezing Cells
  • 2.7 Add a hyperlink to another document
  • 2.8 Filters
  • 2.9 Grouping and ungrouping data
  • 2.10 Creating and customizing all different kinds of charts
  • 2.11 Adding graphics and using page layout to create visually appealing pages
  • 2.12 Using Sparkline formatting
  • 2.13 Converting tabular data to an Excel table
  • 2.14 Using Structured References
  • 2.15 Applying Data Validation to cells
  • 2.16 Comments – Add, review, edit
  • 2.17 Locating errors
  • 2.0 Recap
  • 2.1 Navigating and editing in two or more worksheets
  • 2.2 View options Split screen, view multiple windows
  • 2.3 Moving or copying worksheets to another workbook
  • 2.4 Create a link between two worksheets and workbooks
  • 2.5 Creating summary worksheets
  • 2.6 Freezing Cells
  • 2.7 Add a hyperlink to another document
  • 2.8 Filters
  • 2.9 Grouping and ungrouping data
  • 2.10 Creating and customizing all different kinds of charts
  • 2.11 Adding graphics and using page layout to create visually appealing pages
  • 2.12 Using Sparkline formatting
  • 2.13 Converting tabular data to an Excel table
  • 2.14 Using Structured References
  • 2.15 Applying Data Validation to cells
  • 2.16 Comments – Add, review, edit
  • 2.17 Locating errors

Featured Courses

We suggest that you only take your exam when you get a score of 85% or above on the practice exams. Not just once but over and over again. If you keep doing the practice exams and get a high score, naturally you will be more confident for your official exam and the chances of you passing them will be much higher.
After you’ve signed up on any of our courses, our student support team will provide you with the login details and you are ready to go. Each of our courses comes with a welcome tutorial which helps you to understand how to navigate through the course. They are all very easy so you shouldn’t have any problems. But if you have any problems, please get in touch with our student support team.
We have a student support team that their main responsibility is to make sure that your study journey is smooth and easy. If you encounter any problems, just call or email them and they will be happy to help you.

Be the first to add a review.

Enrolled: 150 students
Duration: 12 Months
Video: 5 Hours and 30 Minutes
Level: Intermediate

Enquiry Form

Complete the form below to receive more details about the course.

0121 389 0414

Please read our Privacy Policy for more information.

Train Your Staff

Get your team access to over 200+ courses.
Learn more
netcom online courses discounts