Microsoft Excel

Microsoft Excel 2013

$159

10% discount for University of Arkansas Faculty, Staff and Current Students.

8:30 am - 4:30 pm CT

Lunch is on your own from 11:30 am - 12:30 pm CT

Capacity: 12 face-to-face students is the maximum per class.

Connected Classroom
Can't come to class? You can participate online via our online learning system, Blackboard Collaborate. Seating is unlimited. See the schedule below for availability.


Course Schedule

9/6/16  
Microsoft Excel Part 2
Global Campus Rogers - Room 405
9/9/16  
Microsoft Excel Part 1
Global Campus Fayetteville
9/23/16  
Microsoft Excel Part 2
Global Campus Fayetteville
10/7/16  
Microsoft Excel Part 3
Global Campus Rogers
10/28/16  
Microsoft Excel Part 1
Global Campus Rogers
11/15/16  
Microsoft Excel Part 3
Global Campus Rogers
12/2/16  
Microsoft Excel Part 1
Global Campus Rogers
Microsoft Excel

PART 1 - Basics

Course Description

The breadth of business, educational, and organizational information in existence today is absolutely staggering. Organizations the world over rely on this information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, the days of performing calculations and analyzing data on paper are pretty much gone. Imagine, if you will, having to calculate what percentage of your organization's sales occurred in one small town in, say, Brazil. If your organization operates in multiple countries and generates billions of dollars in revenue annually, it could take a lifetime to isolate the exact figures you need and then compare those to the rest of your revenues. Who has that kind of time? This is exactly where the power of Excel can help.

By applying the robust functionality that's built into Excel to your organization's raw data, you will be able to gain a level of insight into that data that would have been nearly impossible just a couple of decades ago. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.


Course Preview  0:22


Lesson Contents

Lesson 1: Getting Started with Microsoft Office Excel
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help

Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas

Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Colors to Worksheets
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Styles and Themes
Topic F: Apply Basic Conditional Formatting
Topic G: Create and Use Templates

Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Define the Page Layout

Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

Microsoft Excel

PART 2 - Intermediate

Course Description

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel®: Part 1 (Second Edition) 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.


Course Preview  0:21


Lesson Contents

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

Microsoft Excel

PART 3 - Advanced

Course Description

This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel®: Part 1 (Second Edition) and Part 2 (Second Edition) courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.


Course Preview  0:31


Lesson Contents

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References
Topic B: Use Links and External References
Topic C: Consolidate Data

Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Topic C: Work with Macros

Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions
Topic C: Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets
Topic A: Trace Cells
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Activate and Use the Solver Tool
Topic E: Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines