Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel 2016 Mac Training - ADVANCED - Atlanta, GA (May 2017)

PCC, LLC | Probiztechnology.com | 770.498.7333

Thursday, May 18, 2017 at 9:30 AM - Friday, May 19, 2017 at 4:30 PM (EDT)

Excel 2016 Mac Training - ADVANCED - Atlanta, GA (May...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Excel 2016 for the MAC - Level 2 May 11, 2017 $549.00 $0.00

Share Excel 2016 Mac Training - ADVANCED - Atlanta, GA (May 2017)

Event Details

Excel 2016 for the Mac Training - Level 2 - Atlanta, GA

Level 2: 2 days

In Excel 2016 for the Mac Level 2, you will learn how to create and edit basic Microsoft Office Excel 2016 worksheets and workbooks. You will also learn how to format worksheets, create functions and formulas, create charts, work with worksheets and print workbooks.

Can't attend? Want us to bring this course to your site? We offer affordable, customized training for groups of as few as 4 people. Contact us or call 770.498.7333 for details.

The employers we've provided software training for include ...

Microsoft Training Atlanta by Subject Matter Experts

Excel 2016 for the Mac - Level 2 (2 Day Class)

***Please bring your MacBook with Excel 2016 installed.*** 

This course is designed for students who are proficient in Basic Excel MAC and want to take their skills to the next level.

Topics:

 

Lesson 1 – Tables and Ranges

Basic to Advanced Filters

Excel Tables

Lesson 2 –Subtotals and Validations

Split Fixed and Delimited Data
Create Automatic Subtotals
Consolidate Data Across Multiple Ranges
Data Validation
Remove Duplicates

Session 3 – Advanced Functions 

Formula Builder
PMT Function
PV and FV Functions
IF, AND, OR Function
Aggregate IF Functions (SUMIF, COUNTIF, etc.)
DATEDIF Function
Date and Time Functions
Text Functions
VLOOKUP Function

Session4 – Names and Formula Auditing 

Named Ranges
INDIRECT Function
OFFSET Function
Checking and Tracing Formula Errors

Session 5 – Data Tables, Scenario, Goal Seek 

Create Data Tables
Scenarios, Goal Seek, Solver
Custom Views
Control Workbook Changes

Session 6 – Hyperlinks and Workgroups 

Hyperlinks: Worksheets, Ranges, Workbooks
Embed Excel Worksheets
Embed Excel Charts
Sharing Workbooks
Sharing Workbooks

Session 7 – Forms and Macros 

Create workbook forms
Understanding Macros and VBA
Recording Macros
Running Macros

Session 8 – Pivot Tables 

Create Pivot Table
Applying Filters to Pivot Tables
Filter Pivot Tables Using Slicers
Creating Custom Pivot Table Styles
Adding Calculated Fields and Items
Grouping by Text, Date
Working with Multiple Pivot Tables

 

For additional information about Excel 2016 Level 2 for the Mac, please call 770.498.7333. 

Prerequisites: Prospective students should be familiar with the Excel for the MAC basic skills. They should be comfortable in the Macintosh environment and be able to use Macintosh to manage information on the computer. 

 For additional information about Excel 2016 for the Mac, please  call 770.498.7333. 

Feedback:


I highly recommend the Excel ... class to anybody who wants to learn ...  Excel.   Jackie teaches the class at a pace that is enjoyable.   You can learn a lot from this class even if you have never seen Excel before.

Learning how to use Excel spreadsheets has enabled me to record and interpret data in a MUCH FASTER and more efficient way.  I had been putting off how to use Excel, and Jackie greatly relieved my anxiety by showing me the ropes of Excel and making it easy for me to learn.

Grade given the course: A+ 

David Redding, M.D. Redding Allergy and Asthma Center

Dates / Times (2 Sessions, 12 hours total)

Day 1 - Excel for the Mac 2016 

Day 2  - Excel for the Mac 2016 

 

Your registration fee includes:

  • Hands-on computer based training
  • Live, instructor-led training
  • Training manual
  • Real world exercises.

Pre-requisites: Please see above

Contact us:


To contact us about scheduling a presentation at your location, or to answer any questions please click here or call 770.498.7333. 

About your instructor 
Ms. Kiadii helps business professionals use technology to save time, lower costs and increase profits. She provides business technology workshops, customized software training, and Access database solutions. She has taught programs for hundreds of business owners, the Small Business Development Center (GSU), Small Business Administration (Atlanta), Women's Economic Development Agency, Georgia Center for Nonprofits. 

Refund / Cancellation Policy:
If instructor cancels class, students will be issued a full refund. If a student cancels registration, at lease one week prior to class, instructor will issue a refund less $85 administrative fee or 15%, whichever is larger. No refunds will be issued if student cancels within a week of class; student will be issued a credit. Credits are good for 90 days. 

Have questions about Excel 2016 Mac Training - ADVANCED - Atlanta, GA (May 2017)? Contact PCC, LLC | Probiztechnology.com | 770.498.7333

Save This Event

Event Saved

When & Where

1100 Peachtree Street
Suite 200
Atlanta, GA 30309

Thursday, May 18, 2017 at 9:30 AM - Friday, May 19, 2017 at 4:30 PM (EDT)


  Add to my calendar

Organizer

PCC, LLC | Probiztechnology.com | 770.498.7333

Logos

 

 

 

 

 

 


- Access Training by Experts - Atlanta, GA
- Excel Training by Experts - Atlanta, GA (Includes VBA, PowerPivot, Pivot Tables & More!)
- Customized 1-on-1 Excel Intensives
- Project Training by Experts - Atlanta, GA
- Tech Coaching & Consulting


1100 Peachtree Street
Suite 200
Atlanta, GA 30309
770.498.7333 [phone]
http://www.probiztechnology.com [web]

 

  Contact the Organizer
Excel 2016 Mac Training - ADVANCED - Atlanta, GA (May 2017)
Things to do in Atlanta, GA Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.