Microsoft Excel Intermediate

Course Title: Microsoft Excel Intermediate

---

Course Duration: 8 hours (split into 2-hour sessions)

---

Course Description:

Build on your foundational knowledge of Microsoft Excel and elevate your spreadsheet skills to the next level with this Intermediate course. Whether you’re seeking to enhance your efficiency at work, improve data analysis techniques, or simply gain a deeper understanding of this powerful tool, this course provides hands-on exercises and in-depth instruction to achieve proficiency in intermediate Excel concepts.

---

Course Objectives:

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

1. Navigate Excel with increased efficiency.
2. Create, design, and format advanced charts and graphs.
3. Use complex functions and formulas to manipulate data.
4. Utilize data validation and conditional formatting techniques.
5. Understand and apply intermediate-level features such as PivotTables and PivotCharts.
6. Protect and secure their Excel workbooks and worksheets.
7. Integrate Excel with other tools and platforms.

---

Course Outline:

1. Advanced Formula Techniques
   • Relative vs. Absolute References
   • Nested Functions
   • Array Formulas
   • Name Ranges and Cells
2. Charting and Visualization
   • Advanced Chart Types and Customization
   • Trendlines and Data Analysis Tools
   • Conditional Formatting Advanced Options
3. Working with Data
   • Data Sorting and Filtering
   • Data Validation Techniques
   • Introduction to VLOOKUP, HLOOKUP, and INDEX/MATCH functions
4. PivotTables and PivotCharts
   • Building and Customizing PivotTables
   • Slicers and Timelines
   • Designing PivotCharts
5. Data Tools and Security
   • Using ‘What-if’ Analysis Tools: Goal Seek, Data Tables, and Scenario Manager
   • Workbook and Worksheet Protection
   • Track and Review Changes
6. Integrating Excel
   • Importing and Exporting Data
   • Linking and Embedding Data from Other Sources
   • Introduction to Power Query

---

Course Prerequisites:

Before attending this course, participants should have:

• Completed a basic Excel course or have equivalent experience.
• Familiarity with creating simple formulas, basic charts, and formatting cells.

---

Target Audience:

This course is designed for individuals who have foundational knowledge of Microsoft Excel and are looking to enhance their skills for professional development, more efficient data management, and advanced data analysis.