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 […]
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 […]
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 […]
Excel® offers increased functionality over the previous versions. Master the new features in this six-hour workshop, Level 1 workshop. Explore the new interface and navigation and learn how to create, modify and format worksheets; manipulate data; and perform calculations. Later you’ll tackle the development of a workbook from multiple worksheets, including how to reposition worksheets in a workbook […]
Build on the Excel® skills you developed in Level 1 or increase your mastery of Excel® in this Level 2, one day workshop. In this session you’ll work on creating workbooks using templates, sorting, subtotaling, filtering data, and analyzing data using Pivot Tables and Pivot Charts—including creation and formatting of Pivot Tables. Then we will address calculating data with advanced […]
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 […]