Analyzing Large Datasets with Power Pivot in Microsoft Excel
Posted on
February 7, 2019
The context for Power Pivot...
Read More
10 Excel Formulas Every Beginner Should Know
Posted on
January 18, 2019
[vc_row row_type="row" use_row_as_full_screen_section="no" type="full_width" oblique_section="no" text_align="left" css_animation="" box_shadow_on_row="no"][vc_column][vc_column_text]Excel formulas make calculating numbers and making sense of large amounts of data simple. By knowing a few key formulas, you can do a variety of actions in Excel that will increase your productivity and decrease the risk of making...
Read More
15 Excel Data Analysis Functions You Need to Know
Posted on
January 4, 2019
in Excel, Free Training
[vc_row row_type="row" use_row_as_full_screen_section="no" type="full_width" oblique_section="no" text_align="left" css_animation="" box_shadow_on_row="no"][vc_column][vc_column_text]If you've ever used Excel, then you've probably experienced the agony of choosing an incorrect formula to analyze a data set. Maybe you worked on it for hours, finally giving up because the data output was wrong or,...
Read More
How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel
Posted on
December 20, 2018
Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve...
Read More
How to do IF and nested IF functions in Excel
Posted on
December 20, 2018
The IF function is one of the most useful you will ever learn in Microsoft Excel. It's also incredibly simple and can unlock some seriously juicy functionality when you start nesting IF statements. In this post, we’ll show you how to do an IF and a...
Read More
PivotTables in Excel – The Basics
Posted on
December 20, 2018
PivotTable or pivot table. You may have heard of them… In our opinion, they are one of the MOST powerful things you can learn in Excel. The great news is, they are pretty easy to get the hang of. Before PivotTables were introduced into Excel, you had...
Read More
Restricting Cell Contents in Excel Using Data Validation
Posted on
December 20, 2018
Did you know that you can restrict, give guidance on and create drop-down lists for what you can enter in a certain cell in Excel? It’s a pretty cool feature and it’s called Data Validation. However carefully you design your spreadsheets, even if you lock cells...
Read More
Top 5 Under-Appreciated Excel Functions
Posted on
December 13, 2018
They say you never forget your first time. It’s true. My first experience of Microsoft Excel is burned forever into my mind. I was in my first graduate job, fresh from a humanities degree. I’d written plenty of essays, but few of these required any...
Read More
The Top 10 Excel Features
Posted on
November 20, 2017
in Excel, Free Training
[vc_row row_type="row" use_row_as_full_screen_section="no" type="full_width" oblique_section="no" text_align="left" css_animation="" box_shadow_on_row="no"][vc_column][vc_column_text] Every Excel user has a favourite tip. So we decided to bring some method, data, and science to bear in this hotly debated topic, and to come up with the Top 10 Excel Features. We consulted the research of 30...
Read More
20 principles all Excel users should follow. Do you?
Posted on
August 14, 2017
It’s time to sharpen those spreadsheets with this nifty guide – and the best part? It’s totally FREE! Ensure your spreadsheets are up to scratch with these twenty principles. Put together by the Institute of Chartered Accountants in England and Wales (the ICAEW) and written by 17 Excel...
Read More- 1
- 2