Excel for Business - Level 3

  • Share:
Name: Excel for Business - Level 3
Date: April 24, 2020
Time: 8:30 AM - 4:00 PM CDT
Event Description:

Course Outline

This course is designed for intermediate to advanced users, as it takes learners beyond the basics. Learn tips and tricks for advanced database functions such as pivot tables, absolute references, linked workbooks and more in this one day workshop.

Charting

  • Learn how to Charts
  • Learn how to Modify the Chart
  • Work with Chart Templates
  • Create Pivot Charts

Multiple Sheets and Linking

  • Learn Shortcuts for Navigating workbooks with Multiple Sheets
  • Learn how to Group sheets and create/modify sheets simultaneously
  • Learn how to create Formulas between sheets.
  • Create links between files

Working with Text

  • Work with the Text-to-Columns Feature
  • Use the new Flash Fill feature to combine and separate text
  • Learn Text Functions such as CONCATENATE, LEFT, RIGHT AND LEN.

Macros

  • Learn to record macros both Absolute and Relative
  • Learn to modify macros
Location:
Brownwood Area Chamber
Dr. Don Bostic Board Room
600 E. Depot   
Brownwood, Texas 76801    
Date/Time Information:
Friday April 24th, 2020
8:30 am to 4:00 pm
Contact Information:
Kim Springfield 325-646-9535
Send an Email
Fees/Admission:
$169
Chamber Members save with code Save20
Set a Reminder:
Enter your email address below to receive a reminder message.