Excel, VBA, Access Training – Atlanta, GA – March 2015

Untitled Document

Microsoft Training AtlantaExcel VBA, Access, Project Training – Atlanta, GA

Schedule of March 2015 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 March 2015 Courses

 

Access 2013 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Mar 02 2015 – Thu Mar 05 2015
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).

 
Excel 2010 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Mon Mar 09 2015 – Wed Mar 11 2015
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).

 
MS Project 2010 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Thu Mar 12 2015 – Thu Mar 12 2015
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).

 
MS Project 2010 Advanced Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Fri Mar 13 2015 – Fri Mar 13 2015
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).

 
Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Mar 16 2015 – Thu Mar 19 2015
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 Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class
Date: Mon Mar 16 2015 – Tue Mar 17 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm
Please bring your laptop (or let us know if we need to provide one).

Access Database 2010 Intermediate (Atlanta, GA)
Date: Wed Mar 18 2015 – Wed Mar 18 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Advanced (Atlanta, GA) 1 Day Training
Date: Thu Mar 19 2015 – Thu Mar 19 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

Excel Pivot Tables Training – Atlanta
Date: Fri Mar 20 2015 – Fri Mar 20 2015
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 Macros & VBA (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Mon Mar 23 2015 – Mon Mar 23 2015
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 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Wed Mar 25 2015 – Fri Mar 27 2015
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 2013 Training – Atlanta
project training atlanta gaDate: Thu Mar 26 2015 – Fri Mar 27 2015
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).

 

 
PowerPoint 2013 Comprehensive Training – Certification Prep
Powerpoint 2013 Training by Experts - Atlanta, GADate: Thu Mar 26 2015 – Fri Mar 27 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

 
Access 2013 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Mar 30 2015 – Thu Apr 02 2015
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

 

Paste Values Keyboard Shortcut (Excel Tip)

Untitled Document

If you do any work in Excel, you find yourself copying and pasting values often.

Here’s a quick tip on using keyboard shortcuts to paste values.

Step 1 – Copy the cells by using the CTRL C combination.

Step 2 – Paste the cells by using the CTRL V combination.

You will notice the paste options icon shows up at the bottom right hand corner of the cells  you just pasted.

Excel paste options icon

Step 3 – Paste Values

Before clicking any other keys, tap the CTRL key again. This opens your paste options box, to show the options shown below. Hit V again, which changes what you’ve just pasted into Values.

Excel paste special values

It is that simple!

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, Word, Outlook and Publisher. 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

 

Excel, VBA, Access, Powerpoint, Project Training in Atlanta – Feb 2015

Untitled Document

Microsoft Training AtlantaExcel, VBA, Access, Project Training – Atlanta, GA

Schedule of February 2015 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 February Courses

MS Project 2013 Training – Atlanta
project training atlanta gaDate: Tue Feb 03 2015 – Wed Feb 04 2015
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 Pivot Tables Training – Atlanta
Date: Fri Feb 13 2015 – Fri Feb 13 2015
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 Macros & VBA (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Mon Feb 16 2015 – Mon Feb 16 2015
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 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Wed Feb 18 2015 – Fri Feb 20 2015
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 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Feb 23 2015 – Wed Feb 25 2015
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).

 

PowerPoint 2013 Comprehensive Training – Certification Prep
Powerpoint 2013 Training by Experts - Atlanta, GADate: Thu Feb 26 2015 – Fri Feb 27 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.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

 

Ask Jackie: How to Copy Excel Subtotals to A New Workbook

Untitled Document

This question came in via email recently:

Jackie, a quick question. When I do subtotals, how can I copy just the totals to a new Excel workbook?

Brief Answer:

I’m glad you asked! The key to making this work is selecting the visible cells only. While there is a shortcut (which I will mention), I prefer using the GoTo dialog box for its added functionality and flexibility.

Step-by-Step Tutorial:

Collapse the rows so that only your subtotals are showing.

Click CTRL G to open the GoTo dialog box.

Click the Special button.

Go To Dialog Box by ExcelTrainingAtlanta.com

Select Visible Cells Only, then click OK. (The shortcut to select visible cells is ALT semi-colon.)

Excel GoToSpecial dialog box by ExcelTrainingAtlanta.com

Copy the visible cells (CTRL C) and paste them in the new workbook (CTRL V).

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, Word, Outlook and Publisher. 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

 

 

Software (Project, Excel, Access, VBA) Training – Atlanta – Jan. 2015

Untitled Document

Microsoft Training AtlantaExcel VBA, Access, Project Training – Atlanta, GA

Schedule of January 2015 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 January 2015 Courses

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Jan 05 2015 – Thu Jan 08 2015
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 Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class
Date: Mon Jan 05 2015 – Tue Jan 06 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm
Please bring your laptop (or let us know if we need to provide one).

 

Access Database 2010 Intermediate (Atlanta, GA)
Date: Wed Jan 07 2015 – Wed Jan 07 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Access 2010 Advanced (Atlanta, GA) 1 Day Training
Date: Thu Jan 08 2015 – Thu Jan 08 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

PowerPoint 2013 Comprehensive Training – Certification Prep
PowerPoint 2013 Training - Atlanta, GADate: Thu Jan 08 2015 – Fri Jan 09 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel 2010 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Mon Jan 12 2015 – Wed Jan 14 2015
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).

 

Intro to Excel 2013 – Atlanta, GA
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Jan 12 2015 – Mon Jan 12 2015
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013basictrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Excel 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Jan 12 2015 – Wed Jan 14 2015
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 Macros & VBA (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Thu Jan 15 2015 – Thu Jan 15 2015
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 Pivot Tables Training – Atlanta
Date: Fri Jan 16 2015 – Fri Jan 16 2015
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 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Tue Jan 20 2015 – Tue Jan 20 2015
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).

 

 

MS Project 2010 Advanced Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Wed Jan 21 2015 – Wed Jan 21 2015
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).

 

 

MS Project 2013 Training – Atlanta
project training atlanta gaDate: Thu Jan 22 2015 – Fri Jan 23 2015
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 2013 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Jan 26 2015 – Thu Jan 29 2015
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

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, Word, Outlook and Publisher.

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

Atlanta Software Training Schedule – Dec 2014

Untitled Document

Microsoft Training AtlantaExcel VBA, Access, Project Training – Atlanta, GA

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

Intro to Excel 2013 – Atlanta, GA
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Dec 01 2014 – Mon Dec 01 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013basictrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Dec 01 2014 – Wed Dec 03 2014
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 2013 Training – Atlanta (Evenings)
project training atlanta gaDate: Mon Dec 01 2014 – Thu Dec 04 2014
Time: 6:00 pm – 10:00 pm
Place: .online
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 Advanced Training for Peak Performers
Excel 2010 Training - Atlanta, GADate: Fri Dec 05 2014 – Fri Dec 05 2014
Time: 8:30 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excelallday.htm
Please bring your laptop (or let us know if we need to provide one).
Intro to Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Sat Dec 06 2014 – Sat Dec 06 2014
Time: 9:00 am – 1:30 pm
Place: .Online
For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm

WordPress Essential Training – Atlanta, GA (1-Day Course)
Wordpress Training in Atlanta, GADate: Sat Dec 06 2014 – Sat Dec 06 2014
Time: 9:00 am – 6:00 pm
Place: Online
For Info: http://www.probiztechnology.com/wordpresstrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

MS Project 2010 Training – Atlanta (Evenings)
MS Project 2010 Training - Atlanta, GADate: Mon Dec 08 2014 – Tue Feb 11 2014
Time: 6:00 pm – 10:00 pm
Place: online
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).
Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Dec 08 2014 – Thu Dec 11 2014
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 Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class
Date: Mon Dec 08 2014 – Tue Dec 09 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm
Please bring your laptop (or let us know if we need to provide one).

Access Database 2010 Intermediate (Atlanta, GA)
Date: Wed Dec 10 2014 – Wed Dec 10 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Access 2010 Advanced (Atlanta, GA) 1 Day Training
Date: Thu Dec 11 2014 – Thu Dec 11 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

 

Intro to Windows 8 Training – Atlanta, GA (Evenings)
windows 8 trainingDate: Thu Dec 11 2014 – Fri Dec 12 2014
Time: 6:00 pm – 10:00 pm
Place: .online
For Info: http://www.probiztechnology.com/windows8-training-atlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Excel Pivot Tables Training – Atlanta
Date: Fri Dec 12 2014 – Fri Dec 12 2014
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 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Dec 15 2014 – Thu Dec 18 2014
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 (Evenings)
Access 2013 Training - Atlanta, GADate: Mon Dec 15 2014 – Mon Dec 22 2014
Time: 6:00 pm – 10:00 pm
Place: .online (6 evenings)
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 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Mon Dec 15 2014 – Mon Dec 15 2014
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).
MS Project 2010 Advanced Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Tue Dec 16 2014 – Tue Dec 16 2014
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).
MS Project 2013 Training – Atlanta
project training atlanta gaDate: Wed Dec 17 2014 – Thu Dec 18 2014
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).
PowerPoint 2013 Comprehensive Training – Certification Prep
PowerPoint 2013 Training - Atlanta, GADate: Thu Dec 18 2014 – Fri Dec 19 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Excel Macros & VBA (Visual Basic for Applications)
Date: Fri Dec 19 2014 – Fri Dec 19 2014
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).

 

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

About Us

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, Word, Outlook and Publisher.

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 Totals Query Tip – Partition Function

Untitled Document

 

Partition function - Access Totals Queries

Imagine this. Your database contains customer data, and you want to group your customers by number of employees or company revenues.

Perhaps you have a table of employee data and you want to group employees by age group or salary.

Access partition function by age

 

How would you accomplish this?

Allow me to introduce you to the little-known, but very useful, partition function. The partition function, which shows how often values occur within a range, is used within a totals query.

About the Example

I will use a very simple example in this post. Once you know about the partition function, however, I am sure you will find other ways to use it.

The example in this blog post assumes you are an intermediate user and therefore know how to create queries and add fields to your query design grid.

We’ll start with a table that has 3,897 records and four fields: ID, Date of Birth, Employee ID and salary

We can use the partition function to see the number of employees in each salary bracket, shown in $25,000 increments.

Step 1- Create a query and add the table to it.

Click the Create tab, then Query Design. Add your table.

Step 2 – Change the query to a totals query.

Click the Design tab, and in the Show/Hide group click Totals.

access-query-totals

Step 3 – Create a calculated field (Employee_Num) that shows the number of employees.

Add the Employee ID field to the table and change the totals type to Count. You may also want to rename the new field Employee_Count.

Step 4 – Create another calculated field (Salary_Field) using the partition function.

The partition function has 4 required arguments:

Number: Usually the name of the field containing the values you want to measure (ex., Salary).

Start: A whole number measuring the start of the range (ex., $0)

Stop: Another whole number measuring the end of the range (ex., $300,000)

Interval: The size of the partition (ex., 25,000).

Here’s how the query design grid will look after you’re done. (Click the image to expand it.)

Access partition query

Here are the results of the query.

access-partition-query-results

 

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. Contact her at 770.498.7333.

Need more hands-on Access tips provided by an expert?

Need more MS Access help? Here are your options.

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

Excel, Project, VBA, Access Training in Atlanta, GA (Nov 2014)

Untitled Document

Microsoft Training AtlantaExcel VBA, Access, Project Training – Atlanta, GA

Schedule of November 2014 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 November 2014 Courses

Excel 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Nov 03 2014 – Wed Nov 05 2014
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).
Intro to Excel 2013 – Atlanta, GA
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Nov 03 2014 – Mon Nov 03 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013basictrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Word 2013 Comprehensive Training – Certification Prep
Date: Mon Nov 03 2014 – Wed Nov 05 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/word2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Intro to Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Fri Nov 07 2014 – Fri Nov 07 2014
Time: 9:00 am – 1:30 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm
Please bring your laptop (or let us know if we need to provide one).
Access 2013 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GA Date: Mon Nov 10 2014 – Thu Nov 13 2014
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).

 

 

Excel Advanced Training for Peak Performers
Excel 2010 Training - Atlanta, GADate: Thu Nov 13 2014 – Thu Nov 13 2014
Time: 8:30 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excelallday.htm
Please bring your laptop (or let us know if we need to provide one).

 

 

Excel Pivot Tables Training – Atlanta
Excel 2010 Training - Atlanta, GADate: Fri Nov 14 2014 – Fri Nov 14 2014
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 – ONLINE (Evenings)
Access 2013 Training - Atlanta, GA Date: Mon Nov 17 2014 – Mon Nov 24 2014
Time: 6:00 pm – 10:00 pm
Place: .online (6 Evenings)
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

 

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Nov 17 2014 – Thu Nov 20 2014
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 Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class
Date: Mon Nov 17 2014 – Tue Nov 18 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm
Please bring your laptop (or let us know if we need to provide one).
Access Database 2010 Intermediate (Atlanta, GA)
Date: Wed Nov 19 2014 – Wed Nov 19 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Access 2010 Advanced (Atlanta, GA) 1 Day Training
Date: Thu Nov 20 2014 – Thu Nov 20 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

 

 

MS Project 2010 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Thu Nov 20 2014 – Thu Nov 20 2014
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).
MS Project 2010 Advanced Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Fri Nov 21 2014 – Fri Nov 21 2014
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).
MS Project 2013 Training – Atlanta
project training atlanta gaDate: Thu Nov 20 2014 – Fri Nov 21 2014
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 Macros & VBA (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Fri Nov 21 2014 – Fri Nov 21 2014
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 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Mon Nov 24 2014 – Wed Nov 26 2014
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).

 

 

PowerPoint 2010 Comprehensive Training – Certification Prep
Date: Mon Nov 24 2014 – Tue Nov 25 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).
Intro to Windows 8 Training – ONLINE
windows 8 trainingDate: Sat Nov 29 2014 – Sat Nov 29 2014
Time: 9:00 am – 5:00 pm
Place: .Online
For Info: http://www.probiztechnology.com/windows8-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

 

About Us

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, Word, Outlook and Publisher.

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

Ask Jackie: Disappearing Pivot Table Formats

Untitled Document

Ask Jackie: How do I preserve currency formatting in my pivot table?

Question:

I set the format of the numbers in my pivot table to currency. When I rearrange my pivot table, however, the formatting disappears and I have to reapply it. Is there any way to prevent this from happening?

Short Answer:

Yes, there is. Please note, however, that the steps I show won’t work if you use the Clear All command to clear your pivot table. In order to preserve your currency format, you must do two things:

1. Set your options to preserve pivot table formatting.

2. Select your entire pivot table before applying the currency format.

Detailed Answer:

Here are the step by step instructions.

Step 1 – Preserve Pivot Table Formatting.

Click anywhere in the pivot table.

Click the Options tab.

In the Pivot Table group, Click the drop down list next to Options. Click Options again.

When the dialog box pops up, click the Layout & Format tab. Put a check mark next  to Preserve cell formatting on update.

Pivot Table Options - Layout & Format

Click OK.

Step 2 – Select the Entire Pivot Table.

Click within the pivot table.

Click the Options tab.

Within the Actions group, click the Select drop down list, then Entire Pivot Table (Shortcut: CTRL SHIFT *).

Select Excel pivot tables

 

Step 3 – Apply the Currency Format.

Click within the pivot table.

Type CTRL 1 to open the format number dialog box.

Select the currency format.

Step 4 – Test Your Results.

Re-arrange your pivot table and make sure that the currency formatting remains. Remember: if you use the Clear All command, your currency formatting will be cleared also.

 

Did you find this Excel Pivot Table tip useful? If so, won’t you share your comments?

Want to learn pivot tables the easy, painless way? Our Painless Pivot Tables course might be right for you. It’s offered in Atlanta, online, or at your site.

 

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, Word, Outlook and Publisher.

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

 

 

Project, Access & Excel Training – Atlanta, GA & Online – October 2014

Untitled Document

Microsoft Training AtlantaAccess, Project, Excel, SEO, WordPress Training – Atlanta, GA

Schedule of October 2014 Courses

NEW! MS Office 2013 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 2014 Courses

Access 2013 Training – Online (Evenings)
Access 2013 Training - Atlanta, GADate: Mon Oct 06 2014 – Mon Oct 13 2014
Time: 6:00 pm – 10:00 pm
Place: .online (6 Evenings)
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

 

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Oct 06 2014 – Thu Oct 09 2014
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 Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class
Date: Mon Oct 06 2014 – Tue Oct 07 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm
Please bring your laptop (or let us know if we need to provide one).

Access Database 2010 Intermediate (Atlanta, GA)
Date: Wed Oct 08 2014 – Wed Oct 08 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Access 2010 Advanced (Atlanta, GA) 1 Day Training
Date: Thu Oct 09 2014 – Thu Oct 09 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

Intro to Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Sat Oct 11 2014 – Sat Oct 11 2014
Time: 9:00 am – 1:30 pm
Place: .ONLINE
For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm
Please bring your laptop (or let us know if we need to provide one).

 

Excel 2010 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Mon Oct 13 2014 – Wed Oct 15 2014
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).

 

 

 

Intro to Excel 2013 – Atlanta, GA
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Oct 13 2014 – Mon Oct 13 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/excel2013basictrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 
Excel 2013 Comprehensive Course (3 Days) – Atlanta, GA
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Oct 13 2014 – Wed Oct 15 2014
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).

 

 

 

PowerPoint 2013 Comprehensive Training – Certification Prep
PowerPoint 2013 Training - Atlanta, GADate: Mon Oct 13 2014 – Tue Oct 14 2014
Time: 9:00 am – 5:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

 

WordPress Essential Training – Atlanta, GA (1-Day Course)
Wordpress Training in Atlanta, GADate: Mon Oct 13 2014 – Mon Oct 13 2014
Time: 9:00 am – 6:00 pm
Place: .1100 Peachtree Street Suite 200 Atlanta, GA 30309
For Info: http://www.probiztechnology.com/wordpresstrainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

MS Project 2013 Training – ONLINE (Evenings)
project training atlanta gaDate: Tue Oct 14 2014 – Fri Oct 17 2014
Time: 6:00 pm – 10:00 pm
Place: .online
For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm
Please bring your laptop.

 

 

MS Project 2013 Training (Days)- Atlanta
project training atlanta ga

Date: Thu Oct 16 2014 – Fri Oct 17 2014
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).

 

 

Intro to Windows 8 Training – ONLINE
windows 8 trainingDate: Sat Oct 18 2014 – Sat Oct 18 2014
Time: 9:00 am – 5:00 pm
Place: . ONLINE
For Info: http://www.probiztechnology.com/windows8-training-atlanta.htm
Please bring your laptop.

 

Access 2013 Comprehensive Training – Atlanta – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Oct 20 2014 – Thu Oct 23 2014
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 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Mon Oct 27 2014 – Mon Oct 27 2014
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).

 

 

MS Project 2010 Advanced Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Tue Oct 28 2014 – Tue Oct 28 2014
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 Macros & VBA (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Wed Oct 29 2014 – Wed Oct 29 2014
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 Pivot Tables Training – Atlanta
Date: Fri Oct 31 2014 – Fri Oct 31 2014
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).

 

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 «