Advanced MS Excel 2016 - Code Chiefs

Advanced MS Excel 2016

Regular price £29.00 Sale

Unlimited Access

6 Units, 37 Activities and Labs

Certificate of Completion

Level 3 Equivilent Content

6+ Hours of Content


Course Description

Learn about how to exploit advanced features in Microsoft Excel with our Advanced Microsoft Excel 2016 course which builds upon our introductory and Excel for Power Users course. Skills you will learn include:

Automating Worksheet Functionality

Auditing Worksheets

Analyzing and Presenting Data

Working with Multiple Workbooks

Exporting Excel Data

Importing and Exporting XML Data

Requirements

Our Advanced Microsoft Excel 2016 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 Advanced Microsoft Excel 2016 course is ideal for those students who want to build on the Excel for Power Users 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

Automating Worksheet Functionality

  • Types of Controls
  • Command Buttons
  • Quick Start Fields
  • Calendar/Datepicker Control
  • Form Layouts
  • Quick Styles
  • Tab Order
  • The Anchoring Tool
  • Move Form Controls
  • Add Form Controls
  • Remove Form Controls
  • Modify Data Sources
  • Set Form Control Properties
  • Manage Labels
  • Subforms
  • Tab Pages
  • Navigation Control and Navigation Forms
  • Setting Navigation Options
  • Creating a Navigation Form
  • Using a Navigation Form
  • Insert Headers And Footers
  • Insert Images
  • Auto-Order Forms
  • Sort Records
  • Apply Themes
  • Insert Backgrounds
  • Change Margins

Conditional Formatting​​​​​​​​​​​​​​

  • Summary
  • Review Questions

Auditing Worksheets

  • Field Properties
  • Input Masks
  • The Input Mask Wizard
  • Input Mask Characters
  • Lookup Lists
  • Expression Builder
  • Form Validation
  • Control Wizards
  • The Combo Box Control
  • The List Box Control
  • The Option Group Control
  • Record Validation
  • Summary
  • Review Questions

Analyzing and Presenting Data

  • Macros
  • The Macro Builder Window
  • Macro Actions
  • Types of Macro Actions
  • Action Arguments
  • Object Events
  • Macros in Access Web Apps
  • Macro Conditions
  • The Where Condition
  • Event Properties for Data Validation
  • Macro Actions for Data Validation
  • Embedded Macros
  • Event Properties for Automating Data Entry
  • Macro Actions for Automating Data Entry
  • Macros and VBA
  • Summary
  • Review Questions

Working with Multiple Workbooks

  • External Data Sources
  • The Linked Table Manager
  • Exclusive Mode
  • Database Access Modes
  • Database Backup
  • The Compact and Repair Database Option
  • Object Dependency
  • The Database Documenter
  • Performance Analyzer
  • Summary
  • Review Questions

Exporting Excel Data

  • The Export Process
  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Web Queries
  • The New Web Query Dialog Box
  •  
  • Summary
  • Review Questions
  •  

Importing and Exporting XML Data

  • XML
  • XML Components
  • XML Schemas
  • XML Maps
  • The XML Source Task Pane
  • Import and Export XML Data
  •  
  • Summary
  • Review Questions

 

Extra Materials

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

Certification

Courses featured on


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