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 »

Feb
14

Mastering Excel for Analytics Success (with 20% off!)

written by "Smitty"

Do you want to make Excel work a little harder and faster for you? Do you spend way too much time forcing Excel to bend to your will instead of automating reporting and performing valuable analysis and discovery work? Are you positive that there are better ways to spend your time than manually formatting and […]

Read More About - Mastering Excel for Analytics Success (with 20% off!) »

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