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 ...
***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.
Lesson 1 – Tables and Ranges
Basic to Advanced Filters
Lesson 2 –Subtotals and Validations
Split Fixed and Delimited Data
Create Automatic Subtotals
Consolidate Data Across Multiple Ranges
Session 3 – Advanced Functions
PV and FV Functions
IF, AND, OR Function
Aggregate IF Functions (SUMIF, COUNTIF, etc.)
Date and Time Functions
Session4 – Names and Formula Auditing
Checking and Tracing Formula Errors
Session 5 – Data Tables, Scenario, Goal Seek
Create Data Tables
Scenarios, Goal Seek, Solver
Control Workbook Changes
Session 6 – Hyperlinks and Workgroups
Hyperlinks: Worksheets, Ranges, Workbooks
Embed Excel Worksheets
Embed Excel Charts
Session 7 – Forms and Macros
Create workbook forms
Understanding Macros and VBA
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.
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
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.
Save This Event
When & Where
PCC, LLC | Probiztechnology.com | 770.498.7333
- 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
Atlanta, GA 30309