3 ways to Outsmart Your Coworkers on Microsoft Office 365 Excel
Excel has powerful capabilities to analyze data. Once you master Excel’s functionalities, you’ll be able to organize and manipulate data in seconds. Excel skills open many doors and are more learnable than you may believe.
Data Analysis in Excel
• Count Function – gives you the number of entries that contain numbers
o Write [ = COUNT(value1, [value2], …) ]
|Value1||Cell reference or range where you want to count numbers|
|Value2 (optional)||Additional ranges where you’d like to count numbers|
• Selective Counting – only count numbers that meet identified criteria
o Write [ = COUNTIF(range of values, criteria) ]
o I.e. COUNTIF(A2:A5,”apples”)
• IF statements use Boolean logic in excel and are useful for automating decisions. IF statements search if a condition is met and return “True” if it is and “False” if it is not.
o Write [ =IF (Logic_Test, Value_if_True, Value_if_False)]
|Logic_Test||Expression that will be evaluated|
|Value_if_true||Output if the “Logic_Test” is true|
|Value_if_false||Output if the “Logic_Test” is false|
o Example: IF(B2<=100,”Below Cost”,”Markup”)
o This statement will return the result “Below Cost” if the value of the cell in B2 is equal to or under 100 and “Markup” if the value is above 100.
• Flash Fill is a lesser known, newer feature of excel that makes it easy to break apart information from concatenated cells. For example, imagine you have a column of cells that detail the names of customers in the format “Last name, First name”. Let’s say you’d like to separate the list into separate “First Name” and “Last Name” columns. Will Flash Fill, you can type the first name in a new cell, click Flash Fill and excel will extract the first name from the previous column and fill out the rest of the list.
Excel is the gold standard data management program on the market. Becoming a power user in excel should be a top priority. There are thousands of functionalities to learn and new features are released in updates every year. Switch to Microsoft Office 365 for your business today in order to harness the power of Excel for you.
PropelU Cloud Solutions
Save up to $3500 by migrating to award-winning Microsoft 365 products with PropelU Cloud Solutions’ cloud migration experts. Let us take care of the complex implementation process so that you can start using the best productivity tools to move your business forward.