Turbocharge your productivity with advanced Excel skills for only $10
Learn all of Excel’s features, plus how to program and streamline your workflow with automated tasks in this Excel Training bundle. Image: wachiwit/Adobe Stock It’s … Read more
excel
Excel guide: Referencing cells using COUNTIF
Counting values is an easy task using Excel’s COUNTIF() function, which is essentially a combination of the COUNT() and IF() functions. It is used to … Read more
This Excel, VBA and data science training is 98% off today
Learn how to use data to your advantage in business with The Complete Excel, VBA, and Data Science Certification Training Bundle. Image: StackCommerce In business, … Read more
The best keyboard shortcuts for rows and columns in Microsoft Excel
Image: Andreas Prott/Adobe Stock Everyone wants to work efficiently so learning ways to do small tasks quicker is always a win. All of the Office … Read more
Use the New TEXTSPLIT() Function in Microsoft Excel
Image: wachiwit/Adobe Stock Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character from the middle of another string. … Read more
Export a Microsoft Excel Table to Microsoft SharePoint
Image: Tada Images/Adobe Stock If you’re the author of Microsoft Excel data that others in your organization need to view and perhaps even update, you … Read more
Columns & Groups in a Shared Microsoft Excel Workbook
Microsoft Excel’s sheet view collaboration feature has been around for a while, but now it supports hiding rows and columns and applying groups. Image: Araki … Read more
Combine Values Into One Cell in Microsoft Excel Power Query
When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy. Image: … Read more
How to run a VBA procedure from a data validation control in Microsoft Excel
Image: hasan/Adobe Stock TechRepublic Academy There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at the … Read more
Improve the Looks of Default Area Charts in Microsoft Excel
Image: 200degrees/Adobe Stock Area charts do a great job of exposing trends in Microsoft Excel data. The good news is that they’re easy to create; … Read more