Skip To Content
woman working on spreadsheet z2021SP Excel to the Max is a Course

z2021SP Excel to the Max

Ended Apr 28, 2021
14.0 credits

Sorry! The enrollment period is currently closed. Please check back soon.

Full course description

Excel to the MAX 
April 27-28, 2021
8:30 a.m. - 4:30 p.m. CST

Live online via GoTo Meeting. This class is designed for the intermediate to advanced Excel user who wants to expand their knowledge of Excel. The focus of this class are topics such as Formulas, PivotTables, Charts, working with Multiple sheets and files and much more. Also we focus on learning shortcuts, keystrokes and the most efficient way to accomplish a task. In the class, you will learn:

FORMULA BASICS, ABSOLUTE REFERENCES AND NAMED RANGES

  • Review Basic Formulas
  • Work with Relative and Absolute References
  • Use Formula Auditing Tools
  • Create and use Named Ranges
  • Understand Guidelines and Scope of Named Ranges
  • Work with Shortcuts and Common Keystrokes
  • Understand the Parts of a Function
  • Use Auto-Calculate
  • Create Subtotals and Grand Totals
  • Work with Order of Calculation
  • Learn the IF and VLOOKUP Function
  • Work with text functions like CONCATENATE, LEFT, RIGHT, LEN
  • More text Functions such as UPPER, LOWER AND PROPER
  • Use the Text-to-Columns feature
  • Look at the new Flash Fill feature
  • Use Paste Special
  • Protect your formulas and files
  • Work with Date Functions like TODAY and NOW
  • Perform Date Calculations

WORKING WITH MULTIPLE SHEETS AND LINKS

  • Learn Excel’s sheet options
  • Learn to quickly navigate sheets
  • Learn to Copy and Insert sheets
  • Rename and Color sheet tabs
  • Group sheets and work with all sheets simultaneously
  • Ungroup sheets
  • Move and Copy sheets within the workbook and to new workbooks
  • Create three-dimensional formulas
  • View multiple sheets at the same time
  • Link workbooks and manage the links
  • Use Comments
  • Freeze Rows and Columns
  • Learn to Split Views

CHARTING

  • Create a Chart
  • Change the Chart Layout and Style
  • Use the new Recommended Charts and Chart Types
  • Change the Chart Type
  • Modifying Charts and Work with Chart Elements
  • Expand the Chart Data
  • Create and use Chart Templates
  • Look at the new Sparkline feature

EXCEL’S DATABASE FEATURES

  • Setup your spreadsheet correctly for Data features
  • Learn to Sort alphabetically, numerically, chronologically, colors, by icons and by custom list
  • Use Data Subtotals
  • Learn various ways to Filter data
  • Create Tables and Understand their benefits
  • Create and Modify PivotTables
  • Work with PivotTable Slicers and Timelines
  • Work with Recommended PivotTables

QUICK LOOK AT OTHER EXCEL FEATURES

  • Modify the Quick Access Toolbar
  • Customize the Status bar
  • Learn the benefit of using Styles
  • Work with Conditional Formatting
  • Modify the Ribbon and use Text to Speech
  • Work with Custom Views
  • Who Should Attend
  • Intermediate or Advanced Excel users who would like to expand their knowledge of Excel

Prerequisites

Students must have a beginner level knowledge of Microsoft Excel.

 

Method of Delivery

Live online via GoTo Meeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoTo Meeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Meeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

CPE Hours

Completion of the course will result in 14 CEUs.

Method of Delivery

Live online via GoTo Meeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoTo Meeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Meeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Cancellation Deadline

If you need to cancel your course registration, contact the Extended Studies office by February 19. Your registration fee will be refunded less a $10 processing fee.

  • By phone at 806-651-2037
  • By email jhanke@watmu.edu

If the course is cancelled due to instructor illness, the course will be rescheduled. If the participant cannot make the new date, a full refund will be issued.