Microsoft Excel 2016 Part 2

If you have a working knowledge of Excel Spreadsheets and are eager to do more with this popular office tool, TrainACE's Microsoft Excel 2016 Part 2 training course is ideal for you.

Our one-day, Instructor-Led Training will show you how to work with large worksheets in Microsoft Excel 2016, and use multiple worksheets and workbooks efficiently. You will also learn other intermediate skills including how to sort and filter data, create and format tables, save workbooks as Web pages, and how to share workbooks via email.

Successfully completing this course, will empower you to use Excel to analyze and visualize complex datasets in order to make smart and well-informed business decisions.

You'll learn how to:

• Work with functions and lists.
• Analyze datasets.
• Present data visually with charts.
• Understand how to create and utilize PivotTables and PivotCharts

Enroll today, by selecting a class' date, to the right

Learn More About 2016 Excel Part 2

Why Take MS Excel 2016 Part 2 Training in Maryland?

We all understand that the world is increasingly driven by algorithms and huge volumes of data. It's a trend that likely to continue, so anyone with the skills and experience to help organize, analyze and present data is likely to find a wide variety of opportunities in the business world. This is particularly true if you work or live in the Washington DC area where huge government agencies and major international companies are headquartered.

Whether you're looking to analyze sales results, inventory stock, break-down website statistics, manage human resources, or any other manner of organizational functions, the ability to present the right information in a timely fashion to the people who need it will give you a competitive advantage.

Microsoft Excel is the data analysis and presentation tool of choice for most organizations, and most people have enough knowledge of it to perform basic tasks. But there are far fewer people who can really make this powerful tool sing. Our 1-day class will take you to that next level.

TrainACE's 1-day Instructor-Led Excel Part 2 training class will expand on your basic knowledge of Excel concepts and teach you how to work with large worksheets in Microsoft Excel 2016 efficiently.

Building on the foundational skills learned in the MS Office Excel 2016 Part 1 course we'll teach you how to create advanced workbooks and worksheets, deepening your understanding of organizational intelligence.

Audience and Prerequisites:

This class is aimed at students who have a basic understanding of Microsoft Excel such as those who have completed TrainACE's Excel 2016 Part 1 course.

Signup today for our convenient 1-day Excel Basics boot camp!

Exam and Certification Requirements:

TrainACE's MS Excel Part 2 course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

What will I learn in this Excel Part 2 class?

Lesson 1: Working with Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Lesson 2: Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Lesson 3: Analyzing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers