Excel 2011: Level 2 (Macintosh)

COURSE OUTLINE:

Description You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects

Audience
This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Prerequisites
Before starting this course, students are recommended to take the following Element K course or have equivalent knowledge: Microsoft® Office Excel® 2011: Level 1 (Macintosh).

Learning Objectives
Upon successful completion of this course, students will be able to:

use advanced formulas.
organize worksheet and table data using various techniques.
create and modify charts.
insert and modify graphic objects in a worksheet.
customize and enhance workbooks and the Microsoft Office Excel environment.

Course Content

Lesson 1: Calculating Data with Advanced Formulas: Topic 1A: Apply Cell and Range Names; Topic 1B: Calculate Data Across Worksheets; Topic 1C: Use Specialized Functions; Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data: Topic 2A: Create and Modify Tables; Topic 2B: Format Tables; Topic 2C: Sort or Filter Data; Topic 2D: Use Functions to Calculate Data; Topic 2E: Create a PivotTable Report

Lesson 3: Presenting Data Using Charts: Topic 3A: Create a Chart; Topic 3B: Modify Charts; Topic 3C: Format Charts

Lesson 4: Inserting Graphic Objects: Topic 4A: Insert and Modify Pictures and Clip Art; Topic 4B: Draw and Modify Shapes; Topic 4C: Illustrate Workflow Using SmartArt Graphics; Topic 4D: Layer and Group Graphic Objects

Lesson 5: Customizing and Enhancing the Excel Environment: Topic 5A: Customize the Excel Environment; Topic 5B: Customize Workbooks; Topic 5C: Manage Themes; Topic 5D: Create and Use Templates

RELATED COURSES

Desktop Applications
Microsoft Excel

Excel® 2013: Data Analysis with PivotTables

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing so much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Desktop Applications
Microsoft Excel

Excel 2016/2019 Programming with VBA

Prerequisites Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the…

Desktop Applications
Microsoft Excel

Excel 2016/2019/365: Level 2 – Advanced Functions, Charts & PivotTables

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information 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 and that’s a trend not likely to change, or even slow down, 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 and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. 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. In other words, 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.

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

Desktop Applications
Microsoft Excel

Excel 2013: Level 1 – Worksheets, Formulas & Formatting

In this course, you will use Microsoft Excel 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. Even if you have used Excel before or are a self-taught user you will learn a variety of valuable time-saving Excel tips and tricks.