by Tony Holowitz | Oct 9, 2019 | Microsoft Excel
Here is another great Excel tutorial from AbleBits that will show you how to remove empty rows from an Excel spreadsheet. Here is some more information about AbleBits and some of their Excel products: Add-ins for Microsoft Excel: www.AbleBits.com Free downloads for...
by Tony Holowitz | Oct 8, 2019 | Microsoft Excel
Microsoft Excel Online tips and tricks to help you get started RECOMMENDED: Click here to fix Windows errors and improve system performance Source: Microsoft Excel Online tips and tricks to help you get started From students to businessmen – Microsoft Excel can be a...
by Tony Holowitz | Sep 4, 2019 | Microsoft Excel
Andre Da Costa | October 10, 2016 in How-To Source: 10 Microsoft Excel 2016 Tips Every User Should Know Microsoft Outlook, Microsoft Word, and Microsoft Excel are the three heavyweights in the Microsoft Office suite. We recently showed you some of the best features...
by Tony Holowitz | Aug 5, 2019 | Microsoft Excel
How to only delete visible rows or columns in Excel? In Excel, we usually hide some important rows or columns of information, sometimes, we need to delete the visible rows or columns only, if you delete them with Delete key directly, the hide values will be deleted at...
by Tony Holowitz | May 31, 2019 | Microsoft Excel
Excel TRIM function – quick way to remove extra spaces The tutorial demonstrates a few quick and easy ways to trim Excel spaces. Learn how to remove leading, trailing, and extra spaces between words, why Excel TRIM function is not working and how to fix it. Are...
by Tony Holowitz | Mar 25, 2019 | Microsoft Excel
Change text to upper, lower, or proper (normal) font in Microsoft Excel Applies To: Excel 2013 | If you need to quickly change the text case to uppercase, lowercase, or proper (normal) case, use Flash Fill instead of retyping all the text. For example, column A...
by Tony Holowitz | Feb 1, 2019 | Microsoft Excel
Microsoft Excel is a tool that often leaves me scratching my head because I have a need to do something and I can’t figure it out. Frequently, I suggest to my clients to Google, in your words, what it is that you’re trying to accomplish. Sometimes, you can...
by Tony Holowitz | Oct 19, 2016 | Microsoft Excel
Simpler and faster is always better in Excel. Source: Excel tips: 6 slick shortcuts, handy functions and random-number generators | PCWorld We start with some of my favorite shortcuts, then move on to using Excel for everyday situations such as finding random...
by Tony Holowitz | Jul 5, 2019 | Microsoft Excel
How to add, copy and delete multiple checkboxes in Excel by Svetlana Cheusheva Excel, Excel tips, Excel tutorials No Comments source: How to add, copy and delete multiple checkboxes in Excel The tutorial will teach you how to quickly add multiple checkboxes in Excel,...
by Tony Holowitz | Sep 22, 2019 | Microsoft Excel
Written by Rachel Sprung | @rsprung How to Use Excel: 14 Simple Excel Shortcuts, Tips & Tricks Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I’d ever need to do manually can be done...
by Tony Holowitz | Aug 19, 2018 | Microsoft Excel
How to find and replace asterisk / question mark / tilde in Excel? When you work with an Excel file, you want to find the cells which contain asterisk, question mark or tilde and replace the specific characters with other values. Most of you may consider directly...
by Tony Holowitz | Oct 3, 2018 | Microsoft Excel
If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows, or vice versa.For example, if your data looks like this, with sales regions listed...
by Tony Holowitz | May 10, 2018 | Microsoft Excel
Create a PivotTable to analyze worksheet data From www.Microsoft.com Being able to analyze all the data in your worksheet can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. Excel can...
by Tony Holowitz | Oct 22, 2019 | Microsoft Excel
Microsoft Excel pivottables are a great way to take complex data and organize it so it is much easier to understand. Yesterday a client and I had a discussion about Microsoft Excel and working with pivot tables. I asked her if she knew about pivottables and she said...
by Tony Holowitz | Sep 28, 2019 | 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 | Jul 27, 2018 | Microsoft Excel
When you partake in my Microsoft Excel tutorials you will learn everything you need to know about Microsoft Excel. I offer more than 27 great Microsoft Excel tips and tutorials and if you review them in order it is the equivalent of taking a Microsoft Excel class. Why...
by Tony Holowitz | Oct 20, 2019 | Microsoft Excel
Here is a very quick tutorial on how to use flash fill in Microsoft Excel 2013. This tutorial was created by Michael Herman and appears on YouTube. This technique can save you a lot of time and energy. Thank you Michael for this great tutorial on flash fill. Enjoy....
by Tony Holowitz | Aug 28, 2019 | Microsoft Excel
Excel help Learn: Excel tutorials Create your first workbook using Excel 2016 Explore Excel 2016 Find commands quickly with Tell Me Create a workbook using a template Create a basic chart Save a workbook to the cloud Source: Excel help and training –...
by Tony Holowitz | Oct 19, 2019 | Microsoft Excel
Free Microsoft Excel Training Classes, Tutorials and Articles Tony Holowitz founded Teach an Old Dog New Tricks to provide free computer training videos, tutorials, articles and educational resources to computer users in a wide variety of subjects that include...
by Tony Holowitz | Feb 12, 2019 | 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...