Sale!
Microsoft excel 2019
MICROSOFT-EXCEL-2019
Training Videos For Microsoft Excel 2019
Training Videos For Microsoft Excel 2019
Training Videos For Microsoft Excel 2019
Training Videos For Microsoft Excel 2019

Training Videos For Microsoft Excel 2019

$49.99

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.

 

This course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. In addition, it will help students understand how to manipulate data within a spreadsheet, validate, and present information using the built-in structure and functions of Microsoft Excel.

 

What you will learn

This course includes six hours of training and 58 videos.  Throughout the course, students will learn how to save files, entering and formatting data, how to work with formulas, inserting functions, how to use function, customizing charts and more!

9 in stock

Select a Support Plan

EAN: N/A SKU: 753569177590 Categories: , Tags: , , , ,

Module 1: Beginner

  1. 1.0 Intro
  2. 1.1 The Ribbon
  3. 1.2 Saving Files
  4. 1.3 Entering and Formatting Data
  5. 1.4 Printing from Excel & Using Page Layout View
  6. 1.5 Formulas Explained
  7. 1.6 Working with Formulas and Absolute References
  8. 1.7 Specifying and Using Named Range
  9. 1.8 Correct a Formula Error
  10. 1.9 What is a Function

Module 2: Intermediate

  1. 2.0 Recap
  2. 2.1 Navigating and editing in two or more worksheets
  3. 2.2 View options  Split screen, view multiple windows
  4. 2.3 Moving or copying worksheets to another workbook
  5. 2.4 Create a link between two worksheets and workbooks
  6. 2.5 Creating summary worksheets
  7. 2.6 Freezing Cells
  8. 2.7 Add a hyperlink to another document
  9. 2.8 Filters
  10. 2.9 Grouping and ungrouping data

Module 3: Advanced

  1. 3.1 Recap
  2. 3.2 Conditional (IF) functions
  3. 3.3 Nested condition formulas
  4. 3.4 Date and Time functions
  5. 3.5 Logical functions
  6. 3.6 Informational functions
  7. 3.7 VLOOKUP & HLOOKUP
  8. 3.8 Custom drop down lists
  9. 3.9 Create outline of data
  10. 3.10 Convert text to columns
Training Videos for Microsoft 70-432: SQL Server 2008 Implementation and Ma... CBT Training Videos For Microsoft 70-432 Compatible Training videos for Mega Adobe Bundle