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.