Your cart is empty.
Keep shopping
Learn Microsoft Excel in easy and simple way
Learn Microsoft Excel in easy and simple way
Getting Started with Excel, Operations and Data Management, Excel Formulas and Functions, Data Analysis & Visualization
Created byMacAnthony Nwanebi
Last updated 5/2024
English
What you'll learn
- Introduction to Microsoft Excel Lesson 1.1: Getting Started with Excel. Lesson 1.2: Basic Operations and Data Management
- Basic Excel Formulas and Functions Lesson 2.1: Basic Formulas, Lesson 2.3: Text Functions
- Module 3: Advanced Excel Formulas and Functions Lesson 3.1: Lookup and Reference Functions
- Module 4: Data Analysis and Visualization Lesson 4.1: Pivot Tables, Lesson 4.1: Pivot Tables **1. Creating and Formatting Pivot Tables**
- Module 5: Automation and Efficiency Tools Lesson 5.1: Introduction to Macros, Lesson 5.1: Introduction to Macros **1. Recording and Running Macros**
- Module 6: Project and Case Studies, Lesson 6.1: Real-World Scenarios, Case Study 1: Sales Data Analysis
- . **Data Setup**: , **Using Lookup Functions**:, - **INDEX and MATCH**:, **Conditional Formatting**:, **Data Validation**:, Review of Key Concepts &Function
Explore related topics
Included in This Course
4 questions
Description
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 data
Conclusion and Certification
Review of key concepts and functions
Final project. Comprehensive task incorporating various learned elements
Certification of completion
Certification of Completion
Upon 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 Resources
Recommended Reading and Tutorials
To 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 Users
Students 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 Exercises
To 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.
Who this course is for:
- Computer enthusiast, software managers, Men, women, young people, secretaries, public, private sectors, Businesses, SME's