Update: On January 31, 2021 Microsoft retired Microsoft Certified Solutions Associate (MCSA), Solutions Expert (MCSE) and Solutions Developer (MCSD) certifications. In their place are Microsoft’s Role-based certifications. There is hardly a more prestigious certification in the computer networking world than the Microsoft Certified Solutions Expert Certification. The MCSE conveys to employers that an IT […]
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 […]
Microsoft Excel has been around a long time. When you think about spreadsheets, you think Excel. However, over time Excel has grown into so much more than a simple spreadsheet program. It is one of the most robust, useful and powerful tools for analyzing data that has ever been created. Excel is used by accountants, […]
PivotTables are a powerful feature included in Microsoft Excel that allows you to quickly extract the meaning from very large data sets. They do this by including tools and functions that analyze large amounts of data. Let’s look at how to create Excel PivotTables as well as how we can use them to greatly enhance […]
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 […]
Excel is arguably the best and most used spreadsheet program in history. It also provides tons of other smart tools that make it the “Swiss Army Knife” of the software world. Let’s go over some hidden Excel tips and tricks that you never knew existed. Flash Fill If you have columns that are repeating patterns, […]
Most of the blog posts that deal with customizing the toolbars on Microsoft Office products are written for PC users. Now that MS Office has become the standard for office applications on the Apple Macintosh OS, too, let’s discuss how to customize the Excel toolbar on a Mac. Please note that these instructions are for […]
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 […]