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
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
What’s New in Microsoft Office 2019?
Posted on
January 2, 2019
in Excel
Microsoft has been making a not so subtle attempt to push its 1.2 billion Office users towards Office 365 for some time. This has been mostly successful. Over 120 million people have active Office 365 accounts and adoption is up 34% since 2016 and now...
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