ICAC-FC200 Intermediate Level Spreadsheeting Skills: Assessing and Organizing Data
October 15 @ 9:00 am - 5:00 pm
FreeDelivery Method: Virtual
Location: Online
Duration: 2 Days
Date: 10/15/2024 – 10/16/2024
Time: 9:00 AM – 5:00 PM Eastern
This intermediate spreadsheeting course uses Microsoft® Excel to assess and organize data in an electronic format. The class is designed for learners who have experience using Excel and who want to increase their spreadsheeting knowledge and skills. Topics include text functions, absolute referencing, date and time functions, flash fill, handling formula errors, VLOOKUP, dynamic arrays, and data validation. The course combines live demonstrations, instructor-led exercises, and independent student exercises.
Key concepts covered in this course include:
• Relative, absolute, and mixed cell referencing
• Text, date, and time-based functions and formulas
• How to nest functions
• Management of delimited data
• VLOOKUP and XLOOKUP
• Dynamic arrays
Students who complete this course are eligible for 1.0 point toward the CECFE certification.