Renewal/Upgrade - Microsoft Excel Master Online Training Package
[ TTEXBUN-REN ]
Learn the skills every Microsoft Excel user needs to know - no matter how new (or how experienced) you are...
Whether you want to learn Excel 2016, 2013, 2010, 2007, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel's powerful features.
Watch a single title or watch them all, as many times as you like for an entire year - all at one low price.
Many students ask us why we create our larger course bundles, when some people may not have time to complete all the courses inside the 12 month subscription window...
Well, essentially they're created to enable you to dip in and out of multiple related programs and obtain cross-referenced knowledge; the intention is not for you to study it all or sit all the exams! With any kind of technical learning, building your background knowledge on closely related areas makes a lot of sense. Therefore, having access to a wide range of connected programs enables you to research related topics to the actual program you're studying for (often just watching the video/tutorial), enhancing your overall understanding. This is why we create the larger bundles; to build the breadth of your knowledge. Also, many IT professionals use them as reference material after certification, as we usually provide discounts on subsequent re-subscription - to enable you to have the material as a constant professional reference.
This program covers several versions of Excel from beginner to advanced, but as an example, the topics covered (for Excel 2016) are...
PART 1 : BASICS
CHAPTER 01: MICROSOFT® EXCEL 2016 BASICS 4:04:11
Selecting and Navigating
Keyboard Navigation and Basic Data Entry
The Quick Access Toolbar
Creating a New Spreadsheet
Cell Data & Data Types
Creating Worksheet Formulas
Re-using Formulas and Functions
Insert, Delete, & Adjust Columns & Rows
Find and Replace
Use Proofing and Research Tools
Apply Text Formats
Apply Number Formats
Align Cell Contents
Applying Styles and Themes
Creating and Using Templates
Preview and Print a Notebook
Configure Headers and Footers
Managing Workbook Properties
PART 2 : INTERMEDIATE
CHAPTER 01: FUNCTIONS 1:11:52
Working with Named Ranges
Using Named Ranges in Formulas
Using Specialized Functions
Working with Logical Functions
Date and Time Functions
CHAPTER 02: DATA 32:24
Using Database Functions
CHAPTER 03: TABLES & CONDITIONAL FORMATTING 22:11
Create and Modify Tables
Manipulating Table Data
Conditional Formatting Rules
Using Logical Functions with Conditional Formatting