Course Overview
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.