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 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 MoreThere 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[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