ONLINE - Excel Level 3 hosted by NMJC 4/21/2021

Register for class here.

Length/CPE Hours

CPE 7 hours

Class Time

8:30 a.m. – 4:30 p.m. Cental Time

Method of Delivery

This class will be held online using GoToMeeting.  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 GoToMeeting 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 GoToMeeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoToMeeting 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.

Course Description

Charting

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

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

Event Properties

Event Date 04-21-2021 8:30 am
Event End Date 04-21-2021 4:30 pm
Capacity 14
Registered 0
Available place 14
Cut off date 04-21-2021 8:00 am
Individual Price $99.00
Location ONLINE