Advanced Course on Microsoft Excel and PowerPoint with Story Telling

Enroll Now
  • Duration: 30 Hours
  • Module: 16 Modules
  • Platform: Online

COURSE OVERIVEW

  • In today's fast-paced business environment, proficiency in Microsoft Excel and PowerPoint is crucial for professionals across various industries. The Advanced Microsoft Excel and PowerPoint Mastery Course aim to empower individuals with the skills and knowledge required to leverage the advanced features of these applications for efficient data analysis, visualization, and impactful presentations.
  • This online advanced course is designed to enhance your proficiency in Microsoft Excel and PowerPoint. The course is divided into two main sections, each focusing on advanced techniques, features, and best practices. Participants will gain hands-on experience through practical exercises and real-world scenarios.
Course Benefits
  • Hands-on learning with up to Date Projects.
  • Official Microsoft Material and Additional Self Study Resources.
  • Certified Instructors.
  • Assignment and Project Evaluation.
  • Certificate.

COURSE OUTLINE

Microsoft Excel

  1. Learning different types of cell references (relative, absolute, mixed)
  2. Basic formulas (e.g., SUM, AVERAGE, COUNT)
  3. Mathematical operators and order of operations
  • AutoSum and quick functions
  • IF statements for basic logical operations
  • Using functions like MIN, MAX, COUNTIF, and SUMIF
  1. Nested function
  2. Array formulas
  3. Lookup and reference functions (e.g., VLOOKUP, HLOOKUP, INDEX, MATCH)
  4. Logical functions (e.g., IF, AND, OR)
  5. Text functions (e.g., CONCATENATE, MID, LEFT, RIGHT)
    1. Creating and working with Excel tables
    2. Using PivotTables for data summarization
    3. Data consolidation techniques
  1. Advanced PivotTable techniques
  2. Goal Seek, Scenario Manager, and Solver
    1. Importing and transforming data with Power Query
    2. Data modeling with Power Pivot
    3. Relationships and DAX formulas
    1. Combination charts
    2. Dynamic charts
    3. Waterfall charts
    4. Sparklines
  1. Recording and editing macros
  2. Automation of repetitive tasks

Microsoft PowerPoint

  1. Understanding and utilizing master slides for consistent formatting.
  2. Customizing slide layouts and master slide elements.
  1. Advanced animation techniques for objects and text.
  2. Creating custom animations and motion paths.
  3. Using transitions effectively for seamless slide transitions.
  1. Working with advanced formatting options for text boxes, shapes, and images.
  2. Using advanced alignment and distribution options.
  3. Customizing color schemes and creating custom color palettes.
    1. Creating and customizing complex SmartArt diagrams.
    2. Advanced chart customization and data linking.
    3. Incorporating Excel data into PowerPoint charts.
  1. Embedding and linking audio and video files.
  2. Customizing video playback options.
  3. Integrating online content, such as YouTube videos.
    1. Creating and using custom templates.
    2. Customizing the ribbon and creating macros for automation.
    3. Utilizing PowerPoint add-ins for extended functionality.
    1. Incorporating advanced data visualization techniques.
    2. Creating infographics within PowerPoint.
  1. Using Presenter View for more control during presentations.
  2. Incorporating speaker notes effectively.
  3. Setting up and using multiple monitors.
  4. Presenting like as Story Tellling

COURSE PREREQUISITES

  • Basic Knowledge of Microsoft Excel and PowerPoint.
  • Comfortable with Basic Formulas and Functions.
  • Basic Data Analysis Skills'
  • Desire to Learn and Practice

WHY THIS COURSE?

  • Gain a competitive edge in the job market by acquiring advanced skills in Microsoft Excel and PowerPoint.
  • Enhance your resume with proficiency in tools widely used across various industries.
  • Learn advanced features and techniques that will significantly reduce the time spent on data analysis, reporting, and presentation creation.
  • Streamline workflows and increase efficiency in daily tasks.
  • Master advanced PowerPoint features to create visually appealing and impactful presentations.
  • Impress your audience with polished designs, custom animations, and multimedia integration.

WHY CHOOSE ICDB

Experience

We have been in the market since 2016, and we kept accumulating experience in the training business, and providing training for more than 20,000 trainees ever since, in Bangladesh & India.

Premium Facilities

ICDB facilities are well-equipped with strong hardware and software technologies that aid both students and trainers lead very effective smooth training programs.

Customer Support

We provide our clients with the best solutions, customized to their specific needs and goals. Our team is highly qualified to answer whatever questions you have.

Global Accredited

ICDB is an authorized and accredited partner by technology leaders. This means that our training programs are of the highest quality source materials.

Up To Date

We keep tabs on every change in the market and the technology field, so our training programs will always be updated up to the World-class latest standards, and adapted to the global shape-shifting job market.

Certified Instructors

We select the best instructors, who are certified from trustworthy international vendors. They share their professional experience with the Trainees, so they can have a clear hands-on experience.

Our Strategic Clients