Excel 2016 for Power Users - Code Chiefs

Excel 2016 for Power Users

Regular price £29.00 Sale

Unlimited Access

7 Units, 37 Activities and Labs

Certificate of Completion

Level 3 Equivilent Content

10+ Hours of Content


Course Description

Learn about how to exploit advanced features in Microsoft Excel 2016 with our Excel 2016 for Power Users course which builds upon our introductory course. On this course, you will learn about:

Creating Advanced Formulas

Analyzing Data with Logical and Lookup Functions

Organizing Worksheet Data with Tables

Visualizing Data with Charts

Analyzing Data with PivotTables, Slicers, and PivotCharts

Inserting Graphics

Enhancing Workbooks

Requirements

Our Excel 2016 for Power Users course is fully compatible with any kind of device which is able to run Microsoft Office 2016. Whether you are using Windows computer, Mac, or Linux, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Who is it for?

This Excel 2016 for Power Users course is ideal for those students who want to build on the Introduction to MS Excel 2016 course, want to further develop thier skills or take their MS Excel knowledge to the next level.

Career path

After completing this Microsoft Excel 2016 course you will be able to build up accurate knowledge and skills with real confidence to up skill in your career.

Curriculum

Creating Advanced Formulas

  • Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  •  
  • Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  •  
  • Summary
  • Review Questions

Analyzing Data with Logical and Lookup Functions

 

  • Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  •  
  • Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  •  
  • Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  •  
  • Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  •  
  • Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  •  
  • Summary
  • Review Questions

 

Organizing Worksheet Data with Tables

 

  • Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  •  
  • Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  •  
  • Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  •  
  • Summary
  • Review Questions

 

Visualizing Data with Charts

 

  • Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  •  
  • Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  •  
  • Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  •  
  • Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  •  
  • Summary
  • Review Questions

 

Analyzing Data with PivotTables, Slicers, and PivotCharts

 

  • Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  •  
  • Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  •  
  • Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  •  
  • Summary
  • Review Questions

 

Inserting Graphics

 

  • Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  •  
  • Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  •  
  • Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  •  
  • Summary
  • Review Questions

 

Enhancing Workbooks

  • Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  •  
  • Manage Themes
  • About Themes
  • Customizing Themes
  •  
  • Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  •  
  • Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  •  
  • Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  •  
  • Summary
  • Review Questions

Extra Materials

  • Appendices
  • 11 Practical Labs
  • Keyboard Shortcut Quick Reference Sheet
  • Glossary

Certification

Courses featured on

Liquid error: Could not find asset snippets/eu-cookie-banner-app.liquid