Learn Microsoft Excel 2013 - Advanced

Unlock the Full Potential of Excel: Advanced Data Functions Training

Take your Excel skills to the next level with this comprehensive 9-hour video training course. Designed for users already familiar with Microsoft Excel (2013 or previous versions), this course delves into advanced Excel data functions to help you analyze, report, and visualize data more effectively.

What You'll Learn:

• Personal & Professional Financial Functions: Master functions for financial planning, including payments, future value calculations, and depreciation analysis.
• Statistical Functions: Gain proficiency in essential statistical functions like averages, percentiles, and regression to identify trends and insights.
• Data Connectivity: Learn how to connect to external data sources, including other workbooks and web data, for comprehensive analysis.
• Tables, Charts & Pivots: Develop skills in creating and manipulating Excel tables, including styling, selection, and sizing. Become proficient with pivot tables for powerful data summarization and analysis.
• Data Analysis Techniques: Explore advanced data analysis methods to extract meaningful information from your spreadsheets.
• Data Visualization: Create compelling charts and graphs – including surface charts, stock charts, radar charts, and bubble charts – to effectively communicate your findings.
• Web Applications: Discover useful web applications to enhance your Excel workflow.

Course Highlights:

• 52 Engaging Lectures: Over 12.5 hours of video content delivered in a progressive, easy-to-follow format.
• Practical Examples & Exercises: Reinforce your learning with hands-on exercises and real-world examples.
• Updated Content: Updated July 2017 with English close captions for accessibility.
• Versatile Excel Skills: Apply your newfound knowledge to a wide range of reporting forms, including tables, graphs, and pivot tables.
• Improve Reporting: Showcase important analysis like depreciation, percentiles, and regression for strategic planning.

Benefits:

By the end of this course, you will be able to:

• Create visually appealing and informative Excel charts and databases.
• Efficiently communicate data and financial records.
• Apply data analysis techniques to improve decision-making.
• Become a more productive and confident Excel user.

What People Are Saying:

• "The overall course has a nice progressive layout and the presenter knows what he is teaching." - Eric Cobb
• "This course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly." - Vikram Hegde
• "Excellent course. The course is really detailed and displays very good examples and methods to use functions in Excel." - Hari Iyer
• "Even if the course is targeted at advanced Excel users, I think that it provides great value even for beginner ones." - Vlad Zamfirescu
• "This material is very easily laid out and relevant. I have obtained many tips that will help me to become much more productive in my Excel use." - Mark Carson