Microsoft excel 2016 complete mastery online training course
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
This 3-part ’Mastering Excel 2016’ course includes basic, intermediate, and advanced level lessons.... Learn about functions, charts, macros, Sparklines, and so much more. By the time you’ve completed this 10+ hour training, you’ll be a Microsoft Excel master. Length: 10 hrs 10 min
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Microsoft Excel
- 3d training
- 3D
- Microsoft excel training
- MS Excel
- Online training
- Online
- Online Course
- Excel 2016
- Microsoft Excel 2016
- MS
- 24x7 Microsoft
Teachers and trainers (1)
Online Course Online Course
12 Month Unlimited On-Demand Online Access to the Course.
Course programme
Course Outline
This complete ’Mastering Excel 2016’ training course gets you up and running with Microsoft Excel 2016. Start by learning to navigate the interface and familiarizing yourself with the essential tools. Then move on to working with Functions, Data, Charts, and Tables. Finish up by learning advanced features such as Macros, Sparklines, 3D Maps, and more!
If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.
If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are are an experienced Excel user, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you need to know about Microsoft Excel 2016, including:
- The basics of Functions and Formulas
- Managing Workbook properties
- Sorting, Filtering, and Summarizing Data
- Creating PivotTables and Pivot Charts
- Using Scenarios and Goal Seek
- Working with Macros
- Using Data Forms and Form Controls
PART 1 : BASICS
CHAPTER 01: MICROSOFT® EXCEL 2016 BASICS 4:04:11
- Introduction
- Selecting and Navigating
- Keyboard Navigation and Basic Data Entry
- The Ribbon
- The Quick Access Toolbar
- Creating a New Spreadsheet
- Compatibility Issues
- Cell Data & Data Types
- Accessing Help
- Creating Worksheet Formulas
- Insert Functions
- 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
- Conditional Formatting
- Creating and Using Templates
- Preview and Print a Notebook
- Page Layout
- Configure Headers and Footers
- Managing Worksheets
- View Options
- 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
- Displaying Functions/Formulas
- Nesting Functions
- Date and Time Functions
- Text Functions
CHAPTER 02: DATA 32:24
- Sorting Data
- Filtering Data
- Using Database Functions
- Using Subtotals
CHAPTER 03: TABLES & CONDITIONAL FORMATTING 22:11
- Create and Modify Tables
- Manipulating Table Data
- Conditional Formatting Rules
- Using Logical Functions with Conditional Formatting
CHAPTER 04: CHARTS 28:35
- Creating Charts
- Modifying and Formatting Charts
- Creating a Dual Axis Chart
- Chart Templates
CHAPTER 05: SHAPES, TABLES, SLICERS & MORE 36:39
- Formatting Shapes and Objects
- Creating a PivotTable
- Analyzing PivotTable Data
- Pivot Charts
- Slicers and Timelines
PART 3 : ADVANCED
CHAPTER 01: MICROSOFT® EXCEL 2016 ADVANCED 2:53:26
- Using Links and External References
- Using 3D References
- Consolidating Data
- Using Lookup Functions, Part 1
- Using Lookup Functions, Part 2
- Tracing Precedent and Dependent Cells
- Watching and Evaluating Formulas
- Comments and Track Changes
- Comparing and Merging Workbooks
- Accessibility Checker
- Protecting Worksheets and Workbooks
- Applying Data Validation
- Search for Invalid Data
- Working with Macros, Part 1
- Working with Macros, Part 2
- Creating Sparklines
- 3D Maps
- Data Tables
- Using Scenarios
- Goal Seek
- Forecasting Data Trends
- Changing Your Display
- Importing Delimited Text Files
- Data Forms and Form Controls
- Calculated Fields and Cube Functions
Learn anytime, anywhere, at home or on the go.
Length of Subscription: 12 Months Online On-Demand Access
Running Time: 10 hours 10 min
Platform: Windows & MAC OS
Level: Beginner to Advanced
Stream your training via the internet, or download to your computer and supported mobile device, including iPad™, iPhone™, iPod™ Touch and most Android devices.
Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
Microsoft excel 2016 complete mastery online training course