How to Use Excel’s MOD Function

In this article, you’ll learn how to use the Excel’s MOD function to find the remainder after division. The MOD function can be used in conditional formatting and data validation.

View full post

Pivot Table: How to Group Data by Number Ranges

Would you like to group your pivot table data by age range, price range, or any other number range? The simple process is explained in our blog post.

View full post

Excel Tip: How to Make Formulas “Invisible”

Excel Tip: The ability to make your formulas invisible is powerful, especially when you have complex functions. If users can’t see your functions, they can’t try to edit them.

View full post

Access AutoNumber: How to Default to 4 Digits

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.

View full post

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

Making the decision to switch from Excel Pivot Tables to Power Pivot? Explore the pros and cons of each option.

View full post

How to Use Excel’s MOD Function Pivot Table: How to Group Data by Number Ranges Excel Tip: How to Make Formulas “Invisible”Access AutoNumber: How to Default to 4 Digits Is It Time to Switch From Excel Pivot Tables to Power Pivot?

How to Use Excel’s MOD Function

Categories:

Excel Tips

by Jackie Kiadii

Untitled Document

The MOD function is one of those simple, often overlooked, highly valuable Excel functions.

If I had to pick a Swiss Army Knife of Excel functions, the MOD function would be in the running. Why? Because once you know it, you can find a number of ways to use it.

The MOD function returns the remainder after you divide a number by a divisor.

The syntax is as follows: MOD (Number, Divisor)

For example, MOD (5, 1) would return 0. MOD (5,2) would return 1. MOD (5.5, 1) would return .5.

So now that you know the MOD function, how would you use it?

In upcoming articles, I’ll share tutorials to leverage the power of MOD functions.

In the meantime, here are a few simple ideas. You can use the MOD function to conditionally format cells that meet a certain criteria or prevent your users from entering values that don’t meet the criteria you set. (tag posts for conditional formatting, and add)

Using the MOD function to test for integer values:

MOD (A1,1)=1 will return a TRUE if the number is an integer, and FALSE if it isn’t.

Using the MOD function to test for odd or even numbers:

MOD(A1,2)=0 will return TRUE if the number is an even number, and FALSE if it isn’t.

Do you have an Excel question?

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

About the Author

Jackie Kiadii, Certified MOS Excel Expert, 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.

Click to Grab Your Excel Ebook – Free!

Tags: excel mod function, excel remainder, mod function, Swiss Army Knife of Excel Functions

Leave comment

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

Categories:

Computer Training Atlanta

by Jackie Kiadii

Untitled Document

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.

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.

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 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).

MS 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).

MS 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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:

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.
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.
Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
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.
Affordable – a great value..
The MS Office training manuals are approved as preparation materials for the Microsoft Certified Application Specialist exams.
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.

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.

Tags: access 2010, access 2013, access 2016, access training atlanta, Advanced Excel Training Atlanta, computer training atlanta, excel 2010, excel 2013, excel 2016, excel pivot tables, Excel Pivot Tables Training Atlanta, excel training atlanta, Excel Vba Training Atlanta, ms project 2010, project 2013, project 2016, project training atlanta

Leave comment

Excel VBA, Access, Project Training – Atlanta, GA – October, 2016

Categories:

Computer Training Atlanta

by Jackie Kiadii

Untitled Document

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.

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.

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 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 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 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 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 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 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 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 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 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).

MS 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 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).

MS 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 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 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 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 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:

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.
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.
Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
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.
Affordable – a great value..
The MS Office training manuals are approved as preparation materials for the Microsoft Certified Application Specialist exams.
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.

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.

This post has no tag

Leave comment

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

Categories:

Computer Training Atlanta

by Jackie Kiadii

Untitled Document

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.

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.

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

MS 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 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).

MS 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:

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.
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.
Small Class size: This course is limited to 8 students, providing you the opportunity to get 1-on-1 assistance.
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.
Affordable – a great value..
The MS Office training manuals are approved as preparation materials for the Microsoft Certified Application Specialist exams.
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.

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.

Leave comment

Pivot Table: How to Group Data by Number Ranges

Categories:

Excel Tips

by Jackie Kiadii

Untitled Document

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.

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

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.

Here is the original result.

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