Course Overview
Schedule Dates
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.
Flexible Training Options to Meet Your Needs
We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.
Select the method that best suits your needs.
