SmittyPro - Witticisms, Help, Tutorials and More
Mar
31

Excel AMA on Reddit – April 4, 2014

written by "Smitty"

Come join the Microsoft Excel Development team on Friday, April 4 at 1:00PM (PST) for the first Excel hosted AMA (what is an AMA? http://www.reddit.com/r/IAmA/wiki/index).  Yes, this will be run by the folks who actually work on developing and maintaining the Excel application! Microsoft depends heavily on user feedback when they’re developing new features for […]

Read More About - Excel AMA on Reddit – April 4, 2014 »

Mar
27

Introduction to VBA/Excel Programming – Free Online Course

written by "Smitty"

Dr. Paul Nissenson, from CalPoly Pomona’s Mechanical Engineering Department, will be offering a free online Introduction to VBA/Excel Programming course through the university.  The 10-week course begins April 1, with enrollment though April 4, and a final exam available from June 7-11.  Non-CalPoly Pomona students with a passing grade will receive a certificate of completion […]

Read More About - Introduction to VBA/Excel Programming – Free Online Course »

Jul
28

Excel 2010 – Business Basics and Beyond

written by "Smitty"

Excel 2010 – Business Basics & Beyond: Microsoft Excel is one of the most powerful tools a business owner, manager, or new employee has at their disposal, and this guide teaches how to harness business data and put it to use. Using real-world examples of a small business in operation, the book covers topics such as preparing financial statements, how to best display data for maximum impact with formatting tools, data tables, charts and pivot tables, using customer information to create customized letters with mail merge, importing data from programs such as QuickBooks, calculating the costs of doing business with financial formulas, and much more. Helpful screenshots are spread throughout the text, and the book explains how to find ready-made templates online for free.

Read More About - Excel 2010 – Business Basics and Beyond »

Jul
28

How to Import Access Data to Excel: the Easy Way…

written by "Smitty"

Many people (especially in Finance) use Excel and Access almost interchangeably, feeding data between both applications. But if you’ve never done it, then how do you? There are several ways to import data from Access to Excel, and you don’t even need to have Access open. You can import Tables, as well as most queries […]

Read More About - How to Import Access Data to Excel: the Easy Way… »

Microsoft MVP

 

Join In

Tag Cloud

Great Links

Archives

SmittyPro.com

Welcome to SmittyPro.com, your one-stop for solutions concerning anything from beginner to extremely advanced Microsoft Excel issues and programming. Topics covered include Excel, Access, VBA, and (every now and then) some amazing observations or "Smitticisms" that might dumbfound you and send ripples of excitement or intrigue around the world.

Categories

Meta

RSS Top Stories from CNN

Vistor Counter for SmittyPro's Blog