Zurich, Switzerland: +41 - 43 434 80 33 | US: (510) 954-3145 | support@traininng.com
Instructor
Melissa Esquibel
In this session, you'll go beyond sums and averages and learn how to use advanced formulas to take the data you get and turn it into what you need. There are nearly 500 native functions in Excel. And while we won't have the time to cover all 500, we will cover essential ones like IF, VLookUp, XLookUp, SumIF, SumIFs and more. You'll learn the all important text functions that can help you tackle problems like poorly formatted date and time data, leading and trailing spaces, and miscapitalization.
We'll look at alternatives to formulas to summarize information as well as effective was to create charts, graphs and other visuals such as conditional formatting to help you convey what you need to about your data. There are easier and faster ways to create charts in Excel than ever before and new tools to create charts and graphs on maps for data you need to present geographically.
Finally, well cover how formulas work in and with Pivot Tables and how to apply formulas in PowerQuery. Not only will you know how to get the most out of Excel, but know all the different ways to do it and when to use what.
Do your Excel skills leave you unsure about your ability to collect, analyze and report data effectively? Do you wish you understood how others are coming up with the numbers that you are relying on for important business decisions. Knowing how to really use the power of Microsoft Excel can give you the skills and confidence to wrangle large amounts of data and share it with others in ways they can consume and understand.
You might be competent in arranging data in spreadsheets and performing basic calculations. But that's not enough anymore. Understanding how to use Excel's more advanced functions and nested formulas can enable you to do the kind of analysis you really need. More importantly, sharing information in charts, graphs and with other visualization features can ensure that others understand and make use of your hard work. Becoming the go to person in your organization for Excel advanced features can really set you apart among your peers.