Microsoft Excel

Microsoft Excel



Microsoft ExcelMastering Excel is a process. In our classes, you get hands-on Excel experience with expert instructors to guide you at every step. Combine the three Excel class levels for maximum skills, or take a single class to move your talent up a notch. Keep your instruction manual as a reference, and refresh your new skills with online tutorials. Excel gives you the power to organize, calculate, analyze, update and present your data, helping decision-makers move in the right direction.

$159

8:30 am - 4:30 pm
Lunch is on your own
11:30 am - 12:30 pm

10% discount for University of Arkansas Faculty, Staff and Current Students. To receive the discount, you must register with your uark email address and enter coupon code 'UA10' at checkout. Status will be verified and correct rate will be applied. Additional discounts do not apply.​

PART 1 - Basics Course

This introductory Excel class provides critical skills for new users and lays a foundation for future learning.


  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
  • Preview and Print a Workbook
  • Define the Page Layout
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
  • Microsoft Office Excel Exam 77-727
  • Microsoft Office Excel Expert Exam 77–728
  • Microsoft Excel Common Keyboard Shortcuts
  • Adding Borders and Colors to Worksheets
  • Basic Excel Customization

Course Preview 0:22

Course Preview Video

Part 1 Schedule


Register 6/2/17
Location:
Global Campus Rogers
Suite 402


Register 7/14/17
Location:
Global Campus Rogers
Suite 402


Register 8/18/17
Location:
Global Campus Rogers
Suite 402


PART 2 - Intermediate Course

You have basic Excel knowledge, but you want more. This mid-level class offers skills needed to create customized, advanced Excel workbooks and sheets. You will begin to analyze data by using functions, conditional formatting and PivotTables.


  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins
  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas
  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting
  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions
  • Create Charts
  • Modify and Format Charts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Course Preview 0:21

Course Preview Video


To get the most from the intermediate class, you should already know how to:

  • Create, format, save and print a workbook
  • Insert, delete and adjust cells, columns and rows
  • Search for and automatically replace data
  • Use worksheet formulas, functions and formats
  • Manage Worksheets and Workbooks (views and properties)

Part 2 Schedule


Register 6/9/17
Location:
Global Campus Rogers
Suite 402


Register 7/21/17
Location:
Global Campus Rogers
Suite 402


Register 9/8/17
Location:
Global Campus Rogers
Suite 402


PART 3 - Advanced Course

Build on your knowledge from the first two classes. With advanced Excel skills, you can wield the full power of Excel. Advanced skills allow you to get answers from vast amounts of data, use forecasting data, map data and collaborate with colleagues.


  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
  • Create Sparklines
  • Map Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends
  • Microsoft Office Excel Exam 77-727
  • Microsoft Office Excel Expert Exam 77–728
  • Microsoft Excel Common Keyboard Shortcuts
  • Cube Functions
  • Importing and Export Data
  • Internationalizing Workbooks
  • Working with Power Pivot
  • Advanced Customization Options
  • Working with Forms and Controls

Course Preview 0:31

Course Preview Video


To get the most from the advanced class, you should already know how to:

  • Configure Excel options, customize the ribbon and toolbar, and enable Add-Ins
  • Use range names, specialized functions and advanced conditional formatting
  • Sort and filter data and use database functions
  • Create, modify and format charts
  • Create PivotTables and use them to analyze and present data

Part 3 Schedule


Register 6/20/17
Location:
Global Campus Rogers
Suite 402


Register 10/6/17
Location:
Global Campus Rogers
Suite 402