Course details

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

  • 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

  • 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
Updated on 08 March, 2016

About G TEC Computer Education

we_they provides quality education in Information Technology. We focus on Programming Courses, Animation and Web Design Courses. We also provide Diploma and Post Graduate Diploma Courses.
we_they is division of Glosoft Technologies (P) Ltd, India. Glosoft is an Information Technology company in the field of Software Training, Technology resource and Knowledge Consulting. It provides solutions through application of proven platforms and adaptation of emerging technologies. Core to its offering is a solution through well documented software engineering practices, project management mile stones and quality assurance parameters for each stage of software training and development lifecycles.
See all G TEC Computer Education courses
Are you from G TEC Computer Education ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or