Why you need to learn Microsoft Excel

June 20, 2016

0 comments



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Proficiency in Microsoft Excel is no longer a boost to your resume, it is a necessity.  

A firm grasp on a few Excel functions can be the difference between a 20 minute task and a 3 hour project.  With employers asking more out of their employees, there is no excuse for your Microsoft Excel skills to be subpar.  

Where do we start?  

      • The SUM formula: =SUM(A1, B1)
        • There is no secret as to what the SUM formula does.  It allows you to add 2 or more cells that contain numbers together.  Gone are the days of typing =5+5 in the cells, or even doing the calculations outside of Excel and inputting the answers.  With =SUM you can create a dynamic formula that can change with the ebbs and flows of your spreadsheet.    
      • The VLOOKUP formula: = VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
        • Daunting complex at first, but extremely simple and useful once you complete a few, the VLOOKUP is used to pull specific data from one list to another.  Read more about the VLOOKUP use cases here.
      • The Pivot Table function: Arguably the most powerful tool in Excel.  An entire company, Tableau, is basically one extremely complex Pivot Table company.  
        • This is the best way to analyze large amounts of data in Microsoft Excel.  Read more about Pivot Tables here.
      • IF Statements: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
        • IF statements can be used in every way imaginable.  We can create an IF statement to return the word Yes or No if a customer has bought the product more than once, or even create a customer health score based on usage data. 
        • Here are a few sample IF statements to get started.  

As always, please let the Excel Skin team know if you have any questions!



Leave a comment

Comments will be approved before showing up.