Microsoft Excel 2019
Contact Hours: 15 (an estimated time frame devoted to a course of study from start to finish that can vary from student to student)
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.
Please note: Course of study may be completed earlier than indicated.
Upon successful completion, students will be able to get started with Microsoft Office Excel 2019 and,
Visual Demonstrations & Multimedia Presentations - Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. We always focus on real world scenarios and skill-set development.
Module 1: Beginner
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
1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
1.12 Create and Customize Charts
Module 2: Intermediate
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
Module 3: Advanced
3.1 Recap
3.2 Conditional (IF) functions
3.3 Nested condition formulas
3.4 Date and Time functions
3.5 Logical functions
All training is delivered online; no additional purchase required.