Thursday, January 30, 2014

10 Basic Things You Should Know When Using Microsoft Excel

Below is a list of 10 basic commands/features in Microsoft Excel that you should not not only know how to use, but also when to use, as an efficient, effective, and productive user of technology.
  1. Sorting (Single & Multi-Level Sort)
  2. Conditional FormattingMS_Excel
  3. Sum (Formula)
  4. If (Formula)
  5. Text Wrapping
  6. Hyperlinks
  7. Filters
  8. Format Painter
  9. AutoSum
  10. Hiding Columns, Rows & Worksheet Tabs
Other than modifying an Excel workbook design, these are truly 10 things that can transform an Excel workbook into an efficient, effective and productive tool for even the most novice of technology users.

Tuesday, January 28, 2014

Inspiration & Motivation for Small Business Start-up Owners & Entrepreneurs

I'd like to share with you an individual that I met last June (2013) and has since become a very important part of my professional world.  From the day that I first met this individual, as a referral from another business associate, I have been inspired and motivated in ways that reminded me as to why I initially became interested in entrepreneurship some 20 years ago.

His name is Jason Owens and I consider him to be a very good friend and we have developed a special business kinship over these past 8 months; that I hope continues to grow and flourish. He has just written a book that I think you will enjoy.  

It is called "Finding my Voice".  

It is about the lessons he learned in his long journey to find his purpose.

  I highly recommend it. You can get your copy here

Saturday, January 25, 2014

Customizing the Ribbon in Microsoft Excel

Excel TAB-Tips_02B

Did you recognize either of the two identified objects above?  If you haven’t taken an “E-squared-P” training class with Troy A. Burgher, then you probably will not recognize this awesome time saving feature.
This cool feature in the Microsoft Office 2010 and 2013 Application Suites allows for the creation of Custom Tabs and Groups on the Ribbon.  

Check out this video link to see how to customize the Ribbon.


For more information about other tips…visit

Saturday, January 18, 2014

My MOS 2013 Certification Journal_012014

I have created an outline (see below) with my projected hours of training and the daily implementation of newly acquired skill sets into my everyday life [personal & professional] that I plan to follow in preparation of the six certification exams necessary for acquiring the MOS 2013 Master Level Certification. I will ultimately be using the skills and projects created from my certification preparation as material to use in future training opportunities through TAB Training & Consulting, LLC.

Training Prep Outline:

Projected Prep and
 Study Hours
Microsoft Excel Expert (2 exams)
Microsoft Word Expert (2 exams)
Microsoft PowerPoint (1 exam)
Microsoft Outlook (1 exam)

The next step is create a check-off list of of subject matter that needs to be covered, studied and practiced as I prepare for the first application certification exam – Microsoft Excel.  Not only will I be preparing for the exam, but I am also preparing project-based exercises for my business as training tools.

I will share a summarized version of the my study check-off list, much like the check-off lists that I create for my daily workload as a full-time employee.  I find them very useful in ensuring that I complete all necessary tasks associated with the many processes that I must follow in order to complete my daily activities.  This check-off list also provides documentation that I have completed all steps associated with any given tasks for auditing purposes.

Signed - Still very excited about MY Challenge

Troy A. Burgher