Core Course Topics:

1. Excel 365 Essentials:

• Mastering key Excel skills for working efficiently with worksheets.
• Logical, reference, and statistical functions explained and applied.

2. Working with Dates and Times:

• Practical use of date and time functions in daily operations, HR systems, and beyond.

3. Data Cleaning and Analysis:

• Leveraging Pivot Tables for efficient data analysis.
• Utilizing Power Pivot and Power Query to manage and analyze large datasets.

4. File Integration and Data Processing:

• Techniques for merging data from multiple sources and dynamic formatting.

5. Artificial Intelligence in Excel 365:

• Exploring the latest AI features and how to integrate them into your Excel workflows.

6. Basic and Advanced Data Visualization:

• Building standard and advanced charts.
• Creating visualizations using Python within Excel.

7. Basic and Advanced Conditional Formatting:

• Direct formatting and advanced rule-based formatting using formulas.

8. Modern Capabilities of Excel 365:

• Mastering powerful new functions in Excel 365 to achieve more with less effort.

9. Introduction to Python Programming in Excel:

• Embedding Python code in Excel cells and integrating with Power Query for advanced analytics.

10. Text Data Processing in Excel:

• Cleaning, formatting, matching, and managing text data effectively for financial reports, HR, and more.

11. Forecasting with Historical Data:

• Generating future insights and projections based on past trends.

12. Mastering What-If Analysis Tools:

• Scenario Manager, Goal Seek, and Data Tables for decision modeling and planning.

13. Problem Solving with Solver:

• Using Solver to tackle complex business problems and optimize outcomes.

Practical Applications Across Departments:

Sales Department Applications:

• Creating professional sales dashboards, performance analysis, and commission calculations using Pivot Tables, Power Pivot, and Query tools.
• Applying logical and statistical functions to understand sales trends.

Human Resources & Attendance Applications:

• Managing and analyzing work hours, overtime calculations, and employee attendance.
• Utilizing advanced functions for efficient HR data processing.

Finance & Budgeting Applications:

• Working with time value of money, financial facilities, and investments.
• Using forecasting and target-based functions to simulate financial scenarios and generate reports.

Training Details:

• Total Duration: 20 training hours
• Delivery Mode: Live via Zoom
• Total Cost: $97 per participant

Additional Notes:

• All course materials will be provided.
• The training is hands-on and example-driven to ensure engagement and understanding.
• Each topic covers multiple essential skills applicable in real-world contexts.

Instructor: Ms. Soad Jodallah