Microsoft Excel is a critically important application for so many industries. It can also be incredibly complex to master. Don’t let Excel’s complexity prevent you from mastering its power. Check out the eLearnExcel course to get over 60 hours of in-depth Excel training for 90% off its regular price!
If you use text replacement—like being able to type in “omw” and having it replaced by “on my way”—then you may be upset by the fact that Outlook no longer uses the system-level ones on the Mac. In this tip, we’ll discuss how to configure those shortcuts in Outlook instead!
Microsoft’s Office 365 service provides an easy way to download and install the Office apps (like Word and Excel) on any machines you have, as long as you have the licenses available. But if you need to deactivate an installation of Office 365, there’s a quick method for doing so! We’ll tell you how.
OneDrive is the default save location in Office 2013, which is great if you regularly use the service. But for those who prefer to save files locally, here’s how to change the default save location in Word, Excel, and PowerPoint.
Microsoft late Tuesday released an update to the Office for Mac 2016 Preview. In addition to a number of bug fixes and functionality improvements, Word, Excel, and PowerPoint received some visual tweaks that mirror the changes in progress for the Office 2016 for Windows beta.
One of the benefits of Microsoft Excel is that you can set up formulas ahead of time which will automatically update as you enter new data. Some formulas, unfortunately, are mathematically impossible without the requisite data, resulting in errors in your table such as #DIV/0!, #VALUE!, #REF!, and #NAME?. Here’s how to hide those errors with some help from the IF and ISERROR functions.
Microsoft Excel is a powerful spreadsheet application, but it also allows for the creation of a wide variety of impressive charts and graphs. While sharing an entire Excel file is often preferable, sometimes you may wish to only share or export the graph or chart. Here are several ways to export an Excel chart as an image.
Apple’s Numbers spreadsheet app, part of the company’s iWork productivity suite, makes it easy for users to create beautiful tables, but lacks the power and compatibility of Microsoft Excel. For those stuck with Excel on Mac OS X, however, manual formatting can still be used to improve the look of your tables. One of the most useful steps is to hide unused cells, mimicking the look of Numbers. To hide cells in Excel for Mac, first create your table, making…