Excel is one of the most widely used solutions for analyzing and visualizing data. Excel in itself can do so much for your career. It's just one program but it's the one hiring managers are interested in. Advanced Microsoft Excel skills can get you a promotion and make you a rock star at your company. This course is concentrated on the most important tools for performing data analysis on the job. In this course you'll play the role of data analyst at a delivery company and you'll be working with real-life data sets. You don't need to spend weeks and months to learn Excel. As you go through the course, you'll be able to apply what you learnt immediately to your job.Very detailed, extremely well explained, useful information and tricks. You'll learn:

· How to clean and prepare data

· How to use drop-down lists in Excel and add Data Validation to the cells.

· How to best navigate large data and large spreadsheets.

· How to Protect your Excel files and worksheets properly

· The most useful Excel functions 

· How to write advanced Excel formulas