Excel 2013 Level 2
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

Whether you need to crunch numbers for sales, inventory, IT, HR, or other organizational purposes & departments, the ability to get the right info to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before & that's a trend not likely to change any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical & challenging everyday. You already know how to get Excel to perform simple calculations, modify your workbooks & worksheets to make them easier to read, interpret, and present. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data.When you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

AUDIENCE AND PREREQUISITES

This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

To ensure success, students should have completed Microsoft® Office Excel® 2013 Level 1 or have the equivalent knowledge and experience.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to minimum enrollment.

COURSE TOPICS:


Lesson 1: Customizing the Excel Environment
Configure Excel Options
Customize the Ribbon and the Quick Access Toolbar
Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas
Use Range Names in Formulas
Use Specialized Functions
Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting
Analyze Data by Using Text and Logical Functions
pply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables
Create and Modify Tables
Sort Data
Filter Data
Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts
Create Charts
Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Slicers

Appendix
Microsoft Office Excel 2013 Exam 77-420
Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Financial Functions
Date and Time Functions
Working with Graphical Objects