An Introduction to Excel Formulas (Part 3)

Welcome to the final part of this three-part series of blog posts introducing Excel formulas. If you haven’t already read part one and part two in this series, then I suggest you read them first. For this final blog post, I will introduce the single Text Operator and some commonly used functions that can be useful from day one.

Continue Reading →

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 →

Basic Formatting Tips for Excel

Let’s face it, spreadsheets look boring, rows and rows of numbers and text. However, with a little bit of formatting, we can improve things drastically.

In this blog post, I’m going to introduce you to some of the basic formatting features in Excel that can make your spreadsheets look a little bit more interesting. Adding formatting to your spreadsheet not only makes them more interesting to look at but also makes them easier to read and understand.

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