Loading Shopping Cart Items...
Catalog
Instructor led
Added:
10:00 AM - 3:30 PM
Objectives: This class covers worksheets, formulas, and formatting.
Learn how to utilize charts, manage and summarize data, and utilize
LOOKUP and IF functions. Compatible with the latest version of Excel (Office
2019/2021/365. There may be some functions that aren’t available in older
versions (2016).
Who should attend: Anyone new to Excel or looking to improve how they
use Microsoft Excel.
Learning Outcomes:
Apply advanced cell referencing techniques (absolute, relative, mixed)
Use Date Functions
Design effective charts and graphs
Implement conditional formatting and explore more advanced formatting
options like data bars or color scales
Construct advanced formulas with functions like VLOOKUP, XLOOKUP,
INDEX MATCH, SUMIFS, COUNTIFS
Summarize data using data filters, grouping, and advanced techniques
using the Aggregate and Filter function
Manipulate data sets using tools like Text to Columns, Remove Duplicates,
and Data Validation
Automate tasks by customizing the AutoFil
Fees: $299 ASE members; $395.50 nonmembers
Objectives: This class covers worksheets, formulas, and formatting.
Learn how to utilize charts, manage and summarize data, and utilize
LOOKUP and IF functions. Compatible with the latest version of Excel (Office
2019/2021/365. There may be some functions that aren’t available in older
versions (2016).
Who should attend: Anyone new to Excel or looking to improve how they
use Microsoft Excel.
Learning Outcomes:
Apply advanced cell referencing techniques (absolute, relative, mixed)
Use Date Functions
Design effective charts and graphs
Implement conditional formatting and explore more advanced formatting
options like data bars or color scales
Construct advanced formulas with functions like VLOOKUP, XLOOKUP,
INDEX MATCH, SUMIFS, COUNTIFS
Summarize data using data filters, grouping, and advanced techniques
using the Aggregate and Filter function
Manipulate data sets using tools like Text to Columns, Remove Duplicates,
and Data Validation
Automate tasks by customizing the AutoFil
Fees: $299 ASE members; $395.50 nonmembers
Credits awarded per Session. See individual Sessions for further details.
Credits awarded
Type
Name
Sub type
Value
$299.00
Already successfully completed: re-enrollment available!
Secure Transaction
Recently Added Items
About this item
10:00 AM - 3:30 PM
Objectives: This class covers worksheets, formulas, and formatting.
Learn how to utilize charts, manage and summarize data, and utilize
LOOKUP and IF functions. Compatible with the latest version of Excel (Office
2019/2021/365. There may be some functions that aren’t available in older
versions (2016).
Who should attend: Anyone new to Excel or looking to improve how they
use Microsoft Excel.
Learning Outcomes:
- Apply advanced cell referencing techniques (absolute, relative, mixed)
- Use Date Functions
- Design effective charts and graphs
- Implement conditional formatting and explore more advanced formatting
options like data bars or color scales - Construct advanced formulas with functions like VLOOKUP, XLOOKUP,
INDEX MATCH, SUMIFS, COUNTIFS - Summarize data using data filters, grouping, and advanced techniques
using the Aggregate and Filter function - Manipulate data sets using tools like Text to Columns, Remove Duplicates,
and Data Validation - Automate tasks by customizing the AutoFil
Fees: $299 ASE members; $395.50 nonmembers
Ratings and reviews
Type:
Name:
Sub type:
Value: