Category Archives Microsoft Excel

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

Excel-2013/2016-VBA-Programming-for-Beginners-ONLC

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

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

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

streamline-business-withexcel-analytics-onlc

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

excel-formula-help-onlc

If you’re spending hours inputting information and calculations into Microsoft Excel manually, there’s some good news and some bad news. The bad news is, you’ve been wasting your time. The good news – you don’t have to do that anymore! Excel comes equipped with countless built-in formulas that can simplify your life, accelerate your workflow and make calculating easier […]

microsoft-excel-certification

Knowing your way around Microsoft Excel is a good skill to master for any job. It’s likely one of the most widely used, if not the most widely used business software today. So while complete mastery may not be required for your occupation, gaining the ability to navigate it easily is definitely worth your time. […]

Close