Excel VBA, Access, SEO, Project Training – Atlanta, GA (August 2015)

Untitled Document

Microsoft Training Atlanta

Schedule of August 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 in Atlanta, GA

Schedule of August 2015 Courses

 

Excel 2010 Comprehensive Course – MCAS Certification Prep
Excel 2010 Training - Atlanta, GADate: Mon Jul 27 2015 – Wed Jul 29 2015
Time: 9:00 am – 5:00 pm
Place: 3355 Lenox Road, Atlanta, GA 30326
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: Mon Aug 03 2015 – Mon Aug 03 2015
Time: 9:00 am – 5:00 pm
Place: 3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Save $100 when you register for Basic AND Advanced.
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 Aug 04 2015 – Tue Aug 04 2015
Time: 9:00 am – 5:00 pm
Place:3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm

Save $100 when you register for Basic AND Advanced.
Please bring your laptop (or let us know if we need to provide one).

 

PowerPoint 2010 Comprehensive Training – Certification Prep
Date: Tue Aug 04 2015 – Wed Aug 05 2015
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 Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Fri Aug 07 2015 – Fri Aug 07 2015
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).

 

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Aug 10 2015 – Thu Aug 13 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 Aug 10 2015 – Tue Aug 11 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 Aug 12 2015 – Wed Aug 12 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 Aug 13 2015 – Thu Aug 13 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 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Wed Aug 19 2015 – Fri Aug 21 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: Mon Aug 24 2015 – Tue Aug 25 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 Macros & VBA – 2 Days (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Wed Aug 26 2015 – Thu Aug 27 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 Pivot Tables Training – Atlanta
Date: Fri Aug 28 2015 – Fri Aug 28 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).

 

 

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

Excel, VBA, Access, Project Training – Atlanta, GA – July & August

Untitled Document

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

Schedule of July & August 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 July & August 2015 Courses

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Jul 06 2015 – Thu Jul 09 2015
Time: 9:00 am – 5:00 pm
Place: 3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
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 Jul 06 2015 – Tue Jul 07 2015
Time: 9:00 am – 5:00 pm
Place:3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
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 Jul 08 2015 – Wed Jul 08 2015
Time: 9:00 am – 5:00 pm
Place:3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
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 Jul 09 2015 – Thu Jul 09 2015
Time: 9:00 am – 5:00 pm
Place:3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
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: Fri Jul 10 2015
Time: 9:00 am – 1:30 pm
Place: Online
For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm

 

 

Excel Macros & VBA – (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Mon Jul 13 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: Mon Jul 27 2015 – Wed Jul 29 2015
Time: 9:00 am – 5:00 pm
Place: 3355 Lenox Road, Atlanta, GA 30326
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: Mon Aug 03 2015 – Mon Aug 03 2015
Time: 9:00 am – 5:00 pm
Place: 3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm
Save $100 when you register for Basic AND Advanced.
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 Aug 04 2015 – Tue Aug 04 2015
Time: 9:00 am – 5:00 pm
Place:3355 Lenox Road (across from Lenox Mall), Suite 750, Atlanta, GA 30326
For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm

Save $100 when you register for Basic AND Advanced.
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 Aug 07 2015 – Fri Aug 07 2015
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 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Wed Aug 19 2015 – Fri Aug 21 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: Mon Aug 24 2015 – Tue Aug 25 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 Macros & VBA – 2 Days (Visual Basic for Applications)
Excel VBA Training - Atlanta, GADate: Wed Aug 26 2015 – Thu Aug 27 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 Pivot Tables Training – Atlanta
Date: Fri Aug 28 2015 – Fri Aug 28 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).

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

 

Access, Excel, Project, VBA, Powerpoint Training – Atlanta, GA – April 2015

Untitled Document

Microsoft Training AtlantaAccess, Excel VBA, Project Training – Atlanta, GA

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

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

Excel 2013 Pivot Tables Training – Atlanta
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Fri Apr 03 2015 – Fri Apr 03 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).
Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Apr 06 2015 – Thu Apr 09 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 Apr 06 2015 – Tue Apr 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-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 Apr 08 2015 – Wed Apr 08 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 Apr 09 2015 – Thu Apr 09 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 2013 Comprehensive Course – MCAS Certification Prep
Excel 2013 Training by Subject Matter Experts - Atlanta, GADate: Mon Apr 13 2015 – Wed Apr 15 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 2010 Pivot Tables Training – Atlanta
Excel 2010 Training - Atlanta, GADate: Wed Apr 22 2015 – Wed Apr 22 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: Fri Apr 24 2015 – Fri Apr 24 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: Mon Apr 27 2015 – Wed Apr 29 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 2013 Training – Atlanta
project training atlanta gaDate: Thu Apr 30 2015 – Fri May 01 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).

 

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

 

Access Union Queries Made Simple

Untitled Document

Imagine this: you have three tables that contain contact information such as addresses and phone numbers. One table has prospects, one has customers, and one has vendors. You’d like to combine the contact lists into one, but the tables aren’t related. This isn’t something that can be done easily unless you know about the union query.

access-multiple-tables-in-query

 

According to Microsoft, “A union query combines the result sets of several similar select queries.” The beauty of a union query is that you do not need to have relationships between the tables in order to use it.

In this article, you’ll learn how to create union queries easily and simplify the process with the clipboard.

Before you begin, here are the rules.

Union Query Rule #1

Union queries must be written directly in SQL; they cannot be created using the design grid. If you are not familiar with SQL, no worries. I will show you how to create union queries without having to know SQL. All you have to know is how to type one word, UNION.

Union Query Rule #2

Union queries must have the same number of output fields from each table. You cannot use a union query, for example, if you are pulling the last name, first name and phone number from Table1 and the last name, first name, phone number and address from Table2.

Union Query Rule #3

Output fields must be in the same order. If the first field you pull from the Table1 is last name, the first field from all subsequent tables must also be the last name field.

Union Query Rule #4

Output fields must be compatible data types. Access doesn’t care about the field names; it only checks for data types. If the first field from Table1 is a Date field, for example, the first field from Table2 cannot be text.  The first field  from Table1 can be named “Date” and the first field from Table2 can be named “DOB.” This is acceptable to Access as long as both fields have the same data type.

Creating an Access Union Query – Step-by-Step

The simplest way to create a union query without knowing SQL is to create separate queries to query each table in the query design, and copy and paste the SQL statements into one window.

Step 1 – Open the Clipboard.

Open the Clipboard. Click the Home tab on the ribbon, and click the dialog box launcher in the Clipboard group.

clipboard-launcher

The Clipboard will launch on the left-hand side of the screen. If you have anything in the clipboard, click the Clear All button.

Step 2 – Create the First Query

You will create the first query to hold your union query.

Create a new query. Click the Create tab, then click Query Design.

When the Show Table box pops up, click the Close button.

Switch to SQL view. Click on the Design tab. In the Results group, click the arrow under View and and select SQL.

Step 3 – Create A Query for the First Table

Click the Create tab, then Query Design.

When the Show Table dialog box pops up, double-click the name of the table and then click the Close button.

Add the fields to your query design, remembering the rules.

Switch to SQL view, and copy the code to the clipboard. Select the code by typing CTRL A. Copy the code by typing CTRL C.

access-union-query-customers

Step 4 – Create Queries for the Additional Tables

Go through the steps of creating queries for additional table(s) and copying the SQL statement(s) to your clipboard.

access-union-query-clipboard

 

Step 5 – Use the Clipboard to Combine Code

Create a brand new query in SQL view.

Make sure the Clipboard is visible.

Paste one query’s SQL statements into the blank SQL window by clicking the arrow next to the first query’s SQL statement in the Clipboard window.

Make sure your cursor is in SQL view. Hit the Backspace key to remove the semi-colon. Click the Enter key so that you are on a new line. Type the word UNION and hit Enter again.

Paste the second query’s statement into the SQL window. If this is your last query, keep the semi-colon and run the query to view your results. If this isn’t your last query, delete the semi-colon, add the word UNION and paste the next query.

After pasting your final query’s SQL statement, make sure you end it with the semi-colon.

access-union-query-combinedRun the query to view your results.

 

access-union-query-results

 

About the author of this Access Tip.

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

Older posts «