Excel Training

If you are one of the person who face lot of issues with spreadsheets, tables, charts or graphs, functions and many more in your daily life and you spend hell lot of time for the same.

MS Excel can solve all your problems which is the the most widely used spreadsheet application and very powerful tool for every office work. You can even use Excel to send thousands of emails in 30 seconds and many people are not even aware of it. So you can save lot of time as well.

Excel Training course will cover all the aspects regarding Excel, right from creating a workbook, formatting, using formulae, customizing stuffs, vlookup, hlookup, etc. We offer two different training for Excel, one is Basic Excel Training and Advance Excel Training.

Join our Basic Excel Training in Pune or Advance Excel Training in Pune. We conduct Advance Excel Training for corporates too. All our trainers have 10+ years of experience and are from working background.

Basic Excel Training Syllabus

  1. The Beginning
    • 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
  2. 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
  3. Managing your workbooks
    • Switching Between Sheets in a Workbook
    • Inserting and Deleting Worksheets
    • Renaming and Moving Worksheets
    • Hiding Columns, Rows and Sheets
    • Splitting and Freezing a Window
    • Inserting Page Breaks
    • Advanced Printing Options
  4. 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
  5. Formulas
    • Creating a basic Formula
    • Calculating Value Totals with AutoSum
    • Editing & Copying Formulas
    • Fixing Errors in Your Formulas
    • Formulas with Several Operators and Cell Ranges
  6. Working with the Forms Menu
    • Sorting, Subtotaling & Filtering Data
    • Copy & Paste Filtered Records
    • Using Data Validation
  7. 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
  8. Assignments

Advance Excel Training Syllabus

  1. Introduction to MS Excel and Understanding Basic Working with it
    • Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
    • Difference between Excel 2003, 2007, 2010 and 2013
    • Saving Excel File as PDF, CSV and Older versions
    • Using Excel Shortcuts with Full List of Shortcuts
    • Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
    • Using Paste Special Options
    • Formatting Cells, Rows, Columns and Sheets
    • Page Layout and Printer Properties
    • Inserting Pictures and other objects in Worksheets
  2. Working with Formulas/Functions
    • Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE, etc.
    • Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE, etc.
    • Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, etc.
    • Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR,  YEARFRAC, TIME, WEEKDAY, WORKDAY, etc.
    • Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE, etc.
    • Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS, etc.
    • Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, FORECAST, MAX, MAXA,MIN, MINA, STDEVA, etc.
    • Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR, etc
  3. Conditional Formatting
    • Using Conditional Formatting
    • Using Conditional Formatting with Multiple Cell Rules
    • Using Color Scales and Icon Sets in Conditional Formatting
    • Creating New Rules and Managing Existing Rules
  4. Data Sorting and Filtering
    • Sorting Data A-Z and Z-A
    • Using Filters to Sort Data
    • Advance Filtering Options
  5. Pivot Tables
    • Creating Pivot Tables
    • Using Pivot Table Options
    • Changing and Updating Data Range
    • Formatting Pivot Table and Making Dynamic Pivot Tables
  6. Pivot Charts
    • Creating Pivot Charts
    • Types of Pivot Charts and Their Usage
    • Formatting Pivot Charts and Making Dynamic Pivot Charts
  7. Macro
    • Introduction to Macro
    • Recording Macro
    • Assigning a Macro a shortcut key
    • Adding Macro to Toolbar
  8. Working with other programs
    • Inserting an Excel Worksheet into a Word Document
    • Modifying an Inserted Excel Worksheet
    • Inserting a Linked Excel Chart in a Word Document
    • Inserting a Graphic into a Worksheet
    • Sending e-mail to thousands in a go
    • Creating graphics in PPT using excel data
  9. Security
    • Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
    • Protecting workbook and data
  10. Assignments

Feel free to get in touch for the Training, Seminar, Workshop; just mail us on the connect@ancyber.com or call us 0n +91-9766-210-353, will contact you very soon.