Power Pivot takes Pivot Tables and data analysis to the next level. If you're a fan of Pivot Tables, you'll love Power Pivot. It lets you quickly and easily create Pivot Tables from multiple data sets (no VLOOKUP required) and enables you to analyze your data in ways that you've never been able to do before thanks to some new Power Pivot functions (known as DAX functions). Power Pivot lets you work with datasets that span millions of rows.
Pivot Tables are one of the most powerful tools in Excel's data analysis armoury. With just a few clicks of the mouse (and no complicated formulas) you can quickly and easily build reports and charts that summarise and analyse large amounts of raw data and help you to spot trends and get answers to the important questions on which you base your key business decisions.
There is a saying,a picture is worth a thousand words.In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart or graph that interprets trends in a set of data, than to just look at a set of figures.
If you think that Excel is all about working with numbers then think again. More and more people are turning to Excel to help them to manage list-based and tabular data.In many cases they receive, download or import data from elsewhere and before that data can be used within their business and treated as a credible source of information, it needs be seriously checked and cleaned duplicate entries, non printing characters, extra spaces and capitalisation inconsistencies are all too often present in downloaded and imported data. In this session, you'll learn how to deal with and fix all these issues.
If you're like millions of other business professionals, you probably use Microsoft Outlook every day to manage your email, calendar and to do's. It's available for Windows, Mac, mobile and there's even a web version. So there's no excuse not to be organised. Or so the theory goes. The reality is email overload, missed deadlines and calendars so full you have no room to breathe
Using formulas turns Excel into the world's most powerful calculator. Whether you need to calculate loan repayments, generate a profit and loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you'll find that Excel is the best tool for the job.