Excel VBA Tip: Change Visual Basic Editor’s (VBE) Default Font Size

Untitled Document

by Jackie Kiadii, Excel VBA Instructor

 

When I teach Excel Macros and Visual Basic for Applications (VBA) courses, one of the student complaints is how difficult the Visual Basic Editor (VBE) is to read. The default font of Courier 10 is not the easiest on the eyes. Fortunately, changing the font is really quick and easy.

 

Excel VBA Change Font Size

 

What is the Visual Basic Editor (VBE)?

 

The VBE is Excel’s code area. You can get to it by clicking the Developer tab, then Visual Basic in the Code group. A shortcut for accessing the VBE is ALT F11.

 

Changing the VBE’s Default Font

Switch to the VBE (ALT F11).

Click the Tools menu.

Click Options.

Click the Editor Format tab.

Change the font and size. To make it easier for students to see my screen, I usually use Verdana 14 pt.

 

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: Jump Start Excel Macros/VBA™, Painless Pivot Tables ™ and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced training.

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

Is Keyword Research Dead? Direct Response SEO™ Tip

Untitled Document

Over the past few months, I’ve been seeing this bold statement: Keyword Research is Dead.  But is it really?

 

Keyword Research Graphic | Direct Response SEO

What is Keyword Research?

 

Before I begin, perhaps you are wondering “What is Keyword Research?”

 

Here is how I define keyword research in my Direct Response SEO System™. Keyword research is the process of identifying the terms your ideal clients type into Google or other search engines when they are (a) actively seeking your services or (b) have a problem your services can solve. Let’s say you are an accountant who represents your clients at the Internal Revenue Service. A keyword phrase someone actively seeking your services might type is “IRS Representation Atlanta.” A keyword phrase someone with a problem you can solve might type is “How to respond to the IRS CP75D Notice.”

Why are so many “experts” saying keyword research is dead?

 

I understand the reasons for such a bold statement: it reflects (a) some changes Google has made to its Analytics tool and (b) “scare” marketing tactics designed to persuade prospects to invest in SEO services.

 

But – until the technology is created where your ideal prospects can peer into a device and have the device read their minds and accurately predict what they want, they are going to have to type or speak their queries, using keywords. Period.

Internet Marketing Echo Chamber

 

This Keyword Research is Dead canard is an example of what I call the Internet Marketing echo chamber. One or two top experts float an idea on their blogs and the rest of the community picks it up without applying any sort of common sense filter. It reminds me a top Atlanta Internet Marketing expert who was quoted 10 years ago as saying email marketing is dead. Fast forward to today, where email marketing is still 40 times more effective than Facebook and Twitter marketing combined.

 

So how do you avoid the Internet Marketing echo chamber? Use your own expertise when listening to Internet Marketing experts. Filter what you read using common sense and your knowledge of your customers’ behavior.

What Gets Sites to the Top of the Search Engines?

What gets you to the top of search engine results is the same today as it was 12 years ago: optimized, unique quality content that proves your website is the place to go for information on a particular topic. Period. Which is why blogging strategically on your own website is still the most effective way to attract Google, Bing, Yahoo and your ideal clients.

 

About the Author

Jackie Kiadii is the developer of the Direct Response SEO™ system, which is geared towards getting your ideal prospects from Search to Client ASAP™. She is also the developer of the Social SEO group coaching program™, where participants learn how SEO can help them expand the reach and effectiveness of their social media marketing efforts. For more information, call 770.498.7333 or visit DirectResponseSEO.com

MS Project Tip – How to Change Calendar View to 5 Days

Untitled Document

by Jackie Kiadii, Microsoft Project Trainer

With Microsoft Project’s calendar view, users can view their project schedule on a monthly, weekly or custom basis.

MS Project Calendar View - Project Training Atlanta

 

The monthly calendar view is set to a 7-day week by default. If you do not need to see the weekends and want to convert to a 5-day week, the process is very simple.

Right-click anywhere on the calendar and select Timescale.

When the timescale dialog box pops up, select 5 days in the display section, click OK and you’re done!

Project Calendar Timescale via ProjectTrainingAtlanta.comThe calendar is now in 5-day view.

MS Project Calendar 5 Day View

Free! – The Best MS Project Keyboard Shortcuts

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

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.

 

About the Author of this  MS Project 2010/2013 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

Excel, SEO, Project, Access Training – Atlanta, GA | June 2014

Untitled Document

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

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

 

Fundamentals of Quickbooks
Quickbooks Training in Atlanta, GADate(s): Thursday & Friday, May 22 & 23, 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
Computers Provided.

 

MS Project 2013 Training – Atlanta
MS Project 2013 Training - Atlanta, GADate: Mon Jun 02 2014 – Tue Jun 03 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).
Word 2013 Comprehensive Training – Certification Prep
Date: Mon Jun 02 2014 – Wed Jun 04 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).
Intro to Small Business SEO (Search Engine Optimization)
SEO Training - Atlanta, GADate: Fri Jun 06 2014 – Fri Jun 06 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 Comprehensive Training – MCAS Certification Prep
Access 2013 Training - Atlanta, GADate: Mon Jun 09 2014 – Thu Jun 12 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).

Access 2010 Comprehensive Training – MCAS Certification Prep
Access 2010 Training - Atlanta, GADate: Mon Jun 16 – Wed Jun 18 and Fri Jun 20 (no class on Thursday)
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 Jun 16 2014 – Tue Jun 17 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 Jun 18 2014 – Wed Jun 18 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: Fri Jun 20 2014 – Fri Jun 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 (or let us know if we need to provide one).

Excel Macros & VBA (Visual Basic for Applications)
Date: Mon Jun 23 2014 – Mon Jun 23 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: Tue Jun 24 2014 – Tue Jun 24 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).

Quickbooks Training – Atlanta (WeekEnd)
Quickbooks Training in Atlanta, GADate: Sat Jun 28 2014 – Sun Jun 29 2014
Time: 8:30 am – 5:00 pm
Place: .4388 Lawrenceville Highway, Tucker, GA 30084
For Info: http://www.QuickbooksTrainingAtlanta.com
Computers Provided.
Excel 2013 Comprehensive Course – MCAS Certification Prep
Excel Training Atlanta 2013Date: Mon Jun 30 2014 – Wed Jul 02 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).

 

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

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.

Older posts «