Excel Course

Excel Course at VSIT Dwarka covers basic understating for working with excel. This Excel Training focus on beginners level, working with workbook and worksheets, calculation, chart, fundamental of excel formula and formatting in Excel.

Excel for Beginners

Excel Basics
  • Uses of Excel
  • Basics of Workbook and Worksheet
  • Create New Excel Workbook
  • Introduction of Rows and Columns
  • Know about Cell and Cell Address
  • Formet Cell
  • User Interface
  • Ribbon
  • Status Bar
  • Save Workbook
  • Share Workbook
  • open existing workbook
  • View multiple Workbooks
  • Close Workbook
More About Excel Workbook and Worksheets
  • Select a Worksheet
  • Insert a Worksheet
  • Resname a Worksheet
  • Move a Worksheet
  • Delete a Worksheet
  • Copy a Worksheet
  • Zoom and Split a Worksheet
  • Protect Worksheet
Cell Formatting and working with Cells
  • Entering Data
  • Show or Remove Decimal Places
  • Date and Time formats
  • Text to Numbers
  • Custom Cell Format
  • Cell Insertion and deletion
  • Aligning Cell data
  • Wrap Text
  • Merge Cells
  • Cell Styles
  • Cut,Copy and Paste
  • Paste Special
  • Format Painter
  • Transpose of data
  • Modify Row Height and Column Width
  • Work with Keyboard Shortcuts
  • Apply Workbook themes
Text Formatting
  • Apply latest fonts
  • Use Different font sizes
  • Bold text effect
  • Italic text effect
  • Underline text effect
  • Superscript and Subscript effect
  • Show unused data using strikethrough effect
  • Apply Different colors on data
  • Working with attractive background colors
  • Aligning data
  • Wrap text
Creating and Inserting objects in Excel sheet
  • Inserting Pictures
  • Creating Hyperlinks
  • Creating Drawing Object on Worksheet
  • Inserting Equations
Excel Formulas and Functions
  • Overview of Arithmetic Functions
  • Overview of Date and Time Functions
  • Overview of Text Functions
Arithmetic Functions
  • Sum, ABS & INT Functions
  • EVEN & ODD Functions
  • FACT & SQRT Functions
  • MOD Function
Date and Time Functions
  • Today & Now Function
  • Date & Time Function
Text Functions
  • Left, Right Function
  • Len & Exact Function
  • Lower, Upper & Proper Function
  • Concatenate Function
Statistical Functions
  • AVERAGE Function
  • COUNT Function
  • FINDING MINIMUM AND MAXIMUM
Assignments
  • Prepare Monthly Budget
  • Calculate Net Salary and prepare Salary Slip
  • Prepare Report Card