Excel VBA, Access, Project, Sharepoint, QuickBooks, Excel Mac Training – Atlanta, GA – September, 2016

Untitled Document

Microsoft Training Atlanta

Excel VBA, Access, Project Training – Atlanta, GA

Schedule of September 2016 Courses

The only thing more expensive than education – is ignorance. Ben Franklin

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

We can provide on-site training for groups of as few as 4 people. Our on-site courses are a great value. Call 770.498.7333 or email us for information.

Since 2001, we’ve provided training for employers large & small, in the public and private sectors.

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

Jackie helped us develop our personal Access database for internal use. This custom training was invaluable to the success of our new initiatives.

Great presenter. Extremely engaging and knowledgeable of the subject matter. I personally enjoyed hearing real world experience w/ the product and the challenges faced.

Our office experienced numerous problems and downtime when we transitioned to Outlook 2010. In a few hours, Jackie was able to bring us up to speed – her training helped us save countless hours in wasted time.

 

Computer Training Atlanta

Schedule of September 2016 Courses

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Pivot Tables Training – Atlanta
Date: Thu Sep 01 2016 – Thu Sep 01 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)
Date: Wed Sep 07 2016 – Thu Sep 08 2016
Time: 9:00 am- 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Pivot Tables Training – Atlanta
Date: Fri Sep 09 2016 – Fri Sep 09 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Pivot Tables Training – Atlanta
Date: Fri Sep 09 2016 – Fri Sep 09 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Comprehensive Course – MCAS Certification Prep
Date: Tue Sep 13 2016 – Thu Sep 15 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

QuickBooks Logo - Training in Atlanta, GAQuickBooks Fundamentals (2 Day Class)
Date: Thu Sep 15 2016 – Fri Sep 16 2016
Time: 9:00 am – 5:00 pm
Place: .3355 Lenox Road, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/c_quickbooks_training_atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training
Date: Fri Sep 16 2016 – Fri Sep 16 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 PowerPivot Training
Date: Fri Sep 16 2016 – Fri Sep 16 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 PowerPivot Training
Date: Fri Sep 16 2016 – Fri Sep 16 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Comprehensive Training – MCAS Certification Prep
Date: Mon Sep 19 2016 – Thu Sep 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2016 Comprehensive Training – MOS Certification Prep
Date: Mon Sep 19 2016 – Thu Sep 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2011 Mac Training - Atlanta, GAExcel 2011 Mac Training – Atlanta, GA
Date: Thu Sep 22 2016 – Fri Sep 23 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excelmactrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Sharepoint Training in Atlanta, GASharepoint 365 Training – Atlanta, GA
Date: Fri Sep 23 2016 – Fri Sep 23 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/sharepoint365trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Training - Atlanta, GAAccess 2010 Comprehensive Training – MCAS Certification Prep
Date: Mon Sep 26 2016 – Thu Sep 29 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Tue Sep 27 2016 – Tue Sep 27 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2016 Training – Atlanta
Date: Tue Sep 27 2016 – Wed Sep 28 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Advanced Training – Atlanta
Date: Wed Sep 28 2016 – Wed Sep 28 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2013 Training – Atlanta
Date: Thu Sep 29 2016 – Fri Sep 30 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop (or let us know if we need to provide one).


7 Reasons to Attend Our Computer Training in Atlanta, GA:

  1. An investment in yourself yields the best return. In addition to being a potential tax-deductible expense, the investment you make in training yields returns in making you more productive and competitive.
  2. Passion – We go the extra mile. We choose instructors who are passionately committed to each student’s success, and we take the time to provide follow-up coaching (often at no extra cost) to make sure you are equipped to use the software. As one student says: Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified.
  3. Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
  4. Expertise. We only hire subject matter experts (SME) Since they know the subject matter inside and out, our instructors are able to adapt the training “on the fly” to meet students’ needs. To request instructor credentials, please click here.
  5. Affordable – a great value..
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Call for Instructors:

Are you a Subject-Matter Expert in Access, Excel, Project or QuickBooks?

Would you rather focus on training instead of getting business?

Our team is growing. For details, please click here.

Microsoft Office Trainers - Atlanta, GA

 

Pivot Table: How to Group Data by Number Ranges

Untitled Document

Excel pivot table tip

 

Do you have pivot table data that you would like to group by age, price range, or any other numerical data?

It’s possible and very simple, using pivot table’s group by number feature.

As an example, we have a pivot table that shows product sales and we want to find out the number of sales by price range.

Step 1: Clean Up Your Data

The first step is to make sure your raw dataset is clean. In order for this to work, all the values in the column you want to group on should be numbers. For additional tips on cleaning up your raw data, click here.

Step 2: Create the Pivot Table

Next, create a pivot table, with the field you want to group on as a row label. In our example, we are going to use the price as the row label, and the number (count) of transactions in the value area.

Pivot table field grouping by numbers

As you can see from the picture below, our resulting pivot table has individual prices. This is not helpful.

Pivot table initial results

 

Step 3: Group

Next, right-click on your grouping field (row label) and select group.

The Grouping dialog box pops up, with the lowest and highest numbers in your range already selected. Next to *By*, define the range. In our case, I will use 5. What is not shown in this graphic is that I also rounded the starting (10) and ending (35) numbers to make my groupings cleaner.

pivot table number grouping dialog box

Here is the original result.

pivot table number grouping results

I then changed the headings and formatted the numbers to make the results more visually appealing.

pivot table grouped by nubmers final result

 

Do you have an Excel question?

Comment below and it just might make it to a blog post!

About the Author

Jackie Kiadii and her team of subject matter expert (SME) trainers provide Microsoft software training that delivers measurable results – increasing productivity, reducing inefficiency, and improving the bottom line. Topics include: Project, Access, Excel, Excel VBA, PowerPoint. Upcoming Excel courses are on our calendar, click here.

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

Sharepoint, Excel VBA, QuickBooks, Access, Project Training – Atlanta, GA – August 2016

Untitled Document

Microsoft Training Atlanta

Excel VBA, Access, Project Training – Atlanta, GA

Schedule of August 2016 Courses

The only thing more expensive than education – is ignorance. Ben Franklin

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

We can provide on-site training for groups of as few as 4 people. Our on-site courses are a great value. Call 770.498.7333 or email us for information.

Since 2001, we’ve provided training for employers large & small, in the public and private sectors.

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

Jackie helped us develop our personal Access database for internal use. This custom training was invaluable to the success of our new initiatives.

Great presenter. Extremely engaging and knowledgeable of the subject matter. I personally enjoyed hearing real world experience w/ the product and the challenges faced.

Our office experienced numerous problems and downtime when we transitioned to Outlook 2010. In a few hours, Jackie was able to bring us up to speed – her training helped us save countless hours in wasted time.

 

Computer Training Atlanta

Schedule of August 2016 Courses

Sharepoint Training in Atlanta, GASharepoint 365 Training – Atlanta, GA
Date: Wed Aug 10 2016 – Wed Aug 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/sharepoint365trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training
Date: Thu Aug 11 2016 – Thu Aug 11 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 PowerPivot Training
Date: Thu Aug 11 2016 – Thu Aug 11 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

QuickBooks Logo - Training in Atlanta, GAQuickBooks Fundamentals (2 Day Class)
Date: Thu Aug 11 2016 – Fri Aug 12 2016
Time: 9:00 am – 5:00 pm
Place: .3355 Lenox Road, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/c_quickbooks_training_atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 PowerPivot Training
Date: Fri Aug 12 2016 – Fri Aug 12 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Comprehensive Course – MCAS Certification Prep
Date: Mon Aug 15 2016 – Wed Aug 17 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Thu Aug 18 2016 – Thu Aug 18 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2016 Training – Atlanta
Date: Thu Aug 18 2016 – Fri Aug 19 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Advanced Training – Atlanta
Date: Fri Aug 19 2016 – Fri Aug 19 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2013 Training – Atlanta
Date: Mon Aug 22 2016 – Tue Aug 23 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Training - Atlanta, GAAccess 2010 Comprehensive Training – MCAS Certification Prep
Date: Tue Aug 23 2016 – Fri Aug 26 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2016 Comprehensive Training – MOS Certification Prep
Date: Tue Aug 23 2016 – Fri Aug 26 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)
Date: Thu Aug 25 2016 – Fri Aug 26 2016
Time: 9:00 am- 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Application Development & Automation (VBA)
Date: Mon Aug 29 2016 – Thu Sep 01 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013applicationdevelopmenttrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Comprehensive Course – MCAS Certification Prep
Date: Mon Aug 29 2016 – Wed Aug 31 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Comprehensive Course – MOS Certification Prep
Date: Mon Aug 29 2016 – Wed Aug 31 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

7 Reasons to Attend Our Computer Training in Atlanta, GA:

  1. An investment in yourself yields the best return. In addition to being a potential tax-deductible expense, the investment you make in training yields returns in making you more productive and competitive.
  2. Passion – We go the extra mile. We choose instructors who are passionately committed to each student’s success, and we take the time to provide follow-up coaching (often at no extra cost) to make sure you are equipped to use the software. As one student says: Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified.
  3. Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
  4. Expertise. We only hire subject matter experts (SME) Since they know the subject matter inside and out, our instructors are able to adapt the training “on the fly” to meet students’ needs. To request instructor credentials, please click here.
  5. Affordable – a great value..
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Call for Instructors:

Are you a Subject-Matter Expert in Access, Excel, Project or QuickBooks?

Would you rather focus on training instead of getting business?

Our team is growing. For details, please click here.

Microsoft Office Trainers - Atlanta, GA

 

Excel VBA Tip: How to Protect Your Code from Prying Eyes (and Fingers)

Untitled Document

Excel VBA Tip - Protect Code

Once my Excel Macros and VBA students start writing code, the next thing they want to do is protect it from prying eyes and fingers.

There are good reasons to protect your code: to protect your intellectual property or prevent novices from changing (and destroying) it. There is a downside to protecting your code, however. Since users won’t have access to it, they won’t be able to troubleshoot errors.

There are at least two ways to protect your VBA code: you could create an add-in, or you could use the method I am about to share below.

Creating an add-in allows an extra tight layer of security, but it might be beyond the capabilities of most people who are just getting started with Excel macros and VBA.

This method is quicker, simpler, and will prevent the majority of attempts to view your code.

Go to the Visual Basic Editor (VBE). You can get there by clicking the Macro group on the Tools tab and selecting Visual Basic Editor. The shortcut: hold down the ALT and F11 keys.

Make sure the Properties Explorer window is on the left-hand side of your screen. If it isn’t, make it visible by using the keyboard shortcut CTRL R.

If you have more than one workbook open, you will see several projects in the Properties Explorer Window. Make sure the workbook (project) you want to protect is selected by clicking the name of the project.

 

Excel VBA Select Project

 

Go to the Tools menu and select VBA Project Properties.

excel vba vbe tools menu

 

 

Click the Protection tab. Check the Lock project from viewing box. Enter your password twice, and click OK.

 

Excel VBA Project Protect

 

Save and close your workbook. The next time you open it, your code will be protected from prying eyes (and fingers).

Excel Power Tips eBook

Grab your Excel Tips eBook by clicking here.

About the Author – Jackie Kiadii

Want to learn Excel Macros and VBA? We teach hands-on coding in a small class environment. In 2 days, you will have ample opportunity to practice what you learn and "break your code" in front of an expert who can help trouble-shoot. We also teach courses in Advanced Excel (VLOOKUP, Pivot Tables, Scenarios) and BI (Power Pivot).

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Quickbooks, Excel VBA, Access, Project Training – Atlanta, GA – July 2016

Untitled Document

Microsoft Training Atlanta

Excel VBA, Access, Project Training – Atlanta, GA

Schedule of July 2016 Courses

The only thing more expensive than education – is ignorance. Ben Franklin

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

We can provide on-site training for groups of as few as 4 people. Our on-site courses are a great value. Call 770.498.7333 or email us for information.

Since 2001, we’ve provided training for employers large & small, in the public and private sectors.

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

Jackie helped us develop our personal Access database for internal use. This custom training was invaluable to the success of our new initiatives.

Great presenter. Extremely engaging and knowledgeable of the subject matter. I personally enjoyed hearing real world experience w/ the product and the challenges faced.

Our office experienced numerous problems and downtime when we transitioned to Outlook 2010. In a few hours, Jackie was able to bring us up to speed – her training helped us save countless hours in wasted time.

 

Computer Training Atlanta

Schedule of July 2016 Courses

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Tue Jul 05 2016 – Tue Jul 05 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2016 Training – Atlanta
Date: Tue Jul 05 2016 – Wed Jul 06 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Advanced Training – Atlanta
Date: Wed Jul 06 2016 – Wed Jul 06 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

QuickBooks Logo - Training in Atlanta, GAQuickBooks Fundamentals (2 Day Class)
Date: Thu Jul 07 2016 – Fri Jul 08 2016
Time: 9:00 am – 5:00 pm
Place: .3355 Lenox Road, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/c_quickbooks_training_atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Comprehensive Course – MCAS Certification Prep
Date: Wed Jul 13 2016 – Fri Jul 15 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Comprehensive Course – MCAS Certification Prep
Date: Mon Jul 18 2016 – Wed Jul 20 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Comprehensive Course – MOS Certification Prep
Date: Mon Jul 18 2016 – Wed Jul 20 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Training - Atlanta, GAAccess 2010 Comprehensive Training – MCAS Certification Prep
Date: Tue Jul 19 2016 – Fri Jul 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2016 Comprehensive Training – MOS Certification Prep
Date: Tue Jul 19 2016 – Fri Jul 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Pivot Tables Training – Atlanta
Date: Thu Jul 21 2016 – Thu Jul 21 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Pivot Tables Training – Atlanta
Date: Fri Jul 22 2016 – Fri Jul 22 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Pivot Tables Training – Atlanta
Date: Fri Jul 22 2016 – Fri Jul 22 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)
Date: Mon Jul 25 2016 – Tue Jul 26 2016
Time: 9:00 am- 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Comprehensive Training – MCAS Certification Prep
Date: Tue Jul 26 2016 – Fri Jul 29 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2013 Training – Atlanta
Date: Thu Jul 28 2016 – Fri Jul 29 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop (or let us know if we need to provide one).

 

7 Reasons to Attend Our Computer Training in Atlanta, GA:

  1. An investment in yourself yields the best return. In addition to being a potential tax-deductible expense, the investment you make in training yields returns in making you more productive and competitive.
  2. Passion – We go the extra mile. We choose instructors who are passionately committed to each student’s success, and we take the time to provide follow-up coaching (often at no extra cost) to make sure you are equipped to use the software. As one student says: Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified.
  3. Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
  4. Expertise. We only hire subject matter experts (SME) Since they know the subject matter inside and out, our instructors are able to adapt the training “on the fly” to meet students’ needs. To request instructor credentials, please click here.
  5. Affordable – a great value..
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Call for Instructors:

Are you a Subject-Matter Expert in Access, Excel, Project or QuickBooks?

Would you rather focus on training instead of getting business?

Our team is growing. For details, please click here.

Microsoft Office Trainers - Atlanta, GA

 

Excel Tip: How to Make Formulas “Invisible”

Untitled Document

excel-how-to-hide-formulas

 

This question came up after I’d taught a session on protecting specific parts of a worksheet.

A student asked: I have quite a few complex functions in my workbooks, and I’d rather not have people try to edit them. Is there a way to protect my functions?

Answer: One option is to protect the cells that contain your functions and formulas.

The other option is to hide your functions so that others are not able to see them. Out of sight, out of mind.

The process for hiding your formulas and functions is quite simple.

1. Select the cells that contain the formulas or functions.

To select all of the cells that contain your formulas, click CTRL G. This opens the Go-To box.

Excel Goto Box

Click the Special button.

Put a check-mark next to Formulas, then click OK. When you return to your spreadsheet, you’ll notice all the cells containing formulas are highlighted.

Excel GoTo Special Formulas

2. Right-click and choose Format Cells.

3. Click the Protection tab in the Format Cells Dialog box.

4. Check the Hidden box, which will make your formulas invisible.

5. Click OK.

That’s it. If you want to go the extra step of protecting the sheet or cells, follow the instructions in this blog post.

 

About the Author

Jackie Kiadii and her team of subject matter expert (SME) trainers provide Microsoft software training that delivers measurable results – increasing productivity, reducing inefficiency, and improving the bottom line. Topics include: Project, Access, Excel, Excel VBA, PowerPoint. Upcoming Excel courses are on our calendar, click here.

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

 

Access AutoNumber: How to Default to 4 Digits

Untitled Document

Access 4 Digit AutoNumbers

AutoNumber is a special field type in Access. It is meant to be used as a primary key field. When you create an AutoNumber field, the values are unique integers that start with the number 1 and incremented by 1.

This question came up during an Access class: How do I set it up so that the AutoNumbers are all 4 digits?

The answer is very simple.

Create the AutoNumber field.

Switch to design view, and place your cursor next to the AutoNumber field.

In the properties panel (shown below) enter 0000 next to format. Autonumbers will automatically default to 4 digits (0001, 0002, etc.)

Access Field Properties Formatting Autonumber to 4 digits

Bonus: If you want the AutoNumber to include specific text, include that text in the format field. For example, a format of "GA-"0000 will generate AutoNumbers like GA-0001, GA-0002, etc.

Access Field Properties Autonumber Text 4 Digit Numbers

About the author.

Jackie Kiadii has 20 years of Access database development experience, and teaches Basic through Advanced Access courses, including an in-depth 4-day Access immersion course.

Access Database Training in Atlanta, GA and Online

Need more MS Access help? Here are your options.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

SharePoint, Quickbooks, Excel VBA, Access, Project Training – Atlanta, GA – June 2016

Untitled Document

Microsoft Training Atlanta

Excel VBA, Access, Project Training – Atlanta, GA

Schedule of June 2016 Courses

The only thing more expensive than education – is ignorance. Ben Franklin

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

We can provide on-site training for groups of as few as 4 people. Our on-site courses are a great value. Call 770.498.7333 or email us for information.

Since 2001, we’ve provided training for employers large & small, in the public and private sectors.

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

Jackie helped us develop our personal Access database for internal use. This custom training was invaluable to the success of our new initiatives.

Great presenter. Extremely engaging and knowledgeable of the subject matter. I personally enjoyed hearing real world experience w/ the product and the challenges faced.

Our office experienced numerous problems and downtime when we transitioned to Outlook 2010. In a few hours, Jackie was able to bring us up to speed – her training helped us save countless hours in wasted time.

 

Computer Training Atlanta

Schedule of June 2016 Courses

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Pivot Tables Training – Atlanta
Date: Fri Jun 03 2016 – Fri Jun 03 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Training - Atlanta, GAAccess 2010 Comprehensive Training – MCAS Certification Prep
Date: Tue Jun 07 2016 – Fri Jun 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2016 Comprehensive Training – MOS Certification Prep
Date: Tue Jun 07 2016 – Fri Jun 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Comprehensive Course – MCAS Certification Prep
Date: Wed Jun 08 2016 – Fri Jun 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

QuickBooks Logo - Training in Atlanta, GAQuickBooks Fundamentals (2 Day Class)
Date: Thu Jun 09 2016 – Fri Jun 10 2016
Time: 9:00 am – 5:00 pm
Place: .3355 Lenox Road, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/c_quickbooks_training_atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)
Date: Mon Jun 13 2016 – Tue Jun 14 2016
Time: 9:00 am- 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Tue Jun 14 2016 – Tue Jun 14 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2016 Training – Atlanta
Date: Tue Jun 14 2016 – Wed Jun 15 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Advanced Training – Atlanta
Date: Wed Jun 15 2016 – Wed Jun 15 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training
Date: Thu Jun 16 2016 – Thu Jun 16 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 PowerPivot Training
Date: Thu Jun 16 2016 – Thu Jun 16 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2013 Training – Atlanta
Date: Thu Jun 16 2016 – Fri Jun 17 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 PowerPivot Training
Date: Fri Jun 17 2016 – Fri Jun 17 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

SharePoint 365 Training by Subject Matter Experts - Atlanta, GASharepoint 365 Training – Atlanta, GA
Date: Fri Jun 17 2016 – Fri Jun 17 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/sharepoint365trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Comprehensive Course – MCAS Certification Prep
Date: Mon Jun 20 2016 – Wed Jun 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Comprehensive Course – MOS Certification Prep
Date: Mon Jun 20 2016 – Wed Jun 22 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Pivot Tables Training – Atlanta
Date: Thu Jun 23 2016 – Thu Jun 23 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Pivot Tables Training – Atlanta
Date: Thu Jun 23 2016 – Thu Jun 23 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Comprehensive Training – MCAS Certification Prep
Date: Mon Jun 27 2016 – Thu Jun 30 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

7 Reasons to Attend Our Computer Training in Atlanta, GA:

  1. An investment in yourself yields the best return. In addition to being a potential tax-deductible expense, the investment you make in training yields returns in making you more productive and competitive.
  2. Passion – We go the extra mile. We choose instructors who are passionately committed to each student’s success, and we take the time to provide follow-up coaching (often at no extra cost) to make sure you are equipped to use the software. As one student says: Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified.
  3. Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
  4. Expertise. We only hire subject matter experts (SME) Since they know the subject matter inside and out, our instructors are able to adapt the training “on the fly” to meet students’ needs. To request instructor credentials, please click here.
  5. Affordable – a great value..
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Call for Instructors:

Are you a Subject-Matter Expert in Access, Excel, Project or QuickBooks?

Would you rather focus on training instead of getting business?

Our team is growing. For details, please click here.

Microsoft Office Trainers - Atlanta, GA

 

Is It Time to Switch From Excel Pivot Tables to Power Pivot?

Untitled Document

 

Power Pivot vs Pivot Tables

It all began with Excel 2010. Microsoft offered PowerPivot (now known as Power Pivot) as one of the add-ons in the campaign to improve Excel’s Business Intelligence (BI) offering.

People who are new to Power Pivot are not really clear on what it does and how it relates to Pivot Tables. They often think of it as an alternative to Pivot Tables. This, technically, is not true.

 

What Power Pivot represents is another way of creating the data set used to generate Pivot Tables.

 

What does this mean? Pivot Tables can be based on data provided by Excel data sets, Excel tables or Power Pivot.

So which data set should you use? Let’s look at the pros and cons of each.

Pivot Tables based on Excel Data Sets – Pros and Cons

The benefit of using Excel data sets (or tables) is simplicity. You simply click within the data set and create the pivot table.

There are two problems with Excel data sets: size and performance. An Excel data set is limited to the size of an Excel worksheet: about 1,048,000 rows. Actually, it is limited to fewer rows because when you have more than 100,000 rows, your performance slows substantially.  Your file becomes super slow and Excel’s automatic calculations start to go a little berserk. It is also difficult to use data from more than one data source.

Pivot Tables based on Power Pivot Data Model – Pros and Cons

After recognizing the limitations of Excel when it comes to analyzing Big Data, Microsoft developed Power Pivot as a solution.

Power Pivot has incredible advantages when it comes to big data. Users can import, merge, and prepare data from multiple data sources at once. Power Pivot features data sets that allow you to have sets of columns visible and usable in all pivot tables since they’re all just a click away.

In addition, large data sets are no problem at all. Power Pivot can handle millions of rows of data.

Another convincing reason for Power Pivot is convenience. Since Power Pivot works with all the data in RAM, even if you lose connectivity or can’t get to your SQL server, you won’t have any problem with data you want to access or present.

There is a significant downside to Power Pivot – the learning curve. Creating a data set using the Power Pivot tool is not as straightforward as a button click, particularly if you are merging data from multiple sources. Fortunately, with the right training mastery is possible.

So, which is better – Excel data sets or the Power Pivot data model?

Anyone who has compared the two options will tell you that Power Pivot is the superior choice.

There is a lot to learn with Power Pivot, but if you are wondering whether you should make the switch, the ability to work on millions of rows of data and with multiple sources all at once should give you enough reason.

 

Excel VBA, Access, Project Training – May 2016

Untitled Document

Excel VBA, Access, Project Training – Atlanta, GA

Microsoft Training Atlanta

Schedule of May 2016 Courses

The only thing more expensive than education – is ignorance. Ben Franklin

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

We can provide on-site training for groups of as few as 4 people. Our on-site courses are a great value. Call 770.498.7333 or email us for information.

Since 2001, we’ve provided training for employers large & small, in the public and private sectors.

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

Jackie helped us develop our personal Access database for internal use. This custom training was invaluable to the success of our new initiatives.

Great presenter. Extremely engaging and knowledgeable of the subject matter. I personally enjoyed hearing real world experience w/ the product and the challenges faced.

Our office experienced numerous problems and downtime when we transitioned to Outlook 2010. In a few hours, Jackie was able to bring us up to speed – her training helped us save countless hours in wasted time.

 

Computer Training Atlanta

Schedule of May 2016 Courses

Excel 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training
Date: Tue May 03 2016 – Tue May 03 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 PowerPivot Training
Date: Tue May 03 2016 – Tue May 03 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 PowerPivot Training
Date: Wed May 04 2016 – Wed May 04 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/power-pivot-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)
Date: Thu May 05 2016 – Fri May 06 2016
Time: 9:00 am- 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Pivot Tables Training – Atlanta
Date: Fri May 06 2016 – Fri May 06 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Mon May 09 2016 – Mon May 09 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2016 Training – Atlanta
Date: Mon May 09 2016 – Tue May 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Advanced Training – Atlanta
Date: Tue May 10 2016 – Tue May 10 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm
Please bring your laptop (or let us know if we need to provide one).

project training atlanta gaMS Project 2013 Training – Atlanta
Date: Wed May 11 2016 – Thu May 12 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Pivot Tables Training – Atlanta
Date: Fri May 13 2016 – Fri May 13 2016
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Application Development & Automation (VBA)
Date: Tue May 17 2016 – Fri May 20 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013applicationdevelopmenttrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2013 Comprehensive Training – MCAS Certification Prep
Date: Mon May 23 2016 – Thu May 26 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2013 Training - Atlanta, GAAccess 2016 Comprehensive Training – MOS Certification Prep
Date: Mon May 23 2016 – Thu May 26 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Training - Atlanta, GAExcel 2010 Comprehensive Course – MCAS Certification Prep
Date: Tue May 31 2016 – Thu Jun 02 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2016 Comprehensive Course – MOS Certification Prep
Date: Tue May 31 2016 – Thu Jun 02 2016
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2016trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).


7 Reasons to Attend Our Computer Training in Atlanta, GA:

  1. An investment in yourself yields the best return. In addition to being a potential tax-deductible expense, the investment you make in training yields returns in making you more productive and competitive.
  2. Passion – We go the extra mile. We choose instructors who are passionately committed to each student’s success, and we take the time to provide follow-up coaching (often at no extra cost) to make sure you are equipped to use the software. As one student says: Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified.
  3. Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
  4. Expertise. We only hire subject matter experts (SME) Since they know the subject matter inside and out, our instructors are able to adapt the training “on the fly” to meet students’ needs. To request instructor credentials, please click here.
  5. Affordable – a great value..
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

To download our Computer Training Schedule in PDF format, please click here.

Computer Training Atlanta - Schedule of Classes

 

Older posts «