May 2014 – Access, Project, Excel, SEO Training in Atlanta, GA

Untitled Document

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

Schedule of May 2014 Courses

NEW! MS Office 2013 Courses

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

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

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

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

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

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

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

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

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

 

Computer Training Atlanta

Schedule of May 2014 Courses

 

Fundamentals of Quickbooks
Quickbooks Training in Atlanta, GADate(s): Saturday & Sunday, April 26 & 27, 2014
Time(s): 8:30 am – 5:00 pm
# Hours: 16 # Session(s): 2
Fees: $399
Place: 4388 Lawrenceville Highway, Tucker, GA 30084
For Info or Registration: http://www.QuickbooksTrainingAtlanta.com
Computer Provided.

Intro to Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Fri May 02 2014 – Fri May 02 2014
Time: 9:00 am – 1:30 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm
Please bring your laptop (or let us know if we need to provide one).
Access 2013 Intensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon May 05 2014 – Thu May 08 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

PowerPoint 2013 Comprehensive Training – Certification Prep
Date: Mon May 05 2014 – Tue May 06 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2013 Comprehensive Course – MCAS Certification Prep
Date: Mon May 12 2014 – Wed May 14 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Basic Training – Atlanta
MS Project 2010 Training - Atlanta, GADate: Thu May 15 2014 – Thu May 15 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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
Date: Fri May 16 2014 – Fri May 16 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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).

WordPress Essential Training – Atlanta, GA (1-Day Course)
Wordpress Training in Atlanta, GADate: Sat May 17 2014 – Sat May 17 2014
Time: 9:00 am – 6:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/wordpresstrainingatlanta.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 May 19 2014 – Thu May 22 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 May 19 2014 – Tue May 20 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 May 21 2014 – Wed May 21 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 May 22 2014 – Thu May 22 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Comprehensive Course – MCAS Certification Prep
Date: Mon May 19 2014 – Wed May 21 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel Pivot Tables Training – Atlanta
Date: Fri May 23 2014 – Fri May 23 2014
Time: 9:00 am – 1:30 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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).

Outlook 2013 Comprehensive Training – Certification Prep
Date: Tue May 27 2014 – Thu May 29 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/outlook2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Excel Macros & VBA (Visual Basic for Applications)
Date: Fri May 30 2014 – Fri May 30 2014
Time: 9:00 am- 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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

Excel Tip: Summarize Multiple Worksheets Quickly with 3D Formulas

Untitled Document

by Jackie Kiadii – Atlanta-based Excel Trainer

Imagine this. You have a workbook that has sales figures for your company’s 50 locations. Each location has its own worksheet, and you’d like to summarize the information onto one worksheet. You shudder at the thought of having to create a formula using 50+ signs or an Excel Macro to accomplish the task.

Summarize worksheets easily with 3d formulas

 

Looking for an almost instant way to summarize a workbook that has multiple sheets? Well, if all of the sheets you are trying to summarize have identical layouts, I have a solution for you – Excel’s 3D formulas.

Granted, 3D formulas take a little getting used to and you have to set up your workbook properly. I have created instructions that simplify the process and trust me, once you’ve created a couple of 3D formulas they’ll be a snap.

Benefits of 3D Formulas

3D Formulas instantly summarize multiple worksheets.

Whether your workbook has 5 sheets or 75, (1) the steps are the same and (2) they take the same amount of time to set up.

3D formulas work with a variety of functions.

Although these instructions use the SUM function, you can also use COUNT, AVERAGE, MIN, MAX and a variety of functions in 3D formulas.

3D Formula Workbook Setup

In order for 3D formulas to work, your workbook must be set up properly.

1. The worksheets you’re summarizing must have identical layouts. If the sales figures for January are in cell B1 in one sheet, for example, they should be in cell B1 for all.

2. Your summary worksheet must be before the first sheet you want to summarize or after the last one.

Step-by-Step Instructions: Creating a 3D Formula

  1. Click the cell in your summary sheet where you want to place your results.
  2. Type the equal sign, the name of the function, and the open parenthesis symbol.For example, =SUM(.
  3. Click the name of the 1st worksheet you want to summarize (by clicking the worksheet’s tab).Excel 3d formula instructions - click 1st tab
  4. Hold down the SHIFT key.
  5. Click the name of the last worksheet you want to summarize (by clicking the worksheet’s tab).Excel 3d formula instructions - click last tab.
  6. Release the SHIFT key.
  7. Click the cell you want to summarize. For example, cell B2.
  8. Click the ENTER key.  Hitting the enter key will take you to your summary sheet, where your 3D formula is calculated.Sample Excel 3d formula

 

This formula shown above simply adds the values in cell B2 in all the January and December sheets as well as all of the sheets between them. As I mentioned earlier, you can use other functions (AVERAGE, MIN, MAX, etc.) within 3D formulas.

 

Ready to try 3D formulas?

Try the 3D formula and let me know how it works – share your comments below.

 

About the Author

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Painless Pivot Tables ™, and Jump Start Excel Macros/VBA™, and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced,

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

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

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

Project, Access, Excel, VBA, SEO Training in Atlanta, GA | April 2014

Untitled Document

Access, Project, Excel, SEO Training – Atlanta, GA

NEW! MS Office 2013 Courses

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

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

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

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

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

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

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

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

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

Access 2010 Comprehensive Training – MCAS Certification Prep
Date: Mon Mar 31 2014 – Thu Apr 03 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 31 2014 – Tue Apr 01 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 02 2014 – Wed Apr 02 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 03 2014 – Thu Apr 03 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm
Please bring your laptop (or let us know if we need to provide one).

PowerPoint 2010 Comprehensive Training – Certification Prep
Date: Tue Apr 01 2014 – Wed Apr 02 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/powerpoint2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

PowerPoint 2013 Comprehensive Training – Certification Prep
Date: Thu Apr 03 2014 – Fri Apr 04 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Intro to Small Business SEO (Search Engine Optimization)
Date: Fri Apr 04 2014 – Fri Mar 07 2014
Time: 9:00 am – 1:30 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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
Date: Mon Apr 07 2014 – Wed Apr 09 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

Word 2013 Comprehensive Training – Certification Prep
Date: Mon Apr 07 2014 – Wed Apr 09 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/word2013trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2013 Training – Atlanta
Date: Thu Apr 10 2014 – Fri Apr 11 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 for Peak Performers
Date: Fri Apr 11 2014 – Fri Apr 11 2014
Time: 8:30 am – 5:00 pm
Place: .Lavista & I285 (Location sent when registration confirmed)
For Info: http://www.probiztechnology.com/excelallday.htm
Please bring your laptop (or let us know if we need to provide one).

MS Project 2010 Basic Training – Atlanta
Date: Wed Apr 16 2014 – Wed Apr 16 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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
Date: Thu Apr 17 2014 – Thu Apr 17 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 2007 Macros & VBA (Visual Basic for Applications)
Date: Tue Apr 22 2014 – Tue Apr 22 2014
Time: 9:00 am- 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/excel-2007-vba-macros-training.htm
Please bring your laptop (or let us know if we need to provide one).

Excel 2010 Macros & VBA (Visual Basic for Applications)
Date: Tue Apr 22 2014 – Tue Apr 22 2014
Time: 9:00 am- 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 Apr 25 2014 – Fri Apr 25 2014
Time: 9:00 am – 1:30 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
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 Apr 28 2014 – Wed Apr 30 2014
Time: 9:00 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm
Please bring your laptop (or let us know if we need to provide one).

 

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

Computer Training Atlanta - Schedule of Classes

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

 

 

Excel VBA Tip: How to Automatically Open a Workbook When You Launch Excel

Untitled Document

Excel 2013 and 2010.

Is there a workbook you use frequently? Would you like to open it automatically when you launch Excel? The process is simple – place it in your XLSTART folder.

excel vba tip open files automatically in excel

What is the XLSTART folder?

The XLSTART folder is created when you install Excel. XLSTART not only houses the workbook template, Book.xltx, but any workbook you place in this folder will automatically open each time you launch Excel.

Here’s the rub.

You may not know where the XLSTART folder is, since its location depends on your version of Excel and your operating system.

Here’s an easy way to find it. Yes, Visual Basic for Applications (VBA) is involved, but it’s easy!

Step 1 – Launch a New File

If you already have the file you want to save to your XLSTART folder open, create a new file. (Shortcut Key: CTRL N). For this exercise, it’s best to start with a blank canvas.

Step 2 – Open the Visual Basic Editor (VBE)

Use the shortcut key ALT F11.

Step 3 – Open the Immediate Window

What is the immediate window? The immediate window is a special area used for debugging code. You can also type snippets of code in the immediate window and immediately view your results.

Use the shortcut key CTRL G, which opens the immediate window towards the bottom of your screen.

Step 4 – Type This Code in the Immediate Window

Type ?application.StartupPath in the immediate window and hit the Enter key.

The location of your immediate window shows up on your screen. Copy it to your clipboard (CTRL C).

Step 5 – Save the File.

Switch to the workbook you want to save to your XLSTART folder (Shortcut: CTRL TAB). Click File SaveAs (Shortcut: F12).  Paste (CTRL V) the location of your startup folder next to File Name, and press the Enter key. This will point you to the XLSTART folder. Save your file.

 

About the Author

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Painless Pivot Tables ™, and Jump Start Excel Macros/VBA™, and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced,

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

Recap of #SoCon14 Social Media Conference by @learntech

Untitled Document

On Saturday, February 22, 2014 the Center for Sustainable Journalism at Kennesaw State University held the 4th SoCon “unconference” – the longest running Social Media conference in the Southeast.

This is my recap of the event.

humorous social media cartoon

Life Before Social Media – cartoon by John Atkinson @wronghands1

Who Attended SoCon14

I was surprised by the variety of people attending the conference.

  • Social media entrepreneurs,
  • Social media professionals employed by government agencies, corporations or non-profits,
  • Business owners looking to expand their social media knowledge,
  • Software developers,
  • Sales managers looking for ways to convince their teams to leverage social media,
  • University students.

What I Learned from SoCon14

Some conferences can be disappointing. Pitch fests thinly disguised as informational seminars or speakers who clearly have no hands-on experience implementing what they suggest.

Not the case with SoCon14. All of the content was valuable, but I will focus on one presentation. The first sentence Lisa Calhoun spoke immediately made me take notice. “Never check your intuition at the door,” she said, telling us to filter social media research through our expertise and common sense.

Her presentation on “Posting with a Purpose” covered how to build a sales pipeline through B2B social media. Her partner, Jean-Luc Vanhulst, discussed measuring the effectiveness of your social media activities.

7 Takeaways:

  1. Successful B2B Marketers rate blogging as the most effective social media tool.
  2. Effective B2B Marketers spend close to 40% on content marketing.
  3. In order to be effective in social media, you must have a way to “quickly and powerfully generate ongoing streams of content.”
  4. #1 predictor of social media success is using enough tools in concert – 15 seems to be the magic number. (I applied my own filter here. Most SMB simply do not have the resources to stay actively involved in more than 1 or 2 social media channels. I always recommend people focus on the 1 or 2 places where your best clients “hang out” and use syndication tools to supply content to the rest.)
  5. “Routine sets you free,” Jean Luc said, emphasizing that setting up systems and tools is key to winning with social media.
  6. Follow up by making a personal connection.
  7. “It’s not about the number of followers – it’s about what you do.”

I also learned from other attendees. Since I teach ways Search Engine Optimization (SEO) can be used to make Social Media more effective in less time, I was particularly interested in learning how people are using search and SEO. One of the things I learned is some buyers (especially younger ones) use Pinterest (not Google or Bing) as a search engine when they are looking for products – so if you sell products, make sure you are leveraging Pinterest.

Not Your Father’s Cafeteria

The last time I was in a cafeteria, it was a frightful place with “food” that had probably been around for 20 years and could last for 100 more.

Not so with the cafeteria at Kennesaw State University, where we had lunch. In addition to a wide variety of vegetables (raw, steamed, grilled), you could get coffee (cappuccino, macchiato) and braised lamb shanks. Yes, you read it correctly – braised lamb shanks!

This new world of food is amazing! How can I purchase a meal plan?

Suggestions for Improvement?

None come to mind, but there is one thing I would suggest to future attendees. Wear comfortable shoes. As I hobbled from the cafeteria to the conference, I bitterly regretted my decision to eschew comfort for fashion.

Was it worth it?

Absolutely! Most of the people I met had attended for several years and were planning on attending next year’s SoCon. If you are, save the date for SoCon15 – February 21, 2015. Tickets usually go on sale in November, and the conference will sell out (again).

 

About Jackie Kiadii

An SEO trainer, speaker and practitioner since 2002, Jackie Kiadii is the creator of the Direct Response SEO™ System, which helps businesses attract their ideal clients online and move them from Search to Client ASAP™. In one of her training programs, Social SEO, business owners learn how to leverage SEO to make their Social Media efforts effective in record time.

 

PowerPoint Tip – Make Organizing Graphics Easier by @learntech

Untitled Document

Do you find yourself struggling with ordering objects (text boxes, pictures, etc.) on your PowerPoint slide?

Do overlapping objects make it difficult to select the item you need?

Tired of having to struggle with multiple Send Backward and Bring Forward commands?

Well, fortunately for you, PowerPoint’s Selection Pane makes the entire process easy. The pane lists all of the objects on a slide so that you can easily re-order, rename, show and hide individual or multiple objects.

If you haven’t heard of the selection pane before, you are not alone. Hidden beneath a couple of layers on the Home tab and not mentioned in most standard training manuals, the selection pane is a hidden jewel you’ll find yourself using over and over again.

For example, here’s a slide in my Direct Response SEO™ course.

PowerPoint Training Atlanta - PowerPoint Slide

Here’s the Selection Pane for the slide.

picture of PowerPoint's Selection Pane by PowerPoint Training Atlanta

How to Launch PowerPoint’s Selection Pane

 

Click the Home tab.

In the Editing group, click Select, then Selection Pane.

The selection pane will show up on the right side of your screen.

To select an item on the slide, click the item on the selection pane.

To make an object visible or invisible, click the eye icon.

To reorder objects, click the arrows at the bottom of the selection pane.

To rename an object, double-click it on the selection pane and type the new name. This is especially helpful when you have many objects – assigning meaningful names will make your life easier.

 

About the Author – Atlanta-Based PowerPoint Trainer Jackie Kiadii

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She has provided PowerPoint training for business professionals since 2001. Need more help with PowerPoint? In addition to classes in versions 2007, 2010 and 2013, we now offer Customized PowerPoint Training for Sales Professionals.

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

Training guaranteed to help you maximize your productivity with MS PowerPoint.

Ask Jackie: How do I copy and paste a cell’s comments? Excel Tip by @learntech

Untitled Document

by Jackie Kiadii – Atlanta-based Excel Trainer

Question:

This question came up in a recent Excel for Peak Performers course.

I have a comment in one cell that applies to many cells. I really do not want to type the same comment 50 or so times. Since the data in each cell is different, a simple copy and paste won’t work. Any suggestions?

Answer:

Yes, there is a way to copy and paste just a comment.  The process, while undocumented, is quick and easy.

1 – Copy the cell that contains your comment.

2 – Select the cells you want to paste the comment into. Remember you can use your CTRL key to select non-continguous cells.

3 – Right-click the cells and Left-click Paste Special.

Excel Tutorial - Paste Special

 

4 - Select Comments, then click OK.

Excel Paste Special Comments

 

As promised, it is very easy to copy and paste comments.

I’m always thankful for my students’ questions. Not only am I thrilled to help them solve their work problems, but they supply great fodder for this blog!

About the Author

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Painless Pivot Tables ™, and Jump Start Excel Macros/VBA™, and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced,

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

 

 

How to Get your Boss to Say Yes to Training by @learntech

Untitled Document

Savvy organizations understand the importance of employee training, but it’s a trite, yet often true saying – “when there’s a budget crunch, training is the first to go.”

Knowledge is power - computer training atlanta

So, you’ve found a course you would like to attend and you’re not sure your boss will pay for it.  Or worse even, your boss is leaning towards approving a cheap, ineffective course that will not solve your team’s problems.

How do you get your boss to approve much needed training, or provide quality, hands-on training in lieu of a cheap seminar?

Here is our guide to getting the boss to not only says yes to training, but yes to the quality training your team needs.

Frame the request in a language your boss understands.

Like all of us, bosses hear one radio station – WIIFM (What’s in it for me?).

There are 2 songs top-level managers want to hear on WIIFM:

  • Grow my Organization
  • Boost my Bottom Line

If you can demonstrate the value of the training in these terms, you improve your chances of getting a “yes.” So instead of asking for “training,” frame your request in terms of the money your organization will save by improving the skills of the team.

My students, for example, report recouping an average of two hours a week (102 hours a year) on what they learn in my software classes. Assuming that each team member earns $35,000 a year, with a company cost of salary and benefits of $51,775 (according to salary.com), the 102 hours saved would be worth $2,536.96 a person, or $20,311.68 for a team of 8 people.

So, how much is your boss willing to pay to recoup the $20,311.68 she is losing each year?

Make sure the training you recommend is of the highest quality.

There is a caveat in taking this approach. Be aware that not all training achieves the same results.

Before hiring a company, you must investigate trainer qualifications and testimonials.

You must determine the following:

  • Are the trainers subject matter experts?
  • Do they have a talent for explaining complex topics in terms students understand?
  • Do they care about whether or not the students learn?
  • Are trainers able to think on their feet and adapt the course to changing environments?

These are all important factors in ensuring the training actually pays off.

What if the boss says no?

Whether your boss doesn’t care about the bottom line, or if there simply isn’t any funding in the budget for training, your boss may still reject your training request.  This doesn’t mean you should give up on training that will improve your skills and make you a more valuable asset.

Pay for it yourself.

Do not lose sight of these facts:

  1. The right training is an investment that yields immediate dividends.
  2. No one is responsible for your career growth but you.

The biggest mistake we could ever make in our lives is to think we work for anybody but ourselves.

Brian Tracy

Paying for my own training was a strategy I used when I worked in Corporate America.

I asked the following questions:

  1. Will they pay for training?  If the answer was “No,” I moved to the next question.
  2. Will they give me time off and pay for travel (if necessary)? If the answer to this question was “No,” I simply paid for the training myself and used my vacation days to attend training.

Yes, there were times when the investment entered into the thousands of dollars (and my co-workers looked at me as if I had taken leave of my senses), but my willingness to invest in myself always paid off.

 About the Author

Since 2001, Jackie Kiadii has taught employees of some of the best known companies in the world how to use Microsoft Office software (Access, Excel, Project, etc.) to increase their productivity.  Her Atlanta-based IT Services firm provides Software Training and Consulting services, and Search Engine Optimization. She has provided software training for employees of Emory University, Coca-Cola Company, Novelis, The EPA and more. Click here for a schedule of upcoming software classes in Atlanta, GA.

 

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

MS Project Tip – 8 Questions to Ask When Creating Task Relationships by @learntech

Untitled Document

Hands-down the MS Project feature my students use most often is the ability to create and link tasks. While relatively straightforward, creating a project schedule is more than simply linking a list of tasks.

MS Project Task Relationships

If your goal is to create a project schedule that is efficient and doable, ask yourself these questions as you establish relationships between tasks.

  1. Will any tasks take a fixed amount of time? There are some tasks that are scheduled to take the same amount of time no matter how many people are involved. An easy example of a fixed duration task is a weekly status meeting.
  2. Can any of your related tasks begin concurrently?
  3. Do you have any tasks that can start before the previous task ends?
  4. Do you have to wait for a period of time after a task ends before the next task begins? A simple example is painting a room. Typically, you have to give paint the time to dry before you can do any additional work on the walls.
  5. Do you have any recurring tasks?
  6. Must any tasks absolutely start or end by a date – or can’t start or end before a particular date?
  7. Do you have any tasks that cannot finish or start unless another one finishes or starts?
  8. Can any tasks take place after hours? If a task can occur outside of working hours you may be able to shorten your project’s time frame.

 

Want More? MS Project 2010 & 2013 Training in Atlanta, GA

MS Project 2007, 2010, 2013 Training - Atlanta & OnlineThe next MS Project class is happening soon. 2 days of MS Project 2010 training by expert instructors in a small-class setting so that you get the attention you require. Practical, undocumented tips & tricks. Click here for registration and details

.Prefer group training at your site? Call 404.297.6700. Our courses are affordable and customized to your needs. Available for groups of 4 or more students.

Free! – The Best MS Project Keyboard Shortcuts

Contact us for your free list of handy MS Project keyboard shortcuts.

About the Author of this  MS Project 2010 Tutorial.

Since 2001, Jackie Kiadii has taught employees of some of the largest employers in the Southeastern United States how to use MS Project. For more information, visit ProjectTrainingAtlanta.com.

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

Access, Excel, Project, SEO Training | Atlanta, GA | Feb 2014

Untitled Document

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

Schedule of February 2014 Courses

NEW! MS Office 2013 Courses

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

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

Computer Training Atlanta - Schedule of Classes

Want us to bring training to you?

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

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

Microsoft Training Atlanta by Subject Matter Experts

What Students Say:

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

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

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

 

Computer Training Atlanta

Schedule of February 2014 Courses

Excel for Peak Performers

Date: Sat Feb 01 2014 – Sat Feb 01 2014

Time: 8:30 am – 5:00 pm

Place: .Lavista & I285 (Location sent when registration confirmed)

For Info: http://www.probiztechnology.com/excelallday.htm

Please bring your laptop.

Excel 2013 Comprehensive Course – MCAS Certification Prep

Date: Mon Feb 03 2014 – Wed Feb 05 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/excel2013trainingatlanta.htm

Please bring your laptop.

PowerPoint 2010 Comprehensive Training – Certification Prep

Date: Mon Feb 03 2014 – Tue Feb 04 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/powerpoint2010trainingatlanta.htm

Please bring your laptop.

Outlook 2013 Comprehensive Training – Certification Prep

Date: Thu Feb 06 2014 – Fri Feb 07 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/outlook2013trainingatlanta.htm

Please bring your laptop.

PowerPoint 2013 Comprehensive Training – Certification Prep

Date: Thu Feb 06 2014 – Fri Feb 07 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/powerpoint2013trainingatlanta.htm

Please bring your laptop.

Intro to Small Business SEO (Search Engine Optimization)

Date: Fri Feb 07 2014 – Fri Feb 07 2014

Time: 9:00 am – 1:30 pm

Place: .Online

For Info: http://www.probiztechnology.com/c_seo-small-businesses.htm

Please bring your laptop.

Access 2013 Comprehensive Training – MCAS Certification Prep

Date: Mon Feb 10 2014 – Thu Feb 13 2014

Attend Basic (2 Days) Intermediate (1 Day) Advanced (1 Day) or all 4 days.

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/access2013trainingatlanta.htm

Please bring your laptop.

Excel 2010 Pivot Tables Training – Atlanta

Date: Fri Feb 14 2014 – Fri Feb 14 2014

Time: 9:00 am – 1:30 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/c_excel-pivot-tables.htm

Please bring your laptop.

Access 2010 Comprehensive Training – MCAS Certification Prep

Date: Mon Feb 17 2014 – Thu Feb 20 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/access2010trainingatlanta.htm

Please bring your laptop.

 

Access Database 2010 Basics (Atlanta, GA) In-Depth, 2-Day Class

Date: Mon Feb 17 2014 – Tue Feb 18 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/access-essentials-2daytraining.htm

Please bring your laptop.

Access Database 2010 Intermediate (Atlanta, GA)

Date: Wed Feb 19 2014 – Wed Feb 19 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/access-int-trainingatlanta.htm

Please bring your laptop.

Access 2010 Advanced (Atlanta, GA) 1 Day Training

Date: Thu Feb 20 2014 – Thu Feb 20 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/accesstrainingatlanta-2010advanced.htm

Please bring your laptop.

 

Excel 2010 Comprehensive Course – MCAS Certification Prep

Date: Mon Feb 24 2014 – Wed Feb 26 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/excel2010trainingatlanta.htm

Please bring your laptop.

Word 2013 Comprehensive Training – Certification Prep

Date: Mon Feb 24 2014 – Wed Feb 26 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/word2013trainingatlanta.htm

Please bring your laptop.

MS Project 2010 Basic Training – Atlanta

Date: Thu Feb 27 2014 – Thu Feb 27 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/msproject-basic-atlanta-v2010.htm

Please bring your laptop.

MS Project 2013 Training – Atlanta

Date: Thu Feb 27 2014 – Fri Feb 28 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/project-training-atlanta-v2013.htm

Please bring your laptop.

Excel 2007 Macros & VBA (Visual Basic for Applications)

Date: Fri Feb 28 2014 – Fri Feb 28 2014

Time: 9:00 am- 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/excel-2007-vba-macros-training.htm

Please bring your laptop.

Excel 2010 Macros & VBA (Visual Basic for Applications)

Date: Fri Feb 28 2014 – Fri Feb 28 2014

Time: 9:00 am- 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/excel-2010-vba-macros-training.htm

Please bring your laptop.

MS Project 2010 Advanced Training – Atlanta

Date: Fri Feb 28 2014 – Fri Feb 28 2014

Time: 9:00 am – 5:00 pm

Place: .4388 Lawrenceville Highway, Tucker, GA 30084

For Info: http://www.probiztechnology.com/msproject-advanced-atlanta-v2010.htm

Please bring your laptop.

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. Even at the regular prices, most of our 3-day courses are approximately $200 less than other courses.
  6. The MS Office training manuals are approved as preparation materials for  the Microsoft Certified Application Specialist exams.
  7. Flexibility. Can’t make it to our location? No worries. Our courses are now conveniently offered online.  This means you can attend, no matter where you are, as long as you have high speed Internet access.

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

Computer Training Atlanta - Schedule of Classes

 

Older posts «