Microsoft office

Tally courses in coimbatore

Overview:

Our most popular course. This will build on your current Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing. Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.

Duration:8-12 Hours

Course Content:

  • The Excel Screen • Moving About the Workbook • Simple Data Entry • Selecting Ranges • Saving Workbook Formats
  • Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets
  • Overwriting/Editing Cell Contents • Editing Formulae/Functions • Using Undo/Redo • Search & Replace
  • Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns
  • Copying/Moving/Renaming Worksheet(s) • Inserting/Deleting/Grouping Worksheets • Hiding & Unhiding Worksheets
  • Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
  • Formatting Numbers/Dates/Currency • Formatting for Effect Bolding/ Italics/ Underling • Cell/Background Colours • Cell Alignment
  • Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
  • Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
  • Simple Printing/Previewing • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Custom views