About this Course

Microsoft Excel is a software program produced by Microsoft Corp. that allow users to organize, format and calculate data with formulas using a spreadsheet system. This software as part of the Microsoft office suite and is compatible with other applications in the office suite.

COURSE CONTENT :

Module 1: Introduction to Excel

♦ Introduction to Excel interface

♦ Understanding rows and columns, Naming Cells

♦ Working with excel workbook and sheets

Module 2: Formatting excel work book

♦ New, Open, Close, Save, Save As

♦ Formatting Text: Font Size, Font Style

♦ Font Color, Use the Bold, Italic, and Underline

♦ Wrap text, Merge and Centre

♦ Currency, Accounting and other formats

♦ Modifying Columns, Rows, & Cells

Module 3: Perform Calculations with Functions

♦ Creating Simple Formulas

♦ Setting up your own formula

♦ Date and Time Functions, Financial Functions

♦ Logical Functions

♦ Lookup(V-Lookup and H-Lookup) and Reference Functions

♦ Mathematical Functions

♦ Statistical Functions, Text Functions

♦ Working with Templates

Module 4: Managing Tables

♦ Creating Tables

♦ Naming the Table

♦ Changing the Table Style

♦ Creating a Total Row

♦ Creating a calculated column

♦ Using Filtering in Table

♦ Removing the Duplicate Record

Module 5: Sort and Filter Data with Excel

♦ Sort and filtering data

♦ Using number filter, Text filter

♦ Custom filtering

♦ Removing filters from columns

♦ Conditional formating

Module 6: Create Effective Charts to Present Data Visually

♦ Inserting Column, Pie chart etc.

♦ Create an effective chart with Chart Tool

♦ Design, Format, and Layout options

♦ Adding chart title

♦ Changing layouts

♦ Chart styles

♦ Editing chart data range

♦ Editing data series

♦ Changing chart

♦ Saving chart as template

♦ Summarizing data using spark line

Module 7: Analyze Data Using Pivot Tables and Pivot Charts

♦ Understand PivotTables, Create a PivotTable

♦ Framework Using the PivotTable and PivotChart

♦ Create Pivot Chart from pivot Table

♦ Inserting slicer

♦ Creating Calculated fields

Module 8: Protecting and Sharing the work book

♦ Protecting a workbook with a password

♦ Allow user to edit ranges

♦ Track changes

♦ Working with Comments

♦ Insert Excel Objects and Charts in Word Document and Power point Presentation

Module 9: Use Macros to Automate Tasks

♦ Creating and Recording Macros

♦ Assigning Macros to the work sheets

♦ Saving Macro enabled workbook.

Module 10: proofing and Printing

♦ Page setup, Setting print area, Print titles

♦ Inserting custom Header and Footer

♦ Inserting objects in the header and footer

♦ Page Setup, Setting margins, Print Preview, Print

♦ Enable back ground error checking

♦ Setting AutoCorrect Options

♦ Remove the appropriate check marks to disable any unwanted features

Duration : 15 hrs

Entry Requirement : Beginner of Computer

Rate this course:

Log in to submit

Comments