Course Description:
Day 1:
You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Day 2: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
Prerequisites: Before starting this course, students are recommended to take the following Element K course or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1.
Certification: This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.
2-Day 8:30 a.m. – 4:30 p.m. (classroom) Students can opt to register for 1 of the 2 days.