Book Review – Excel 2016 All-In-One For Dummies

Hi, welcome to this week’s blog post. This post is going to be a little different from my normal blog posts. I’m doing a review on a book that I have on my desk at all times. The book in question is Excel 2016 all-in-one for dummies. I have the 2013 edition of this book and when the Excel 2016 edition was published, I was quick to order a copy.

Continue Reading →

How to View Two Worksheets Side-by-Side

How often have you wanted to open two Worksheets or Workbooks side-by-side? The ability to open two Worksheets side-by-side is one of the most useful, and commonly asked about, features in Excel.

In this blog post, I’ll quickly show you how this is done, and a few different options you can use when viewing multiple worksheets.

Continue Reading →

Introduction to Conditional Formatting (Part 2)

Welcome to part two of this two-part series of blog posts introducing Excel Conditional Formatting. If you haven’t read part one in this series, then I suggest you read it first by clicking here.

In this second blog post, we’ll look at Data Bars, Color Scales, Custom Rules and how to Manage Rules.

Continue Reading →

Introduction to Conditional Formatting (Part 1)

Hi and welcome to part one of this two-part blog post series on Conditional Formatting. In this blog post, I will introduce you to the Excel feature of Conditional Formatting. I’ll give you a brief idea of what it can be used for and provide you with some examples.

Continue Reading →

How to Use The SUMIFS Function

Hello and welcome to this blog post on the Excel function SUMIFS. In this blog post, I’ll show you how the SUMIFS function works, explain its syntax and provide you with some examples of how it can be used.

Continue Reading →

Page 6 of 7