Category Archives Microsoft Excel

Microsoft Excel is the best tool in the Microsoft Office Suite for analyzing data. Yet Excel also has the charting and graphing features that help display your data in an easy to understand format.  Not every presentation has to be in PowerPoint. In fact, Microsoft Excel can be a better medium for presenting data in […]

If you have been patiently, or impatiently, waiting for the next release of Microsoft Excel, then you are in luck! The next version of the highly prized and most popular spreadsheet program in existence is here. It was released September 24, 2018. Some of you may already be experts on all of the new functionality […]

At some point, you may have found yourself asking, ?What is conditional formatting?? Conditional formatting means that you can change or add visual cues based on a specified set of rules. It provides a way to improve the appearance and increase the functionality of your spreadsheets as you?re working based on the conditions you have […]

Learning how to use the VBA (Visual Basic for Applications) programming language in Excel will give you the ability to create actual data applications in Microsoft Excel. By combining the two, you wield the power of Excel and you can use VBA to automate its functionality. Let?s take a look at some of the things […]

If you?ve ever used Microsoft Excel, you?ve noticed that there are tons of buttons on toolbars that you can use at different times on different document types in certain contexts. These buttons issue all sorts of handy, powerful commands. Sometimes, the exact command you want can be hard to find if you dive off into […]

Almost everyone who has used Microsoft Excel has created a chart or graph, or will, at some point in their future. This is one of the many areas where Excel truly shines. Charts and graphs help communicate data because it is easier for people to absorb the summary of data in a visual format. Nothing […]

Microsoft Excel has been one of the most powerful, useful business applications on the planet going on the better part of 30 years now. Almost anyone can pick up a basic understanding of how to enter data into its cells and sheets. However, to bring out its true potential you?ll need to master some of […]

Microsoft Excel has been the go-to spreadsheet program for decades. Almost every business professional has used Excel at some point to organize data, compute totals, and create graphs. Excel Analytics provides capabilities that allow users to go way beyond typical Excel functionality. A great way to learn how to leverage the extensive power of Excel […]