Excel Advanced Training
2023-11-14 13:00 - 17:00 (America/Denver) | Virtual
Excel Advanced Training
Class Duration: 4 hours
Format: Virtual classroom live training
This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level.
Training Class Goal
In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.
Prerequisites
Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.
Topics Covered

Advanced Formulas

Viewing available Excel functions
Basic text functions
Basic “IF” conditional formulas
Nesting “IF” statements
Concatenate and “IF” statements with concatenate
ISBLANK Function
COUNTBLANK Function
Arrays
Using name ranges in formulas

Look Ups and Other Functions

Lookups and Lookup functions
HLookup
VLookup
Calculating days of the week
Calculating number of weekdays from a date
Calculating months between 2 dates
SUMIF Function

Data Views, Layouts, and Rules

Transposing Data
Validations for length and drop-down lists
Custom Views

Introduction to Macros

Developer Tools
Saving Macros
Absolute vs Relative Macros
Recording Macros
Creating Macro buttons

Additional Tools in Advanced Excel

Embedding and linking
Editing and embedded object
Editing a linked object
Linking as an icon
Protecting worksheets
Locking cells
Protecting a workbook

Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.

PowerPoint Basic Training
2023-12-08 08:00 - 12:00, 2025-09-29 13:00 - 17:00, 2025-10-15 13:00 - 17:00
PowerPoint Basic – Building Blocks
Class Duration: 4 hours
Format: Virtual classroom live training
PowerPoint allows you to convey your ideas effectively to others with much greater impact than the spoken or written word alone can convey. Whether it is a sales proposal, a training session, or an annual stockholders’ presentation, PowerPoint will help you keep your audience riveted and ready to absorb the information you are presenting. Our Basic PowerPoint training class will introduce you to this important application, giving you the skills to build and run simple PowerPoint presentations, Navigating the software is simple with our tips and tricks. To make sure you are gaining a confident foundation in PowerPoint, our Basic class offers ample interactive activities. Our knowledgeable instructors will be there, to answer your questions and lead you a strong understanding of PowerPoint basics.
Training Class Goal
Students exiting this class will be able to build a simple PowerPoint presentation. They will learn to navigate the application, as well as utilize the different views available. Students will learn to create slides, insert text and graphics, and add charts to presentations to make data really pop. Animation and transitions between slides will also be covered. Finally, students we understand the various tools for finalizing their presentations.
Prerequisites
Students entering this Basic PowerPoint training course should possess basic computer skills, and have a familiarity with Microsoft Windows.
Topic Covered

Quick Access menu
Moving through slides
Views
Zooming
Building a new presentation
Entering text
Saving the presentation

Outline View

Creating new slides
Indent levels
Cutting and pasting text

Slide Master & Slide View

Formatting the slide master
Applying designs and styles
Working in the normal view
Inserting new slides
Customizing a slide

Pictures & Graphics

Inserting pictures
Resizing and moving pictures
AutoShapes
Entering text
Placing a picture on a slide
Placeholders
Drawing shapes

Charts

Adding a chart
Editing data in a chart
Formatting a chart

Transitions & Animations

Slide sorter view
Duplicating and rearranging slides
Slide show window
Animating text
Transitioning slides

Viewing the Presentation & Tools

Running the presentation
Packaging for CD
Audience handouts

AdvantEdge Training’s Basic PowerPoint class, will give you strong foundational skills in this application, allowing you to express your ideas with simple, yet solid, presentations. Our courses are designed specifically for companies and their employees.

PowerPoint Intermediate Training
2023-12-08 13:00 - 17:00
PowerPoint Intermediate – Designing for Presentation
Take your PowerPoint skills to the next level by learning to make more complex, interactive, and engaging presentations.
Class Duration: 4 hours
Format: Virtual classroom live training
Are your PowerPoint presentations lacking the polish or punch you’d like them to have? Our Intermediate PowerPoint training class lets you take your PowerPoint skills to the next level, enabling you to make more complex, interactive, and engaging presentations. This course will give you the ability to create presentations that will be more visually appealing and impactful when giving a presentation. The course provides ample interactive activity, allowing you to be sure that you have mastered each lesson. The course provides ample interactive activity, allowing you to be sure that you have mastered each lesson. Our experienced educators will be with you every step of the way, leading you to a thorough understanding of the material, and answering all of your questions.
Training Class Goal
Students exiting this class will learn the skills to create PowerPoint content for presentations. They will learn how to create consistent themes and color schemes, customize images with many unique tricks, and develop slides that will get the most audience retention. Students will understand more advanced slide formatting techniques and will learn to better use the master slide. They will learn to use more advanced techniques in working with pictures and SmartArt. More advanced presentation tools, provided in PowerPoint, will also be covered.
Prerequisites
Students entering the Intermediate PowerPoint training course should have a general familiarity with Microsoft PowerPoint, including adding slides, editing content, and working with graphics. Students should also feel comfortable working in Microsoft Word.
Topics Covered

Creating PowerPoint Slides for Impactful Presentations

The 5 step process to develop fast and professional PowerPoint presentations
How to create dynamic slides for presentations
How to create slides that increase audience retention and recall of content
Best practices for powerful PowerPoint presentations

Slide Master and Theme Formatting

Formatting the Slide Master
Changing theme colors
Creating custom font themes
Changing slide layouts
Themes and colors for consistent and polished presentations

Pictures and Images

The proper balance of images and text on a slide
The best types of images to use
Where to find images
Inserting pictures
Resizing and moving images
Cropping images

Pictures Special Effects

Expanding parts of images to create “blank space”
Making collages of images that look consistent
Modifying pictures with color and effects
Adjusting image shading and color to best display text
Using Blur effects for slide backgrounds
Rotating images

SmartArt

Creating SmartArt displays of information
Formatting SmartArt with color and shapes

Additional Tools

Using the mini slide-show window when editing
Working in Slide Sorter View

Interactive Components

Adding interactions with action buttons
Creating hyperlinks with images

Completing the Presentation

Running the presentation
Hiding slides
Creating Custom Shows
Audience handouts – avoiding the slide deck print!
Additional presentation tools
Tips and tools for best running presentations
Additional presentation techniques

Learn to go beyond the basics to build more complex and engaging presentations with AdvantEdge Training’s Intermediate PowerPoint training class. Our courses are designed specifically for companies and their employees.

Excel Functions and Formulas Training
2024-01-11 08:00 - 16:00
Excel Functions And Formulas Training
Class Duration: 7 hours
Format: Virtual classroom live training
Do you need that extra boost to develop more complex functions and formulas? In this class you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for easier use for others, as well as yourself. Our instructors will be on hand to help you gain a mastery of these advanced functions and formulas of Excel, as well as answer any questions you may have.
Training Class Goal
Bring your brains for this one! Students will leave this class with a solid understanding of advanced Excel formulas and functions that can help with their more complicated projects. This course takes an intense look at complex formulas, as well as how to nest several different functions. Students will learn how to create dynamic drop-down lists to automate their spreadsheets for others to use. Arrays will also be applied to expand formulas to wider uses. Students will also learn how to write formulas that create filtered columns that eliminate blanks.
Prerequisites
Students should enter this course with an understanding of Advanced Excel topics, including basic formulas, IF Statements, and basic Lookup formulas. This is an intense one day course, focusing on learning about functions and formulas.
Topics Covered

Workbook Efficiency Techniques
Logical and Information Functions

Nesting IF statements and Dates Functions
AND Functions

Text and Lookup Functions

Find
Len
Concatenate

Lookup Functions

VLOOKUP
HLOOKUP

Additional Functions

ISTEXT Functions
ISODD Functions
ISBLANK Functions
Array Functions with Transpose
Array Functions and SUM used with IF statements

Building Intelligence

Complex Nested IF Functions
Search, Length and Hyperlinks

Using Functions to Create Dynamic Dropdown Lists

VLOOKUP drop-down lists
IF and VLOOKUP combination functions
Indirect and VLOOKUP combination functions
Offset drop-down lists

Filtered Columns

ISTEXT function
ROW function
ISTEXT and ROW nested with IF functions
SMALL function
INDEX function
IFERROR function
ARRAY function
Validation Lists
Removing Blanks
No Blanks

In this advanced Excel formulas and functions course, you will learn applications for a large variety of functions by themselves and combined, enabling you to become a powerhouse in the world of spreadsheets.

Excel Pivot Tables and Charts Training
2024-02-08 13:00 - 17:00, 2024-05-28 13:00 - 17:00
Excel Pivot Tables and Charts Training
Class Duration: 4 hours
Format: Virtual classroom live training
In this Microsoft Excel Pivot Tables and Charts course you will learn how to analyze data using these important tools. You will learn how to turn a table of data into a manageable analysis, without ever having to alter the original table. You will also learn how to give your data more visual impact, using the many different charts available in Excel. Your instructor will be available to help you with any questions, as well as lead you to a thorough understanding of these powerful visual tools.
Training Class Goal
In the Microsoft Excel Pivot Table and Charts training, in our Denver and Phoenix training centers, students will come from class with more confidence in using Pivot Tables and Charts, as well as have an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate, compare, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables really pop. Students will also learn all of the different types of charts available in Excel, and when best to use each. Additional charting techniques will be covered, allowing the students make their charts really stand out from the default templates, including drop-lines and unique axis formatting, as well as using trending, and analysis tools.
Prerequisites
Students should enter the Excel Pivot Tables and Charts course with an understanding of Excel fundamentals, including formatting, navigation, and basic formulas.
Topics Covered

Pivot Tables training topics

Creating, sorting, and filtering data
Formatting styles
Numbers and layouts
Grouping data
Value Comparisons
Row and Column Comparisons
Adding running totals and percentage totals
Calculated fields and items
Combining multiple data sources
Creating Pivot Table charts with filters and design elements
Conditional formatting
Other classes covering Pivot Tables

Charts training topics

Creating charts
Understanding single versus multiple series charts
Modifying chart design, layout, and format
Creating charts from non-consecutive data
Drop-lines
Axis formatting
Replacing chart series with pictures or shapes
Analysis tools
Up-Down bars
Trending tools
Using secondary axis
Highlighting relationship differences with charts
Combining two charts into one
Doughnut Charts
Sub-Pie Charts
Paired Bar Charts
Radar Charts

The Microsoft Excel Pivot Tables and Charts training class will give you all the tools you need to understand both of these Excel features and how to use them like a master. Our courses are designed specifically for companies and their employees. Our instructors are based in Arizona and Colorado but can travel to train at your location anywhere in the US.

Excel Basic Training
2024-03-11 08:00 - 12:00, 2025-06-19 08:00 - 12:00, 2025-08-21 13:00 - 17:00, 2025-09-25 13:00 - 17:00, 2025-10-27 13:00 - 17:00, 2025-11-13 13:00 - 17:00, 2026-04-29 08:00 - 12:00, 2026-05-27 08:00 - 12:00
Excel Basic Training
Class Duration: 4 hours
Format: Virtual classroom live training
Are you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel, easily enter information into spreadsheets, learn tricks to best view and manipulate and format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work with pre-created spreadsheets, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level.
Training Class Goal
In this Basic Excel training course, students who complete the class will exit with a basic knowledge of Microsoft Excel, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it, giving you the foundation from which to grow.
Prerequisites
Students entering this class should possess general knowledge of the use of a computer, including the ability to use a mouse (click, double-click, right-click, click-and-drag), and the ability to type on a keyboard.
Topics Covered

Navigating to accomplish tasks

Using the Ribbon, Office Button, and menus (depending on software version)
Cells, columns, and rows
Keyboard shortcuts
Freezing and splitting panes
Zooming
Hiding columns and rows

Entering basic data into Excel

Formatting dates and times
Spell check
Undo and redo buttons
Creating and modifying tables
Sorting and filtering tables

Creating basic Excel formulas

Subtraction, division, multiplication
Cell references

Using functions

Manually typing functions
AutoSum and AutoCalculate

Moving and copying data

Cut, copy & paste
Fill handle
AutoFill
Flash Fill
Smart Tags

Organizing and Working with Multiple worksheets

Renaming and coloring tabs
Moving, copying, and inserting worksheets
Margins
Headers and Footers
Printing Options

Basic Excel Formatting

Adjusting width and alignment
Formatting text in cells
Wrapping and merging
Formatting numbers

The basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet, enter data into Excel, and even create simple formulas. Today, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.

Excel Basic Training
2024-05-20 08:00 - 12:00, 2024-06-24 08:00 - 12:00
Excel Basic Training
Class Duration: 4 hours
Are you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel, easily enter information into spreadsheets, learn tricks to best view and manipulate and format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work with pre-created spreadsheets, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level.
Training Class Goal
In this Basic Excel training course, students who complete the class will exit with a basic knowledge of Microsoft Excel, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it, giving you the foundation from which to grow.
Prerequisites
Students entering this class should possess general knowledge of the use of a computer, including the ability to use a mouse (click, double-click, right-click, click-and-drag), and the ability to type on a keyboard.
Topics Covered
Navigating to accomplish tasks

Using the Ribbon, Office Button, and menus (depending on software version)
Cells, columns, and rows
Keyboard shortcuts
Freezing and splitting panes
Zooming
Hiding columns and rows

Entering basic data into Excel

Formatting dates and times
Spell check
Undo and redo buttons
Creating and modifying tables
Sorting and filtering tables

Creating basic Excel formulas

Subtraction, division, multiplication
Cell references

Using functions

Manually typing functions
AutoSum and AutoCalculate

Moving and copying data

Cut, copy & paste
Fill handle
AutoFill
Flash Fill
Smart Tags

Organizing and Working with Multiple worksheets

Renaming and coloring tabs
Moving, copying, and inserting worksheets
Margins
Headers and Footers
Printing Options

Basic Excel Formatting

Adjusting width and alignment
Formatting text in cells
Wrapping and merging
Formatting numbers

The basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet, enter data into Excel, and even create simple formulas. Today, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks. Our instructors are based in Arizona and Colorado, but can travel to any location outside of those states.

Excel Intermediate Training
2024-06-25 13:00 - 17:00, 2025-01-29 13:00 - 17:00, 2026-04-29 13:00 - 17:00, 2026-05-27 13:00 - 17:00
Excel Intermediate Training
Class Duration: 4 hours
Are you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions, charting, and data tools. Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level.
Training Class Goal
In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.
Prerequisites
Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.
Topics Covered
Formulas & Functions

Typing formulas and functions
Cell references and reference formulas
AutoSum
The Functions Library
Average, date, and time functions
IF statements
Nested IF Statements

Moving and Copying Data in Excel

Cut, copy, and paste data
The Fill Handle
Absolute and relative references
AutoFill and custom Lists

Working with More Functions

Date and Time Functions
Calculating dates in years
IF Statements in Date Functions
The Proper Function
The Roundup Function

Working with Multiple Worksheets

Renaming worksheets
Color coding tabs
Moving and copying worksheets
3D reference formulas
Hyperlinks
ScreenTips

Formatting Cells and Appearance

Formatting text and numbers in cells
Merging cells
Wrapping text within a cell
Custom number formats
Conditional formatting
Copying formatting

Viewing Worksheets

Showing formulas and references
Tracing precedents and dependents
Grouping rows and columns
Cell comments
Headers and footers

Introduction to Basic Charts

Creating and defining a chart
Positioning, rotating, and resizing charts
WordArt in charts
Editing charts in Excel
Changing types
Formatting a data series
Multiple series charts
Sparkline charts

Intermediate Excel training covers things beyond the basics, to give you more developed skills in building your spreadsheets, creating formulas to automate them, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application. Our instructors are based in Denver and Phoenix, but can travel to any location in the nation.

PowerPoint Intermediate Training
2024-07-10 13:00 - 17:00, 2026-02-20 08:00 - 12:00
PowerPoint Intermediate – Designing for Presentation
Take your PowerPoint skills to the next level by learning to make more complex, interactive, and engaging presentations.
Class Duration: 4 hours
Are your PowerPoint presentations lacking the polish or punch you’d like them to have? Our Intermediate PowerPoint training class lets you take your PowerPoint skills to the next level, enabling you to make more complex, interactive, and engaging presentations. This course will give you the ability to create presentations that will be more visually appealing and impactful when giving a presentation. The course provides ample interactive activity, allowing you to be sure that you have mastered each lesson. The course provides ample interactive activity, allowing you to be sure that you have mastered each lesson. Our experienced educators will be with you every step of the way, leading you to a thorough understanding of the material, and answering all of your questions.
Training Class Goal
Students exiting this class will learn the skills to create PowerPoint content for presentations. They will learn how to create consistent themes and color schemes, customize images with many unique tricks, and develop slides that will get the most audience retention. Students will understand more advanced slide formatting techniques and will learn to better use the master slide. They will learn to use more advanced techniques in working with pictures and SmartArt. More advanced presentation tools, provided in PowerPoint, will also be covered.
Prerequisites
Students entering the Intermediate PowerPoint training course should have a general familiarity with Microsoft PowerPoint, including adding slides, editing content, and working with graphics. Students should also feel comfortable working in Microsoft Word.
Topics Covered
Creating PowerPoint Slides for Impactful Presentations

The 5 step process to develop fast and professional PowerPoint presentations
How to create dynamic slides for presentations
How to create slides that increase audience retention and recall of content
Best practices for powerful PowerPoint presentations

Slide Master and Theme Formatting

Formatting the Slide Master
Changing theme colors
Creating custom font themes
Changing slide layouts
Themes and colors for consistent and polished presentations

Pictures and Images

The proper balance of images and text on a slide
The best types of images to use
Where to find images
Inserting pictures
Resizing and moving images
Cropping images

Pictures Special Effects

Expanding parts of images to create “blank space”
Making collages of images that look consistent
Modifying pictures with color and effects
Adjusting image shading and color to best display text
Using Blur effects for slide backgrounds
Rotating images

SmartArt

Creating SmartArt displays of information
Formatting SmartArt with color and shapes

Additional Tools

Using the mini slide-show window when editing
Working in Slide Sorter View

Interactive Components

Adding interactions with action buttons
Creating hyperlinks with images

Completing the Presentation

Running the presentation
Hiding slides
Creating Custom Shows
Audience handouts – avoiding the slide deck print!
Additional presentation tools
Tips and tools for best running presentations
Additional presentation techniques

Learn to go beyond the basics to build more complex and engaging presentations with AdvantEdge Training’s Intermediate PowerPoint training class. Our courses are designed specifically for companies and their employees.

Excel Advanced Training
2025-01-30 08:00 - 12:00, 2025-03-06 08:00 - 12:00, 2025-08-26 08:00 - 12:00, 2026-05-01 08:00 - 12:00, 2026-05-28 08:00 - 12:00
Excel Advanced Training
Class Duration: 4 hours
This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level.
Training Class Goal
In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.
Prerequisites
Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.
Topics Covered
Advanced Formulas

Viewing available Excel functions
Basic text functions
Basic “IF” conditional formulas
Nesting “IF” statements
Concatenate and “IF” statements with concatenate
ISBLANK Function
COUNTBLANK Function
Arrays
Using name ranges in formulas

Look Ups and Other Functions

Lookups and Lookup functions
HLookup
VLookup
Calculating days of the week
Calculating number of weekdays from a date
Calculating months between 2 dates
SUMIF Function

Data Views, Layouts, and Rules

Transposing Data
Validations for length and drop-down lists
Custom Views

Introduction to Macros

Developer Tools
Saving Macros
Absolute vs Relative Macros
Recording Macros
Creating Macro buttons

Additional Tools in Advanced Excel

Embedding and linking
Editing and embedded object
Editing a linked object
Linking as an icon
Protecting worksheets
Locking cells
Protecting a workbook

Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.

Emotionally Intelligent Leadership
2026-04-30 08:30 - 16:30
Emotionally Intelligent Leadership Training
Class Duration: 7 hours
Format: Virtual classroom live training
In the Emotionally Intelligence Leadership training you will learn how to employ EI techniques to maximize your leadership influence. Whether you are a manager, supervisor, or leader or others, this course will help you refine the skills needed to lead so others follow. Learn how to read and influence others’ emotions, anticipate other’s behaviors, frame your communications and responses for maximum impact, develop the skills to be more effective in communication, manage conflicts better, and get people from no to yes.
Training Class Goals
This course will help you build your leadership toolbox with EI tools, strategies, and approaches to help you be a successful leader who others want to follow.
Prerequisites
None – this course is good for anyone who manages, supervises, or leads employees, or who is looking to move into one of those roles.
Topics Covered

What is Emotional Intelligence and why is it important for Leaders?
The 3 Strategic Components of EI
The 5 steps to begin an EI response
Reading ourselves

Understanding your Self-Perception
Emotional Self Awareness

Adjusting our Self-Expressions
Understanding triggers
Patterns, Habits and Baggage
Communication focus areas
Understanding Impulse Control
Communication for Leaders

Understanding and reading others
Filtering through the noise
Non-verbal techniques
Creating communication consistency

Using empathy to grow relationships
Diffusing emotion in others to improve communications
Avoiding emotional shark attacks
Behaviors that don’t BODE well
Changing reactions
Improving Communications with Another
Interpersonal techniques

Social responsibility
Building company relationships
Turing pessimists into optimists

Emotionally Intelligent Leadership Training is a critical component to being a successful businessperson and manager. EI Leadership is a skill that can be developed with the right training. This course will give you the toolbox of critical things you will need to get you started. Our courses are designed specifically for companies and their employees.
