There are plenty of tools—both hardware and software—that are essential to your every day work life. If you’re like many people, Microsoft Excel is probably one of those essential tools. But even with everything you know about Excel, are you truly taking advantage of...
This is a guest post from Greg Matoka with the Excelgrm blog. Pop quiz: Look at the table below in Figure CF- 1 and identify all the salespersons whose monthly sales were one standard deviation above average for that month. You have 2 seconds to answer. Sorry, times...
I haven’t done an Excel tutorial in a really long time. I used to create one from every “how do you do this in Excel” request that I got on Twitter, via email or Facebook. A Twitter friend asked yesterday and this is actually really helpful for those...
How to move data in Excel from Rows to Columns A great question came to me today from @SupportMyOffice (Thanks, Jennifer, for making me smarter today!) Question: I have a bunch of data in one row in Excel and I want to move that data into one column. Is there a one...
Google Spreadsheets Tip I’m not a huge fan of Google Documents, particularly their spreadsheets (yes, I am old school with Microsoft) but when you are working in a virtual capacity they definitely get a win for multiple people being able to make changes...
Combining two different cells in Excel to have all info in one cell This Excel formula is really handy, especially if you have a first and last name in two different cells and want to combine them into just one cell so instead of: Column A=First Name Column B=Last...
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptRejectPrivacy Policy
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.