MOS: Excel 2013 – Part 3

Description

In this course, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2013. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.

This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.At course completion, students will:

  • Automate worksheet functions.
  • Audit worksheets.
  • Analyze data.
  • Work with multiple workbooks.
  • Import and export data.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

1 – WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS SIMULTANEOUSLY

Use 3-D References Use Links and External References Consolidate Data

2 – SHARING AND PROTECTING WORKBOOKS

Collaborate on a Workbook Protect Worksheets and Workbooks

3 – AUTOMATING WORKBOOK FUNCTIONALITY

Apply Data Validation Work with Forms and Controls Work with Macros

4 – APPLYING CONDITIONAL LOGIC

Use Lookup Functions Combine Functions Use Formulas and Functions to Apply Conditional Formatting

5 – AUDITING WORKSHEETS

Trace Cells Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

6 – USING AUTOMATED ANALYSIS TOOLS

Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Activate and Use the Solver Tool Analyze Data with Analysis ToolPak Tools

7 – PRESENTING YOUR DATA VISUALLY

Use Advanced Chart Features Create Sparklines

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Enrolled