Course Overview
- Course Title: Microsoft Excel: Formulas & Functions with Charts & Graphs
- Instructor: Click Learning
- Target Audience:
- Beginners with no prior Excel knowledge
- Intermediate users aiming to enhance their skills
- Experts looking to expand their knowledge
- Prerequisites: None
Curriculum Highlights
- Key Topics Covered:
- Introduction to Excel Formulas and Functions
- Advanced Formula Techniques
- Creating Dynamic Formulas
- Introduction to Excel Charts
- Enhancing Charts
- Linking Formulas with Charts
- Practical Applications and Real-World Examples
- Strategies for Efficient Data Analysis and Presentation
- Key Skills Learned:
- Working with logical functions (IF, AND, OR)
- Nesting functions for complex calculations
- Using VLOOKUP and HLOOKUP functions
- Understanding absolute and relative cell references
- Building formulas for dynamic data analysis
- Inserting and customizing charts
- Formatting chart elements
- Linking Excel formulas with chart data
- Analyzing sales data with formulas and charts
- Data visualization techniques for presentations and reports
Course Format
- Duration: 3 hours on-demand video
- Format: Self-paced online course
- Resources:
- Access on mobile and TV
- Certificate of completion