Roane State- Excel Level 3

  • Share:
Name: Roane State- Excel Level 3
Date: January 26, 2018
Time: 9:00 AM - 4:30 PM EST
Event Description:
Table Of Contents:


Unit 1: Logical and statistical functions
Topic A: Logical functions
Topic B: Math and statistical functions

Unit 2: Financial and date functions
Topic A: Financial functions
Topic B: Date and time functions
Topic C: Array formulas
Topic D: Displaying and printing formulas

Unit 3: Lookups and data tables
Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 4: Advanced data management
Topic A: Validating cell entries
Topic B: Exploring database functions

Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Topic C: Getting external data

Unit 6: Analytical tools
Topic A: Goal Seek and Solver
Topic B: The Analysis ToolPak
Topic C: Scenarios

Unit 7: Macros and custom functions
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Creating functions

Roane State Community College
Oak Ridge Campus
Date/Time Information:
Date: January 26, 2018
Day: Friday
Time: 9:00 AM to 4:30 PM
Contact Information:
Alicia Hall
Set a Reminder:
Enter your email address below to receive a reminder message.