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 […]
In today’s world it is important that your data tell a story. Excel charts allow you to easily show your KPI’s. In this instructor-led course you will learn the meaning of each chart type, when to use specific chart types, assemble them into a dynamic dashboard and use conditional formatting to highlight specific data in […]
Create a Basic Excel® Worksheet: Perform Calculations in an Excel® Worksheet; 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 to show you how to create a polished and professional presentation without frustration and a huge time commitment. We will discuss different slide types and their benefits, so that you can use PowerPoint to tell the story you want to convey. You will also learn to use transitions and animation to […]
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 […]
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 […]
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 […]
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 […]
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 […]
If your organization is struggling with managing project deadlines, project communication and task management this is the course for you. In this course we will show you how to utilize Teams as a “single” source of truth for your project. You will learn how to use such things as announcements for project changes/updates, store project […]