beginner excel lessons

Excel 101 – Getting Started with Excel 365

Everyone must start somewhere and getting started with Excel 365 will be made easy with this massive article.  Grab your coffee and get ready to learn Excel in a practical way. If you have every wondered how to use an Excel Spreadsheet and how you can learn to use Excel quickly then you have come […]

Excels Rank Functions

Using Excels Rank functions

Excels Rank functions have evolved over time, and give you the ability to ranks values in a list or column based on their value compared to other values in the same list or column. In Excel 2007 and previous versions, the function you would use to rank value is Rank and the syntax is: =RANK(Number, […]

How to use SUMIF and SUMIFS in Excel

The SUM function in Excel is probably the most widely used function available.  In fact it is the only formula that has its own keyboard shortcut (Alt & =).  Therefore it should come as no surprise that this basic mathematical function has more powerful cousins available in Excel.  These functions are know as SUMIF and […]

OFFSET Function to make Excels SUM function Dynamic

Everyone can use the SUM function in Excel.  It is the most basic and used functions available. In fact, it is the only formula in Excel that has its own keyboard shortcut (Alt + =).  However many users find difficulty when adding additional rows to the data which they are summing.  The formula has taken […]