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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]