Microsoft Excel 2016 Complete Mastery Online Training Course
Share this product
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
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 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
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
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.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.
At Learning247, we are passionately committed to your satisfaction. We believe that these are the top training products on the market today. They are used by 1000′s of individuals for self-paced study at home or work, as well as corporate training resources for Universities, Colleges, Schools, Corporations and Government Departments both in the UK and worldwide.
If you are dissatisfied with your purchase in any way, we will gladly give you a full refund of your purchase price within 14 days of purchase. Downloadable courses are not refundable.
REFUNDS & EXCHANGES
If you are not 100% satisfied with your purchase, simply call our friendly sales staff at +44 (0) 121 248 2400 within 14 days of the date of purchase for a full refund and cancellation of your online account.