NMJC Excel Level 3 9/2/2020
To register for this class, please visit the NMJC website.
- 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.
- Learn to record macros both Absolute and Relative
- Learn to modify macros
|Event Date||09-02-2020 8:30 am|
|Event End Date||09-02-2020 4:30 pm|
|Cut off date||08-31-2020 11:00 pm|
|Location||NMJC Training & Outreach Facility|