Analyzing Large Datasets with Power Pivot in Microsoft Excel
The context for Power Pivot...
Read MoreThe context for Power Pivot...
Read More[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[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[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 MoreMicrosoft 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 MoreSay 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 MoreThe 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 MorePivotTable 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 MoreDid 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 MoreThey 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