MS Excel – Basic & Intermediate

Learn to use Excel with basic functions and formulas of excel

OUTLINE OF COURSE CONTENTS

Excel Basics

  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook

Formatting a Worksheet

  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page
  • Formatting Fonts & Values
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit Using AutoFill

Managing your workbooks

  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options

Editing a workbook

  • Entering Date Values and using AutoComplete Editing, Clearing, and Replacing Cell Contents Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling
  • Finding and Replacing Information Inserting Cell Comments

Formula's

  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges

Working with the Forms Menu

  • Sorting, Subtotal & Filtering Data
  • Copy & Paste Filtered Records
  • Using Data Validation

Creating & Working with Charts

  • Creating a Chart
  • Moving and Resizing a Chart
  • Formatting and Editing Objects in a Chart
  • Changing a Chart’s Source Data
  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects Mapping Data
  • Modifying a Map

Data Analysis & Pivot Tables

  • Creating a PivotTable
  • Specifying the Data a PivotTable Analyzes
  • Changing a PivotTable Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable
  • Updating a PivotTable
  • Formatting and Charting a PivotTable

Testimonials

  • My objective of attending training was met. The trainer was above far experienced

    Thariq Ahmed K P AMB INDIA PVT LTD
  • A good trainer. Presentation skill & confidence level is good. Course material is good!

    Piyush Dhani ORACLE
  • Trainer was very good with the examples that he gave to improve & understand the concepts better.

    Prabhakar Cirivn MICROSOFT
  • Trainer is confident, cool & well organized!

    M Ashok TECH MAHINDRA
Get in Touch

Send us an email and we'll get back to you, asap.

Not readable? Change text.
0