Overview

Modules Introduction Case Study 1. Sales Data Analysis Using Pivot Tables, charts, and advanced functions to analyse sales performance Case Study 2. Financial Forecasting Using financial functions and data visualisation for forecasting future financial performance Case Study 3. Inventory Management Using lookup functions, conditional formatting, and data validation to manage inventory dataConclusion and Certification Review of key concepts and functions Final project. Comprehensive task incorporating various learned elements Certification of completionCertification of CompletionUpon successful completion of the final project and the course, students will receive a certificate of completion. This certificate will serve as a testament to their proficiency in using Microsoft Excel, covering both basic and advanced formulas and functions. It will be a valuable addition to their professional portfolio, enhancing their resume and career prospects. Additional ResourcesRecommended Reading and TutorialsTo support ongoing learning and skill enhancement, the course will provide a list of recommended reading materials and tutorials, including:Books. Titles on Excel basics, advanced functions, data analysis, and VBA programming. Online Tutorials: Links to high-quality video tutorials, blogs, and articles that cover various aspects of Excel usaOnline Forums and Communities for Excel UsersStudents will be encouraged to join online forums and communities where they can engage with other Excel users, seek advice, share knowledge, and stay updated on new features and best practices. Recommended communities include: Microsoft Excel Community: The official community hosted by Microsoft.Reddit's r.excel. A popular subreddit for discussing Excel-related topics. Excel Forums: Various forums where users can post questions and get answers from expertPractice Workbooks and Additional ExercisesTo further reinforce learning, students will have access to a variety of practice workbooks and additional exercises. These resources will provide opportunities to: Apply Concepts. Work through practical problems and scenarios to solidify understanding.Experiment with Functions: Explore new and complex functions in a guided manner. Challenge Skills. Take on challenging exercises that push the boundaries of their Excel knowledge.

Skills

Reviews