Microsoft excel class in pune at cncwebworld

Microsoft Excel Training


Module 1: Getting Started
Understanding the Excel screen
Navigating in a spreadsheet
Understanding worksheets, columns, rows and cells
Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet
Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers
Clearing formats
Applying borders to cells
Merging cells

Module 3: Formulas and Functions
Entering formulas
Copying data and formulas
Using AutoSum
Understanding functions
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Copying formulas
Types of cell referencing: relative and absolute
Applying conditions in a formula (The IF function)
Working with ranges

Module 4: Editing Features
Using cut , copy, and paste operations
Using paste special with values
Selection techniques

Navigation techniques

Module 5: Working with Large Worksheets
Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing

Module 6: Working with Charts
Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts

Module 7: Previewing and Printing
Previewing worksheets
Page setup
Printing of worksheets in multiple pages
Repeating rows and columns for multiple pages

Printing multiple worksheets

Module 8: Simple Database Operations
Sorting tables
Filtering data with auto filter
Generating subtotal reports
Creating pivot tables
Referring data from other worksheets



For more detail feel free to contact us any time
cncwebworld
Office address: C-2 Building, office No.21
Brahma Estate, kondhwa Road, NIBM Junction
Landmark:- Jyoti Restuarant
Mobile number:9175371080/81
Phone number:02041207557
email:[email protected]