An Introduction to Excel Formulas (Part 2)

Welcome to part two of three in this series of blog posts introducing Excel formulas. During this blog post, I will introduce Reference Operators, Operator Precedence, and Error messages.

First, let’s have a quick recap of what was introduced in part one of this series. Excel formulas are one of Excel’s most powerful and useful features. During part one, I discussed what formulas are, why they are useful, and how they can be used. Part one also introduced one method of entering a formula into an Excel spreadsheet and the component parts that make up a formula (Operands, Operators, and Functions).

Continue Reading →

An Introduction to Excel Formulas (Part 1)

In this series of blog posts, I’ll introduce you to one of Excel’s most powerful and useful features, Excel formulas.

Formulas can be used for a multitude of things, such as calculating tax on an invoice or the volume of water an object can hold, removing or replacing specific characters in a string of text, identifying how often a certain value appears in a range of cells, and so on. The possibilities are almost endless.

Continue Reading →

How to Navigate the Excel 2016 for Mac User Interface

How to Navigate the Excel 2016 for Mac UI Twitter

With Office 2016 for Mac came a new version of Excel. The changes to the 2016 version of Excel for Mac are significant and bring it more closely in line with its Windows cousin. In this blog post, I’ll provide you with a brief introduction to the User Interface. Once you’re done, you’ll be able to hit the ground running and navigate the User Interface without wasting too much time.

Let’s start with what we mean by the User Interface? Well, this is the part of the software (in this case Excel) that is displayed on the screen of whatever device you are using (laptop, desktop, tablet, phone, you get the idea).

Usually, the User Interface displays all the menus and buttons you click to interact with the functions and features of the software your using. Microsoft refers to these functions and features as Commands, so, from this point forwards so will we.

The User Interface also generally updates and displays the changes that come about as a result of your interactions with the software (Excel). The User Interface can also display messages to the User (you), that might be important.

Continue Reading →

Page 7 of 7