logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

System Source Learning Center
410-771-5544

Call us for more information and to schedule your classes.

Excel 2013: Part 2

Course description

Excel Part 2

Target Student:

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

Prerequisites:

To ensure success, students should have completed Logical Operations Microsoft Office Excel Part 1 (Second Edition) or have the equivalent knowledge and experience.


Lesson 1: Customizing the Excel Environment

Topic A: Configure Excel Options

Topic B: Customize the Ribbon and the Quick Access Toolbar

Topic C: Enable Excel Add-Ins


Lesson 2: Creating Advanced Formulas

Topic A: Use Range Names in Formulas

Topic B: Use Specialized Functions

Topic C: Use Array Formulas


Lesson 3: Analyzing Data with Functions and Conditional Formatting

Topic A: Analyze Data by Using Text and Logical Functions

Topic B: Apply Advanced Conditional Formatting


Lesson 4: Organizing and Analyzing Datasets and Tables

Topic A: Create and Modify Tables

Topic B: Sort Data

Topic C: Filter Data

Topic D: Use SUBTOTAL and Database Functions


Lesson 5: Visualizing Data with Basic Charts

Topic A: Create Charts

Topic B: Modify and Format Charts


Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Slicers

 


Disclaimer: All course objectives and outlines are a guide for students. The course topics and order of presentation may be modified based upon the needs of each individual class.