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

Untitled Document

Microsoft Training Atlanta

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

Schedule of December 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 December 2016 Courses

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Thu Dec 01 2016 – Thu Dec 01 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 2013 Training – Atlanta

Date:
Thu Dec 01 2016 – Fri Dec 02 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).

 

project training atlanta gaMS Project 2016 Training – Atlanta

Date:
Thu Dec 01 2016 – Fri Dec 02 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 Dec 02 2016 – Fri Dec 02 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 MAC training Atlanta

Excel 2016 MAC Training – Atlanta, GA
Date: Tue Dec 6 – Wed Dec 7
Time: 9:30 am – 4:30 pm
Place: 3355 Lenox Road, Suite 750, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/excelmactrainingatlanta.htm
Please bring your Macintosh to this training.

 

Excel VBA Training - Atlanta, GAExcel Macros & VBA – 2 Days (Visual Basic for Applications)

Date:
Wed Dec 07 2016 – Thu Dec 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).

 

QuickBooks Logo - Training in Atlanta, GA

 

 

QuickBooks Online Fundamentals (2 Day Class)

Date:
Thu Dec 08 2016 – Fri Dec 09 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, GA

Excel 2010 Pivot Tables Training – Atlanta

Date:
Fri Dec 09 2016 – Fri Dec 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, GA

Excel 2016 Pivot Tables Training – Atlanta

Date:
Fri Dec 09 2016 – Fri Dec 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).

 

Access 2010 Training - Atlanta, GAAccess 2010 Comprehensive Training – MCAS Certification Prep

Date:
Mon Dec 12 2016 – Thu Dec 15 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 2013 Comprehensive Training – MCAS Certification Prep

Date:
Mon Dec 12 2016 – Thu Dec 15 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 Dec 12 2016 – Thu Dec 15 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).

 

Sharepoint Training in Atlanta, GASharepoint 365 Training – Atlanta, GA

Date:
Mon Dec 12 2016 – Mon Dec 12 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 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Comprehensive Course – MOS Certification Prep

Date:
Tue Dec 13 2016 – Thu Dec 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 2013 Training by Subject Matter Experts - Atlanta, GA

Excel 2013 Pivot Tables Training – Atlanta

Date:
Fri Dec 16 2016 – Fri Dec 16 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 Comprehensive Course – MCAS Certification Prep

Date:
Mon Dec 19 2016 – Wed Dec 21 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 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training

Date:
Thu Dec 22 2016 – Thu Dec 22 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:
Thu Dec 22 2016 – Thu Dec 22 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 Dec 22 2016 – Thu Dec 22 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).

 

 

 

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, Access, Project Training – Atlanta, GA – October, 2016

Untitled Document

Microsoft Training Atlanta

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

Schedule of October 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 October 2016 Courses

 

Excel 2010 Training - Atlanta, GAExcel 2010 Comprehensive Course – MCAS Certification Prep
Date: Tue Oct 04 2016 – Thu Oct 06 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 Oct 04 2016 – Thu Oct 06 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: Fri Oct 07 2016 – Fri Oct 07 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 Oct 07 2016 – Fri Oct 07 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: Tue Oct 11 2016 – Wed Oct 12 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 2013 Training by Subject Matter Experts - Atlanta, GAExcel 2013 Pivot Tables Training – Atlanta
Date: Thu Oct 13 2016 – Thu Oct 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).

QuickBooks Logo - Training in Atlanta, GA QuickBooks Fundamentals (2 Day Class)
Date: Thu Oct 13 2016 – Fri Oct 14 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).

Access 2013 Training - Atlanta, GAAccess 2013 Comprehensive Training – MCAS Certification Prep
Date: Tue Oct 18 2016 – Fri Oct 21 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).

MS Project 2010 Training - Atlanta, GAMS Project 2010 Basic Training – Atlanta
Date: Tue Oct 18 2016 – Tue Oct 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: Tue Oct 18 2016 – Wed Oct 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: Wed Oct 19 2016 – Wed Oct 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: Thu Oct 20 2016 – Fri Oct 21 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 2010 Training - Atlanta, GAExcel 2010 PowerPivot Training
Date: Sat Oct 22 2016 – Sat Oct 22 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: Sat Oct 22 2016 – Sat Oct 22 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: Sat Oct 22 2016 – Sat Oct 22 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: Tue Oct 25 2016 – Thu Oct 27 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).

 

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, 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

 

Older posts «