Excel
-
Blog
The 10 Most Common Excel Charts and What They’re Used For
There are 17 different types of charts in Excel, so it can sometimes be difficult to choose which one to use. In this article, we’ll look at 10 of the most useful for your everyday data, and how to use them. To create a chart, select your data, open the “Insert” tab, and click the icon in the corner of…
Read More » -
Blog
How-To Geek’s A to Z of Key Microsoft Excel Jargon
Do you know the difference between an array and a range? How about differentiating between a function and a formula? Excel has hundreds of key terms, and some are more intuitive than others. Understanding some of the jargon will go a long way to helping you understand other aspects of the program. Microsoft has its own Excel glossary containing hundreds…
Read More » -
Blog
How to use slicers in Excel – Computerworld
To do this, click 2018 in the year slicer. This will deselect 2017, 2019, and 2020, leaving only 2018 selected. Then in the Category slicer, click Equipment to deselect everything except Equipment. The result? The table now shows only three rows, all of which contain equipment sales from 2018. The table data has been filtered according to our selections, showing…
Read More » -
Blog
The Microsoft Excel World Championship Is My New Favorite Esport
Key Takeaways Excel Esports are real, and feature logic challenges, not financial tasks. Contestants are free to solve tasks with whatever shortcuts and functions they like. Qualifying rounds and playoffs take place online; only finals are in person. There is a $20 entry fee. The best Esport that you’ve never heard of, the Microsoft Excel World Championship, features something to…
Read More » -
Blog
How to Import Tables From the Web to Excel 365
Key Takeaways Importing tables from the internet to Excel 365 is straightforward and saves time. Simply copy the web page’s URL and use the “From Web” function in the “Data” tab. Use the Power Query Editor to manage and transform imported data, such as removing duplicate headers or combining data from other sources. Customize the imported table in the Excel…
Read More »