Microsoft Excel Essentials Seminar for Mac

Training

Course Packages

Corporate Training

 Microsoft Office

   Word

   Excel

   Access

   PowerPoint

   Outlook

   Project

   Visio

 

QuickBooks

Bookkeeping

 

Graphics Software

   Photoshop

   Illustrator

   Indesign

   Dreamweaver

   Flash

 

Certifications

   A+

   Network+

   Security+

   Project+

   MCITP

   CCNA

   PMP/CAPM 

   CEH

   CISSP

   CISA

 

Testimonials

A very good class. I absolutely came away feeling comfortable with the program.
-Helena

Instructor was extremely knowledgeable and a pleasure to work with!
-Denise

Instructor was very friendly and through  he is very good and helped  me tremendously
-Blake

Instructor was absolutely terrific.   Best software training   I ever had.
-Greg

Instructor made learning pivot tables and charts very easy. I recommend this class  to anyone looking to learn Excel.
-Tiffany

Presentation was well done. Instructor was very knowledgeable and friendly. Made learning the complex formulas easy.
-Albert

I had taken classes at other schools. This class was one of the best I ever had. The instructor was great, class was small and computers were new.
-Latoya

I love the small class and smart teacher. He made learning easy  and fun.
-Angel

Although I have had Excel training before.   I have not had it with such clarity. I appreciate his presentation. I'm sure    I will be able to retain and use everything I learned. Special Thanks
-Sharon

Juan is an excellent instructor
-Joyce

The instructor was very clear when explaining every aspect of Excel. I really feel I learned a lot and will take other courses in the future
-Julia

"I was really impressed with how clear the instructor's instructions were, which made the course enjoyable.
-Izzy

Click Here for more Testimonials

 

Welcome to Excel Training for Mac

We are offering a Microsoft Excel for Mac seminar. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.

This is a great course for someone looking for a job that requires the use of Excel for Mac or to feel more comfortable using the program. This one day course will turn any Excel user into a Power User.

Benefits to this course:

  • Small class.

  • 100% hands on training. Every student gets their own Mac computer to follow along.

  • The Only Mac Excel class in New York City

  • Full day of training. 8 hours of total training time.

  • Convenient location in Midtown Manhattan. 2 blocks from Penn Station.

  • Learn to create simple to advance formulas, from SUM functions to IF, VLOOKUP, HLOOKUP, and nested functions.

  • Learn to create a variety of charts and data sets.

  • Learn to create PIVOT Tables and Charts.

  • Expert instructor with more than 10 years of financial experience using and teaching Excel.

  • A free retake if needed

The seminar will include a customize manual with step by step directions and a certificate at the end, showing that you attended the class.

Excel Seminar Cost: $149

Seminar Dates

Day

Seminar Time

Sign Up

May 25

Friday

10AM-6PM

Sign Up

June 8

Friday

10AM-6PM

Sign Up

June 22

Friday

10AM-6PM

Sign Up

July 20

Friday

10AM-6PM

Sign Up

Call us for information on how to have this class taught at your location for your employees
To schedule call: 212-564-2351

Topics covered:

Lesson 1: Creating a Basic Worksheet
Topic 1A: Explore the User Interface and the Ribbon
Topic 1B: Navigate and Select in Excel
Topic 1C: Obtain Help
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar
 
Lesson 2: Performing Calculations
Topic 2A: Create Basic Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions
 
Lesson 3: Modifying a Worksheet
Topic 3A: Manipulate Data
Topic 3B: Insert and Delete Cells, Columns, and Rows
Topic 3C: Search for Data in a Worksheet
Topic 3D: Spell Check a Worksheet
 
Lesson 4: Formatting a Worksheet
Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents
Topic 4F: Apply Cell Styles
 
Lesson 5: Printing Workbook Contents
Topic 5A: Print Workbook Contents Using Default Print Options
Topic 5B: Set Print Options
Topic 5C: Set Page Breaks
 
Lesson 6: Calculating Data with Advanced Formulas
Topic 6A: Manage Cell and Range Names
Topic 6B: Calculate Data Across Worksheets
Topic 6C: Use Specialized Functions
Topic 6D: Analyze Data with Logical and Lookup Functions
 
Lesson 7: Organizing Worksheet and Table Data
Topic 7A: Create and Modify Tables
Topic 7B: Format Tables
Topic 7C: Sort or Filter Worksheet or Table Data
Topic 7D: Calculate Data in a Table or Worksheet
 
Lesson 8: Presenting Data Using Charts
Topic 8A: Create a Chart
Topic 8B: Modify Charts
Topic 8C: Format Charts
 
Lesson 9: Analyzing Data Using PivotTables and PivotCharts
Topic 9A: Create a PivotTable Report
Topic 9B: Analyze Data Using PivotCharts

 

 
Copyright © 2007 AR Technical & Financial Solutions. All rights reserved.
Call: 212-564-2351