Welcome to Waytoacme
Courses Images

Course Details

Microsoft Excel is a spreadsheet program included in Microsoft Office suite of applications. Spreadsheets will provide you with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations.

In addition to the standard spreadsheet features, Excel offers programming support via Microsoft's Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE). Microsoft Excel is an Electronic Spreadsheet Computer Program.

Course contents

  • Electronic Spreadsheet Concept
  • Relative & Absolute Reference, Date & Currency Formatting
  • Formatting Fonts, Numbers, Auto-Format
  • Formula charts & Graphs, 2D/3D Graphs, – Pie, Line Cone,Formatting Charts
  • Pivot tables and charts
  • Password Protecting Worksheets,Linking Multiple Sheets
  • Intro. to MACRO’s, Nested If’s, Sheet Referencing.
  • Concept of advance filter
  • Formulas in excel
  • Changing numbers into words
  • Data Values, Sub Total Reports, Auto Filters,
  • Goal seek and scenerio manager functions