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
The Definitive 100 Most Useful Excel Tips
Posted on
January 7, 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 is still the world's favourite business software. 750 million knowledge workers use it for at least half an hour every single working day, and Microsoft CEO Sadya Nadella believes it's still the most important Microsoft software. So...
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
3 Steps to Create Powerful Presentations with Excel
There are simple things you can do in Microsoft Excel that can hugely impact your presentation style and help you create powerful presentations. These 3 Excel tips are easy to implement regardless of whether you are a beginner, intermediate or advanced Microsoft Excel user. [vc_empty_space height="20px" image_repeat="no-repeat"][vc_column_text] 1. Be consistent Make spreadsheets...
Read More
The Definitive 100 Most Useful Excel Tips
Posted on
October 20, 2017
[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 is still the world's favourite business software. 250 million knowledge workers use it for at least half an hour every single working day. As we've sold half a million Excel courses ourselves, we have a lot of data...
Read More