Kenji Explains on MSN

I split Excel sheets in seconds!

In this video, learn how to split data into multiple worksheets in Excel, such as separating total sales into quarterly ...
New Atlas

This heavy-duty carabiner packs 7 more tools for your next expedition into the wild

When you're hiking or camping in the woods, a carabiner's great to have on hand for making your gear more accessible and securing items together. This rugged new one from Hong Kong-based brand Pivot X ...
TechSpot

Microsoft urges customers to prepare for VBScript deprecation in their Office VBA macros

The big picture: The Windows ecosystem has offered an unparalleled level of backward compatibility for decades. However, Microsoft is now working to remove as many legacy technologies as possible in ...
FiercePharma

Supreme Group buys Pivot Design, bringing agency takeover tally to 9 in 18 months

Supreme Group has pulled Pivot Design into its whirlwind acquisition splurge, making the health agency its ninth takeover in 18 months. Operating out of Chicago, Pivot has worked with clients ...
PC World

Microsoft finally fixes the worst thing about Excel’s pivot tables

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...
JournalofAccountancy

Say bye to PivotTables with Excel’s new PIVOTBY function

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...