If you regularly need to summarize and prepare reports using Excel data, this report gives you the techniques you need from initial data cleansing to getting your chart into a PowerPoint presentation. It also covers automating your work. Learn why clean data is the solution to a lot of problems. Learn about how to set up pivot tables, add pivot charts and slicers and add colour to highlight unusual entries. Learn how to get your chart into PowerPoint and keep it updated.
About the Author
Anne Walsh is a freelance trainer (since the mid-90s) aka as The Excel Lady. She got this name when people would look at her and say, “you, you’re the Excel Lady!” She saw her first spreadsheet in the early 1990s and has been intrigued by them ever since, even though they only came in green or orange. She likes to say she puts the “fun in functions” and is excited by the potential of Power Query