NEW Microsoft Office – Ahmed Marsia, 6 sessions

Shape Image One
  1. May 12th, 2024

    Introduction to Excel and Basic Operations

    Learn to navigate the Excel interface and master data entry, copying, pasting, formatting, and manipulating rows and columns. Get introduced to basic formulas and functions (SUM, AVERAGE, MAX, MIN, COUNT, SUBTOTAL, TODAY) and explore page layout, printing, and saving options.

  2. May 19th, 2024

    Intermediate Excel Techniques – Level 1

    Explore lookup functions (VLOOKUP, HLOOKUP, XLOOKUP) and text functions (LEFT, RIGHT, CONCATENATE). This session also covers data validation, protection, conditional formatting, and sorting, with practical examples and Q&A on applying these formulas to large data sets.

  3. May 26th, 2024

    Intermediate Excel Techniques – Level 2

    Dive into advanced logic functions (IF, IFS, SUMIF, SUMIFS, COUNTIFS) and advanced formulas (INDEX and MATCH, UNIQUE). Learn how to apply these formulas to large data sets for more complex data analysis and problem-solving.

  4. June 2nd, 2024

    Data Analysis Techniques

    Get introduced to PivotTables and Pivot Charts, including data preparation using Get Data. Learn to create and analyze PivotTables, use Goal Seek for optimization, group/ungroup data, and build interactive dashboards. This session also covers creating feasibility reports for business analysis.

  5. June 9th, 2024

    Microsoft Word

    Start with the basics of Microsoft Word and progress to advanced formatting techniques. This session includes document review, customization, and collaboration, drafting letters, and building resumes, including resume creation using LinkedIn.

  6. June 16th, 2024

    Power Point

    Learn to create and format professional presentations in PowerPoint. This session covers designing effective slide layouts and transitions, along with presentation delivery techniques and tips for engaging an audience effectively.

Optimized by Optimole
WhatsApp whatsapp
Messenger messenger
Instagram instagram
Call Us phone
chat