Name: Microsoft Excel

Duration: 24Hrs (Generally done in 3 days)

Objectives: This course is designed to help individuals to learn Microsoft excel for all purpose, such as how to create a Tables, working with Excel formulas and Functions, and easily edit workbooks having multiple sheets for different purposes and situations, can work with basic & advance calculation, graphical tools, which is meant to for experienced Excel users who would like to gain expertise in creating reports. you would have ability to create and share the basic employee resource schedules, a basic accounting program for checkbook ledger, to track product sales on a daily, weekly, monthly or quarterly basis or Tracking the total Return on Investment etc.

Microsoft Excel is the best suited course for all students, Business Professionals, IT Professional, Finance Users, Accounting Professional or practitioner who are looking for a single introductory Excel-based resource that covers three essential business skills—Data Analysis, Business Modeling, and Simulation.

Prerequisites: Basic knowledge of computers and Microsoft Office.

Training Delivery medium: Classroom, Live Virtual, Instructor Led

Course Outline:

• Explore Microsoft Excel
• Changing Workbook Appearance
• Performing Calculations on Data
• Filter and sort data as per the need
• Combining Data from Multiple Sources
• Analyzing Alternative Data Sets
• Creating Dynamic Worksheet by Using PivotTables
• Creating Charts and Graphics
• Automating Repetitive Tasks by using Macros
• Working with Other Microsoft Office Programs
• Collaborating with Colleagues