An ‘absolute reference’ or ‘absolute cell reference’ is a spreadsheet (excel) cell that remains the same irrespective of where & how it is used – either moved or copied. Hence this is an important function that excel users need to grasp. Why would you need to use this function? It’s quite likely that you...
Continue reading4 Excel Techniques To Boost Your Data Productivity
4 tips to increase your data skillset in excel We promised you 4 excel techniques to improve your data productivity in the earlier post. Here are four tips to help you create pivot tables, sort and rank data, and update the date and time in a worksheet automatically: 1. Create a Pivot Table to...
Continue readingMaster Excel Functions To Boost Your Data Analysis
Tips to take your data sorting and reporting to the next level Microsoft Excel is a powerful tool for compiling and analyzing large quantities of data. But are you intimidated by its complexity? You don’t need to be a master programmer to master Excel functions. Just endure the small amount of time it takes...
Continue readingHow to Use the MATCH Function in Excel with Ease
Learn from these scenarios and practice your skills Are you using one of the LOOKUP functions in Microsoft Excel when you need an item’s position instead of the item itself? If so, you should know that there’s an easier and more accurate way to do this: Use the MATCH function instead. With more than...
Continue reading2 Visual Representation Tricks Help You Bring Your Excel Data To Life
Use these keyboard shortcuts to add a default chart or data bars for a quick analysis. Sure, you spend a lot of time collecting, reporting and analyzing data. And you want to showcase the hard work you have done. But if you really want your data to make sense and spur action, consider representing...
Continue readingSimplify & Standardize: Data Entry via Excel Forms
2 tricks help you control the way your data appears in any Excel sheet. If you are like most Excel users, you probably use the application primarily to enter and store data. And you probably type all your data, right? There’s a better way! With just a bit of know-how, you can create user-friendly...
Continue readingFinding Unique Values or Largest Numbers in Excel?
Try using ROWS and MAX Functions Posted on January 9, 2018 by Julie Duncan There are hundreds of functions in Excel, but the ones you use will depend on the type of data your workbook has and what you need to analyze. You probably don’t need to know each of them, but the ROWS and MAX functions...
Continue readingSpeed Up Data Entry With Flash Fill and Auto Fill
Excel is great when you’ve got large amounts of data to maintain. But entering that data into your document and formatting it correctly can be time-consuming and tedious. Here are two automatic-fill features to ease that task – Ta Da! Flash Fill & Auto Fill. Try this: Consider using Flash Fill if you have a...
Continue readingColor Code To Better Organize Excel Data
Don’t Miss Out on an Often Untapped Resource To get a quick handle on your Excel worksheet data, you can change the color of your cells according to their numerical values. Doing so will amp up your organization and filtering capabilities—not to mention let your data speak volumes at one, quick glance. Very useful...
Continue readingUse an Excel Dashboard for increased Project Visibility
Present Your Project KPIs Clearly and Join the Business Intelligence Revolution Dashboard for increased project visibility – Helping stakeholders see the key areas of a project easily involves communicating important data points of the project with employees, your CEO or shareholders. The dashboard is perfectly tailored—literally, you can create a dashboard according to your...
Continue reading