1-on-1 Excel Intensive Training

Laser-focused, customized training sessions designed to help you hit the ground running when you get back to your office.

 

Customized Excel 1-on-1 Training - Atlanta, GA and online.

 

 

  • Do you need to improve your Excel skills in order to land the next opportunity or advance in your career?

  • Are there particular skills (ex., LOOKUP functions, Macros, VBA, Pivot Tables) that you need to master?

  • Do you want to learn in a supportive, friendly environment where you know you'll understand each step thoroughly before moving on?

  • Are you looking to get a firm foundation in the basics so that you feel confident working with Excel workbooks?

  • Are you struggling to understand a complex workbook someone else has created?

Then our intensive training is for you.

 

Your 1-on-1 session will be conducted by an Excel expert with over 10 years of training experience. (For testimonials, please click here.)

 

Our Training Approach

 

This isn't hours of talking head training. Instead, you will have brief periods of training followed by hands-on exercises to reinforce the lesson. Each lesson builds on the previous one so that you leave at the end of the day confident in your ability to tackle your Excel projects. We also offer the option of incorporating your Excel work files into our session.

 

Software Training - Organizations Impacted

 

 

What you get

 

One day (7 hours) or a half-day (4 hours) of customized training in the topic(s) of your choice. The intensives are held at our location at 1100 Peachtree Street in Atlanta, GA. Intensives are also offered online and instructors can travel to client locations outside of Atlanta (travel and hotel fees will apply).

 

One-day Excel Intensive Topics

 

Mastering Excel Essentials

 

If you would like to be more certain of your Excel skills, Mastering Excel Fundamentals is the course for you. This intensive includes a "deep dive" into the skills every Excel user must know.

 

Topics include creating Excel workbooks, navigating existing workbooks, creating functions and formulas, saving workbooks, setting up your pages, printing workbooks and more. This interactive course includes short training sessions followed by real-world practice exercises so that you get the opportunity to really master essential Excel skills.

 

Pre-requisite: Knowledge of Windows and your keyboard.

 

Mastering Pivot Tables & Charts

 

Do you have to be able to summarize and analyze thousands or hundreds of thousands of rows of data in a snap? Pivot tables and charts are the answer. In this intensive, you will learn how to create pivot tables and charts the right way, avoiding some of the common mistakes and pitfalls.

 

Pre-requisite: Mastering IF Functions or equivalent knowledge.

 

Excel Visual Basic for Applications

 

Have you tried using recorded macros, only to end up with results you didn't expect? Have your attempts at teaching yourself using Youtube videos only ended in more confusion? Did you inherit a macro-enabled workbook that you don't know how to edit?

 

In the Excel VBA Intensive, you will learn how to take your recorded macros to the next level. You will learn how to create visual basic for application modules and user-defined functions. You will also learn how to avoid common pitfalls. Your practices will focus on the most commonly used Excel VBA commands.

 

Pre-requisite: Recording Excel Macros or equivalent knowledge.

 

Half-Day Excel Intensive Topics

You may combine two half-day topics in a full day of intensive training.

Recording Excel Macros

 

Would you like to get started automating your tedious Excel tasks? In this intensive, you will learn to record macros to right way. This course includes the 1 thing you must know when recording macros (it makes your macros easily reusable), how to properly set up your recording environment and more).

 

Pre-requisite: Students are required to have at least an Intermediate level of Excel knowledge, which includes proficiency in all of the topics covered in the Mastering Excel Essentials intensive.

 

Mastering IF Functions

 

The IF function is one of the most powerful (and misunderstood) Excel functions. Not only will you learn the basic IF function, you will also learn how to combine multiple IF functions (Nested IFs), how to overcome the Nested IF restrictions, how to use IF with AND and OR functions, how to use aggregate IFs such as SUMIFs, COUNTIFs and more.

 

Pre-requisite: Students are required to have at least an Intermediate level of Excel knowledge, which includes proficiency in all of the topics covered in the Mastering Excel Essentials intensive.

 

Mastering VLOOKUP Functions

 

Like the IF function, VLOOKUP is extremely powerful and difficult to master. In this half-day intensive, you will become comfort a be using not only VLOOKUP functions, but HLOOKUPs as well. You will also learn how to overcome common VLOOKUP errors and to expand the power of VLOOKUP with by using MATCH and INDEX function combinations.

 

Pre-requisite: Proficiency in all of the topics in Mastering Excel Essentials and Mastering IF functions.

 

We encourage you to bring your work projects to our training sessions. We will customize the training so that you can immediately apply what you learn.


Our Excel Intensives Include:

  • Assessment conducted by our Master Instructor
  • Preparation of a customized training plan
  • Preparation of customized practice exercises (if needed)
  • Conducting the training session (by a Master Instructor or Instructor)
  • Training provided on-line or in person.
Please note: The preparation of a lesson plan and exercises takes an additional 1-2 hours for each hour of trainingWhen you sign up for a 4-hour training session, for example, we spend an additional 7-8 hours preparing for the session

The fees are $997 for a full day of training and $597 for a half-day of intensive training.

Next steps

Please complete the form below, and we will contact you to schedule an appointment. Please note:  Fees are due in full in order to guarantee your appointment, and all fees are due at least 6 business days before the training session is conducted.


Name required

Company

Business Type

Phone

E-Mail required

How did you find our site? Required-please be specific.


How may we help you?


 
Group Training Classes
 

For a schedule of our group Microsoft software training classes offered in Atlanta and online, please click here.

About your Instructor

JC 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. Jackie has taught programs for hundreds of business owners, Atlanta Technical College, Environmental Protection Agency, 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 $20 administrative fee. No refunds will be issued if student cancels within a week of class; student will be issued a credit.

image

Contact us for more info. >