Type and hit enter to Search
×

MS word + Excel + PPT in 3 days

  • 4.6(5,676 Rating)

Course Overview

The MS Word, Excel, and PowerPoint course is designed to provide comprehensive training in Microsoft Office applications over a span of three days. This course will cover the essential features and functionalities of MS Word, Excel, and PowerPoint, equipping participants with the skills needed to efficiently use these tools for various professional tasks. Participants will start with MS Word, learning how to create, format, and edit documents, insert tables and graphics, and utilize advanced features like mail merge and templates. The course will then move on to Excel, where participants will gain expertise in creating and managing spreadsheets, using formulas and functions, creating charts, and performing data analysis. Finally, the course will cover PowerPoint, teaching participants how to design and deliver effective presentations, including using animations, transitions, and multimedia elements. By the end of this intensive three-day training, participants will have a solid understanding of how to use these Microsoft Office applications to enhance productivity and create professional documents, spreadsheets, and presentations.

Schedule Dates

MS word + Excel + PPT in 3 days
23 September 2024 - 25 September 2024
MS word + Excel + PPT in 3 days
23 December 2024 - 25 December 2024
MS word + Excel + PPT in 3 days
24 March 2025 - 26 March 2025
MS word + Excel + PPT in 3 days
24 June 2025 - 26 June 2025

Course Content

  • Introduction to Microsoft Excel and its interface
  • Navigating worksheets and workbooks
  • Understanding formulas and functions
  • Basic arithmetic and logical functions

  • View Animation Chart
  • Add a Chart to an Excel Spreadsheet
  • Add, Remove and Format Gridlines
  • Apply a Chart Layout, Chart Style
  • Change the Axis Scale
  • Format the Data Series
  • Moving a Chart to Another Sheet
  • Creating combination charts
  • Use a Secondary Axis
  • Change Data Series Chart Types
  • Create, Customize, Remove Sparkline

  • Working with general & advance function
  • Writing conditional expressions
  • Using Nested IF & Limitations of IF
  • Using logical functions inside IF & Using Date & Time function in IF

  • Creating subtotals & Multiple-level subtotals
  • Creating , Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Create a standalone Pivot Chart
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources

  • ntroduction to Microsoft Word and its interface
  • Document creation and formatting
  • Working with styles and themes

  • Getting started with Microsoft PowerPoint
  • Inserting and formatting text boxes and shapes
  • Adding animations and transitions to slides
  • Slide master and template customization.
  • Advanced PowerPoint features: SmartArt, charts, and multimedia

FAQs

This course is ideal for anyone looking to improve their proficiency in Microsoft Office applications, including professionals, students, and individuals seeking to enhance their productivity.

In the Excel module, you will learn to create and manage spreadsheets, use formulas and functions, create charts, and perform data analysis.

No prior experience is necessary. The course is designed to accommodate beginners as well as those looking to refresh their skills.

Participants will need access to a computer with the latest versions of MS Word, Excel, and PowerPoint installed. Course materials and additional resources will be provided by the instructor.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?