Formatting and it’s Impact on Excel Analytics
Formatting in Excel has positives, but it can also stop some analytics functions from working, what does that mean for you?
Formatting and it’s Impact on Excel Analytics Read More »
excel
Formulas and Functions – What you need to know
Formulas and functions are key things to know and use within a spreadsheet. What’s the difference? Here’s what you need to know!
Formulas and Functions – What you need to know Read More »
Moving Around Excel – Do you know these shortcuts?
Whether you’re working in a small or large spreadsheet, here are some tips that will speed up your moving around your data.
Moving Around Excel – Do you know these shortcuts? Read More »
MOS (Microsoft) – Did You Know?
The Microsoft User Certifications (MOS) have been around since 1997 – here are a few ‘did you know’ facts showing how they’ve changed over the years.
MOS (Microsoft) – Did You Know? Read More »
Prove you know – Microsoft Office
Moving onto the other big player for office suites – I now take a look at the Microsoft Certificate. MOS is the most well-known end-user exams.
Prove you know – Microsoft Office Read More »
What’s Relative and Absolute Addressing in a Spreadsheet?
Introducing relative and absolute addressing in Excel – let me take you through it step-by-step, and how you can use it to make things easier.
What’s Relative and Absolute Addressing in a Spreadsheet? Read More »
What use is a cell address in a spreadsheet?
What use is a cell address in a spreadsheet? Why and how you should be using them to make your calculations flexible.
What use is a cell address in a spreadsheet? Read More »
Do you know BODMAS and the Rules of Precedence?
MS Excel automatically uses these rules to calculate the answers. Remember BODMAS to help you work get the right answers.
Do you know BODMAS and the Rules of Precedence? Read More »