by Tony Holowitz | Feb 9, 2020 | Microsoft Excel
Tutorial – Excel 2010 – 10 Things you must know Uploaded on Aug 7, 2011 Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2010, Excel is used world-wide and this tutorial shows slightly beyond the basics in a simple way of...
by Tony Holowitz | Feb 7, 2020 | Microsoft Excel
Now it is time to discuss the F-Word…Formulas in Excel. There is nothing that strikes fear in the hearts of my students like learning how to create formulas in Microsoft Excel. Believe it or not, formulas are not that hard to work with if you follow these...
by Tony Holowitz | Feb 6, 2020 | Microsoft Excel
Do not be intimidated by Microsoft Excel 2013. In this tutorial we will take a look at moving around in Microsoft Excel. We will insert some simple text and show you how to move things around. We will also look at resizing columns and rows. Excel has more than 16,000...
by Tony Holowitz | Feb 5, 2020 | Microsoft Excel
Excel functions (alphabetical) Applies To: Excel 2016 , Excel 2013 , Excel 2010 , Excel 2007 , Excel 2016 for Mac , More… Click a letter to go to functions that start with it. Or press Ctrl+F to find a function by typing the first few letters or a descriptive...
by Tony Holowitz | Feb 3, 2020 | Microsoft Excel
Insert, move, or delete page breaks in a worksheet To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it. Although you can work with page breaks in Normal view, we recommend that you use...
by Tony Holowitz | Jan 31, 2020 | Microsoft Excel
In this tutorial I will show you how to convert text to columns in Microsoft Excel. On occasion you might find that is helpful to be able to take data in Excel column and break it out into one or more columns. This simple tip will show you how to do that quickly and...
by Tony Holowitz | Jan 29, 2020 | Microsoft Excel
Microsoft Excel 2013 tries to make it easy to work with pivot tables by recommending certain types of pivot tables that represent your data. I must command Microsoft on this feature in Microsoft Excel: recommending pivot...
by Tony Holowitz | Jan 28, 2020 | Microsoft Excel
Microsoft Excel can be used for rather simple tasks or more complex calculations. As you gain more experience with Microsoft Excel you might find that you want to explore some of the formulas that work with an Excel. In this series of tutorials I will start taking a...
by Tony Holowitz | Jan 15, 2020 | Microsoft Excel
Learning to use Microsoft Excel’s AutoFilter feature is a simple and easy way to quickly break down an Excel Spreadsheet filled with data. For a typical Microsoft Excel user auto filter is a quick and easy way to break down data quickly and efficiently. The...
by Tony Holowitz | Jan 11, 2020 | Microsoft Excel
Microsoft Excel has so many features and unique tips and tricks that I quite often forget how to do things. Working with software is like speaking a language, if you don’t use it you’ll lose it. I have always felt that Microsoft Excel is one of the hardest...
by Tony Holowitz | Jan 8, 2020 | Microsoft Excel
This is the cousin of Excel’s VLookup and is a variation of a theme. The more you are exposed to different formulas in Microsoft Excel the easier it will be for you to take your skill level with Microsoft Excel to a new level. As I have always stated to my...
by Tony Holowitz | Dec 27, 2019 | Microsoft Excel
This tutorial opens you up to the magic of Excel. Excel is a blank sheet of paper with cells that awaits your information. Excel lends itself to many uses. In this tutorial we take a look at creating numbered lists and other simple shortcuts to make entering data...
by Tony Holowitz | Dec 20, 2019 | Microsoft Excel
Excel 2016 training Applies To: Excel 2016 Office Training Center > Excel training > Excel 2016 training Tip: Check back from time to time. More Excel 2016 courses are on the way! Create your first workbook using Excel 2016 Learn the basics of Excel 2016. See...
by Tony Holowitz | Dec 17, 2019 | Microsoft Excel
Add the Current Date in Excel Excel Shortcut Keys Tutorial By Ted French Ads: Excel Online Training Spreadsheets Excel Templates MS Excel Microsoft Excel 2010 “Use Shortcut Keys to Add the Current Date in Excel” Use Shortcut Keys to Add the Current Date in...
by Tony Holowitz | Dec 15, 2019 | Microsoft Excel
Moving Information Around in Excel. We take a look at moving content from one cell or many cells around in Excel. I’ll also show you how to duplicate the contents of a cell. Fundamental computer skills will come into play here with some simple drag and drop...
by Tony Holowitz | Dec 13, 2019 | Microsoft Excel
Formula examples that demonstrate how to use Excel VLOOKUP and SUM or SUMIF functions to look up and sum values with one or several criteria. You can use these formulas on any data in any version of Excel 2013, 2010, 2007 or 2003. See the complete tutorial here: Excel...
by Tony Holowitz | Dec 2, 2019 | Microsoft Excel
This video tutorial was created by the folks at Excel and Access, LLC and is an excellent illustration of how to use Vlookup in Microsoft Excel. I have reviewed a number of their videos and I urge you to subscribe to their channel on YouTube. This video was created by...
by Tony Holowitz | Nov 12, 2019 | Microsoft Excel
This class reviews the fundamentals of Microsoft Excel. Most of the tutorials on this website are rather short, five minutes or less. This tutorial is 55 minutes long and I feel you really need to watch the whole tutorial to get a sense of Microsoft Excel. This...
by Tony Holowitz | Nov 5, 2019 | Microsoft Excel
Here are 10 New Microsoft Excel Formulas to Explore You might think that Excel couldn’t possibly come up with any new functions — but with every new version, we get a few more. Most of them are specialized and of use to specific users, such as analysts or...
by Tony Holowitz | Oct 23, 2019 | Microsoft Excel
Tony’s Place is a fictitious pizza shop that I use to illustrate how to use Excel to run a simple spreadsheet. In this tutorial we make a ugly looking spreadsheet look pretty so you can get a promotion to regional manager of Tony’s place. Part 1 covers...