Microsoft Excel – Basic Intermediate Level
Welcome to the MS Excel Basic and Intermediate Level Training! Over the next two days, you will develop essential skills to enhance your productivity and streamline your workflow in Microsoft Excel. On Day 1, we will build a strong foundation by exploring the Excel interface, managing workbooks and worksheets, and learning how to enter, format, and manipulate data effectively. You will also gain proficiency in basic formulas and functions, essential for performing everyday calculations and data analysis tasks.
On Day 2, we will advance your skills by diving into complex formulas and functions, including logical and lookup functions, crucial for sophisticated data analysis. You will master data management techniques such as sorting, filtering, and validating data, and learn to create and customize advanced charts and PivotTables for powerful data visualization. By the end of this training, you will be equipped with both basic and intermediate Excel skills, ready to tackle a wide range of data-related challenges with confidence and efficiency.
1. Develop Proficiency in Basic Excel Functions and Data Management
2. Master Complex Formulas and Data Analysis Techniques
3. Create and Customize Advanced Data Visualizations
1. Head of department
2. Managers
3. IT department
4. HR personel
1. Slide presentations
2. In class hands on learning experience
3. Case study
DAY 1
• Module 1: Introduction to Excel
• Module 2: Basic Worksheet Management
• Module 3: Basic Formulas and Functions
• Module 4: Basic Data Management
• Module 5: Basic Chart Creation
DAY 2
• Module 6: Advanced Formulas and Functions
• Module 7: Data Analysis Tools
• Module 8: Pivot Table
• Module 9: Data Validation and Protection
