Top Menu

Category Archives Microsoft Excel

microsoft technical certifications

There have been plenty of changes recently to the Microsoft certification structure. Primarily, these changes have been driven by the increasing emphasis on cloud technology. Azure is Microsoft’s flagship cloud computing service. Almost all of Microsoft’s certification tracts have been modified to include information about Azure integration in its products and how they will function […]

msce productivity question

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 professional has the necessary skills to help increase user productivity, flexibility, and efficiency. It also validates that the cert holder has the knowledge to take their organization to […]

rawpixel-603015-unsplash

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 […]

Creating Excel PivotTables to Analyze Data ONLC

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 […]

hidden-excel-tricks-ONLC

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 tricks that you never knew existed.  Flash Fill If you have columns that are repeating patterns, you can […]

12
Close