In this instructor-led course you will learn how to up your formula knowledge in Excel. These formulas will allow you to make your spreadsheets more dynamic. We will discuss the importance of absolute cell addressing and then move to these exciting formulas. XLOOKUP/VLOOKUP FILTER SORT INDEX/MATCH COMBO SUMIFS/COUNTIFS COMBINATION FORMULAS UTILIZING AND/OR/NOT IFERROR IFNA RANK […]
Create a Basic Excel® Worksheet: Perform Calculations in an Excel®; Modify an Excel® Worksheet; Format an Excel® Worksheet; Print Excel® Workbooks; Manage an Excel® Workbook. Fee includes all training materials and 6 months of post-training phone or email support. Virtual Classroom THIS IS A VIRTUAL EVENT. MORE INFORMATION ON HOW TO LOG IN TO THE EVENT WILL BE SENT OUT […]
This course is designed for the HR Professional to learn how Microsoft Copilot can assist them with their job functions. Learn how Copilot can help you by creating job descriptions, screening resumes, creating onboarding plans, providing training materials, creating surveys, analyzing results, training material and more. You will also learn how Copilot infaces with all […]
As an HR Professional your time is extremely valuable. Using examples that an HR professional faces this course is designed for you to learn Excel skills that will help them save time and make be more productive. Learn how to use CONCAT (pull names together), LOOKUP (pull information from other sources), IF statements and various […]
Build on the Excel® skills you developed in Level 1 or increase your mastery of Excel® in this Level 2, one day workshop. Calculate Data with Advanced Formulas; Organize Worksheet and Table Data Present Data Using Charts; Analyze Data Using PivotTables, Slicers, and PivotCharts; Insert Graphic Objects Customize and Enhance the Excel® Environment ® Workbook Fee includes all training materials and 6 […]
Build on the Excel® skills you developed in Level 1 or increase your mastery of Excel® in this Level 2, one day workshop. Calculate Data with Advanced Formulas; Organize Worksheet and Table Data Present Data Using Charts; Analyze Data Using PivotTables, Slicers, and PivotCharts; Insert Graphic Objects Customize and Enhance the Excel® Environment ® Workbook Fee includes all training materials and 6 […]
This instructor-led course discusses guidelines for good data set structure and a discussion of data normalization. Participants will learn to extract data from CSV and Excel files and automate basic transformations, extract information from fields and transform datasets by grouping or combining data from different tables, or even multiple files from the same folder. Fee […]
In this session you’ll work on creating and editing macros, learn how to apply conditional formatting and how to add data validation criteria. In addition, you’ll learn how to share, track, merge and restrict workbook access. Then you’ll learn how to link data from cell to cell, sheet to sheet, Excel file to Excel file […]
This session will discuss best practices for time management and your email. Learn to customize your Outlook to maximize your working style as well as learn shortcuts for managing your email and repetitious emails, email options, working with your calendar effortlessly and creating and assigning tasks. Fee includes all training materials and 6 months of […]
Create a Basic Excel® Worksheet: Perform Calculations in an Excel®; Modify an Excel® Worksheet; Format an Excel® Worksheet; Print Excel® Workbooks; Manage an Excel® Workbook. Fee includes all training materials and 6 months of post-training phone or email support. Virtual Classroom THIS IS A VIRTUAL EVENT. MORE INFORMATION ON HOW TO LOG IN TO THE EVENT WILL BE SENT OUT […]