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 2010: Level 3 – Macros, Auditing & What-If Analysis

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Related course: Excel 2010: Virtual Training – Pivot Tables

Desktop Applications
Microsoft Excel

Word 2016/2019/365: Part 3

Microsoft Word 2016 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

Desktop Applications
Microsoft Excel

Excel 2010: Level 4 – Power Users

You will use the advanced features of Microsoft Excel 2010 to attain proficiency as an Excel power user. This course is designed for advanced Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics.

Desktop Applications
Microsoft Excel

Word 2016/2019/365: Part 1

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.
Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.