Course Overview 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 Example Video 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 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 : BASICSCHAPTER 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 andamp; Data Types Accessing Help Creating Worksheet Formulas Insert Functions Re-using Formulas and Functions Insert, Delete, andamp; Adjust Columns andamp; 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 : INTERMEDIATECHAPTER 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 andamp; 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 andamp; MORE 36:39 Formatting Shapes and Objects Creating a PivotTable Analyzing PivotTable Data Pivot Charts Slicers and Timelines PART 3 : ADVANCEDCHAPTER 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 andamp; MAC OS Level: Beginner to AdvancedStream 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.