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.

Logical Analysis

• 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)]

Input

Description

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

• 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.