Get the AdvantEdge with Microsoft Office and Professional Development Training

To register for a class, click “Get Tickets” under the desired class.  Or use the “Class Types” list to view available class dates by subject.

Microsoft Office

Leadership & Management

Communication

Team Dynamics

Personal Development

Upcoming Classes

Excel Basic Training

Virtual

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.

Get Tickets $275.00 9 tickets left

Excel Advanced Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Excel Intermediate Training

Virtual

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.

Get Tickets $275.00 11 tickets left

PowerPoint Basic Training

Virtual

PowerPoint Basic - Building Blocks 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. Topics 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. Our instructors are based in Arizona and Colorado but can travel to your location anywhere in the United States.

Get Tickets $275.00 12 tickets left

PowerPoint Intermediate Training

Virtual

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.

Get Tickets $275.00 11 tickets left

Excel Basic Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Excel Intermediate Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Excel Advanced Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Time Management with Outlook Training

Virtual

Time Management with Outlook Class Duration: 4 hours Format: Virtual classroom live training Do you feel like there is always too much to do in a day? Do you feel like too often things fall through the cracks? Training in Time Management can help you solve these issues. And with Time Management in Outlook, you can learn the additional tools this application has to help you get even more organized. This course teaches you all of the fundamentals of Time Management, so you can get more done with your day, feel less stressed, and know you have a complete handle on everything. Since Outlook is the tool most people use during the work week, this course also teaches techniques for time management in Outlook, and how you can leverage Outlook to be your organizational tool. You will also have ample hands-on activities to ensure you have mastered each lesson. Training Class Goal Students exiting this class will learn the fundamentals of Time Management and possess intermediate level Outlook skills for managing their time. Outlook for many people, is overwhelming, disorganized, and frustrating, but it does not have to be that way. In this class, we discuss how a combination of Time Management and Outlook skills can help you get the most from your day. Don’t let email control your day; learn how to control it. This course is will teach you the critical Time Management skills to deal with everything from how to get organized to how to handle interruptions, and how to deal with paperwork. Students will learn the tools in Outlook, as well as other methods, that they can use, to best help in their individual situations. Prerequisites Students entering this Time Management training course should have foundational Microsoft Outlook skills including, sending email, scheduling appointments, and creating contacts. Topic Covered The Time Dilemma The 6 keys to time management Configuring Outlook to work for you Advanced toolbar Planning overview Outlook views Managing E-mail Chunking your time Overcoming the e-mail addiction Organizing emails Using rules Saving searches Flags and follow-ups Calendaring Saving time when viewing your calendar Scheduling appointments Scheduling meetings Sending reminders Tracking attendees Contacts E-mailing contact cards Categorizing contacts Flagging a contact Tasks Categories and views Custom task view Setting reminders Assigning tasks to others Scheduling time for tasks Managing larger projects with tasks Additional Time Management Techniques Taking control of your time Using notes Using the voting feature Dealing with paperwork In this course, you will learn key Outlook tips and tricks, and all of the Time Management fundamentals to help you turn chaos into calm. Training in Time Management can help you take back control of your life.

Get Tickets $275.00 12 tickets left

Excel Basic Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Excel Intermediate Training

Virtual

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.

Get Tickets $275.00 12 tickets left

Excel Advanced Training

Virtual

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.

Get Tickets $275.00 12 tickets left
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top