Microsoft® Excel® 2013: Level 2

Microsoft® Excel® 2013: Level 2

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Excel 2013

Course Number: 091052

Course Objective:

Upon successful completion of this course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.

Target Student:

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

Course Objective:

To ensure success, students will need to be familiar with or have the equivalent knowledge and experience of Microsoft® Office Excel® 2013: Part 1 (Second Edition).

Course Outline

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

< Back to Course Catalog

Google Rating

5.0

Based on 35 reviews

ESoftware Associates, Inc

5.0

Moble mike Pornhub P.

1692811237

Hailey Q.

1681658397

This was a great class for staff to attend. Each person had various skills associated with excel and we were able to customize the agenda to meet the needs of our agency. I really enjoyed the hands experience by completing exercises during the session. The presenter kept us engaged and had extensive knowledge on Excel. Would highly recommend!

James E.

1675436950

ESW has been a fantastic resource over the past 2 years to me and my business. I reached out to many companies back in 2020 looking for a software company to help with my very unique set of circumstances and desires. Every one of those other companies were rigid and stubborn. If we weren't going to do it like everyone else - they weren't interested. Then I found ESW and they gave me exactly what I wanted and even though they said they didn't have another client like me - they would make it work. I've worked with Brandon for 2 years and my personal growth and business growth has been unbelievable.When you're looking for a software company to help you build your desired tool to help you do whatever it is you're looking to create - call ESW, you'll be glad you did. During my time, which is still ongoing, I've had the ultimate privilege to work with Brandon and Hannah, but in my interactions with many other members of their team - the culture and service was consistent throughout - incredible. They deserve more than 5 stars.

Sarah G.

1675111317

Highly recommend. We had them build a payroll platform in excel from scratch. They built it exactly as we hoped and have been quick to respond to any additional enhancement requests, maintenance or items that need to be fixed.

Linda S.

1674753505

Organized a series of trainings for my department and had a wonderful experience with these folks. Stacey and Jennifer were very responsive to my questions and planning the different sessions to meet our departments needs and the trainer Alex was amazing. Everyone really enjoyed the training. Would recommend!