This intensive two-day training consolidates the most valuable material from our complete selection of Excel training programs:
- Excel Fundamentals (highlighting key shortcuts and efficiency tips from this course)
- Excel Chart Formatting and Report Design
- Excel Data Administration Features and Pivot Table Operations
- Excel Spreadsheet Operations, Mathematical Equations, and Functional Programming
- Excel Macros (supplemental instructional content)
This comprehensive, action-packed course delivers an overview of the most powerful and productivity-enhancing Excel skills available. Additionally, you'll obtain a complete package containing five volumes of Excel learning resources from each of these programs (including supporting worksheet data).
Through this comprehensive instructional collection, you will be capable of keeping pace with the instruction, together with examining supplementary material beyond what was included in the intensive program. Professionals preparing for Microsoft Office Specialist Credential exams who want a condensed Excel update might discover this program valuable as well.
Software Edition Information:
This instruction utilizes the 2019 release of Excel, but the vast bulk of material (with only a limited number of 2016 chart options) will transfer to users working with Excel 365/2019/2016/2013 versions.
Ideal Participant Profile:
You have comprehensive experience with Excel and have utilized it consistently for an extended period. Previously, other Excel specialists have possibly consulted you for guidance. However, with fresh functionality introduced in contemporary Excel, your skill set has not progressed correspondingly. To reclaim your advantage, you don't require a foundational program or concentrated training on a single element. You need an accelerated recap. A program providing rapid advancement. An experience covering the newest developments across all aspects, including diagrams, data management, summary tables, numerous tabs, sophisticated formulas, and an introduction to automation. If your Excel capabilities are robust and you want to become an Excel specialist, this training is perfect!
Who Shouldn't Enroll in This Class:
If you're just learning about Excel, this training isn't appropriate for you. Given that the instruction moves rapidly, your facilitator will be unable to stop and give individual support to participants who haven't fulfilled the entry requirements and don't have familiarity with fundamental Excel tasks. If you're unfamiliar with Excel, you should first take the Excel Basics training and then use Excel consistently for numerous months before enrolling in the Professional Operator program. For details on getting started, check Excel 2016 Fundamentals
Course Prerequisites:
This training is not appropriate for persons just starting to learn Excel. The regular prospect will either have self-directed experience or will have finished formal Excel education and will have been utilizing Excel consistently for a minimum of two years.
Comprehensive Program Outline:
Chosen Lessons from "Excel Fundamentals"
Getting Comfortable with Excel
Understanding the Ribbon Environment
Working with the File Menu
Using the Quick Access Bar
Accessing Excel Documentation: Using the Help Feature
Data Entry and Cell Selection
Choosing a Selection of Cells
Performing Auto Fill for Cell Information
Mathematical Operations and Formulation
Building a Formula
Using Auto Fill with Mathematical Expressions
Using Sum Automation
Printing and Distribution
Configuring Layout and Printing
Viewing Using Page Configuration
Utilizing Page Break Views
Key Content from "Excel Graphing, Formatting, and Presentation"
Building Graphical Representations
Developing a Visual Diagram
Modifying Chart Position and Sizing
Switching Chart Format
Updating Visual Elements
Altering Visual Formatting
Including or Taking Out a Value Set
Implementing Graph Filtering
Working with Charts and Diagrams
Building an Organizational Chart
Creating Frequency Distribution
Building Performance Analysis Visualization
Designing a Comparative Range Chart
Making Flowing Data Representation
Creating Mixed Data Representation
Building Small Visual Summary
Using and Storing Chart Design
Developing a Performance Reporting System
Applying Designs, Themes, and Pre-Built Layouts
Operating with Preset Formatting Options
Combining Design Configurations
Working with Design Themes
Working with Template Designs
Developing Custom Layouts
Applying Color and Design Elements
Making Specialized Color Patterns
Implementing Dynamic Color Coding
Setting Up New Dynamic Color Rules
Utilizing Smart Examination Capability
Working with Spreadsheet Information in Other Microsoft Programs
Recognizing Connecting, Incorporation, and Combining
Adding Spreadsheet Data into a Document
Inserting Spreadsheet Visuals into a Document
Transferring Spreadsheet Information into Slideshow
Adding Spreadsheet Visuals into Slideshow
Making a Visual in Documents or Presentation Software
Chosen Content from "Excel Administration, Formulas, and Computation"
Managing Spreadsheet Files
Performing Operations on Worksheet Sets
Handling Various Tabs and Multiple Files
Building References Across Sheets
Displaying Multiple Spreadsheet Tabs
Using Fixed References
Constructing References Spanning Multiple Files
Utilizing Financial Operations and Calendar Operations
Using Capital Calculation Formulas
Using Time and Date Operations
Implementing True/False Operations
Using the IFs
Incorporating Nested Operations
Using Complex Conditionals with the IFs Function
Stacking IFs Statements
Using Reference and Retrieval Operations
Using Directional Search and Vertical Search Utilities
Implementing the Discovery Operation
Using the Collection Operation
Using Grouped Collection and Discovery
Implementing Grouped Search with Discovery
Using Grouped Search with Discovery Functions
Chosen Material from "Excel Information Systems and Data Visualization"
Utilizing Data Collections
Setting Up and Using Fixed Reference Ranges
Securing and Freeing View Regions
Applying Operations to Collections
Employing Table Capabilities
Building a Data Collection
Organizing a Data Collection
Making a Data Filtering Tool
Utilizing Summary Features
Implementing Computed Fields
Changing Data Information
Loading Information from Text Records
Utilizing Smart Population
Connecting to Information from a Database Program
Developing and Using Summary Tables
Building a Data Summary using Spreadsheet Information
Creating a Data Summary from an Outside Connection
Using Filtering Selection
Using Vertical Search for Extending Lists
Strengthening Data Summaries
Using Collection Operations
Building a Data Filtering Device
Organizing Collections
Making a Computed Component
Constructing a Data Summary Diagram
Processing and Evaluating Data Information
Working with Automatic Hierarchy
Producing Total Rows
Setting Up Complex Filtering
Using Smart Examination Feature
Chosen Content from "Excel Macro Programming"
Operating with Automation Scripts
Preserving an Automation Script
Constructing an Automation Control
