Microsoft Excel is a spreadsheet software program developed by Microsoft named as Multiplan. MS Excel consist of Tabs, commands and Worksheets. This is one of the popular applications that belong to Microsoft Office Suite. This application is made to store and organize data.
Why MS Excel?
Developed to generate texts, numerals and formulas for doing calculations.
Accounting and budgeting is easier.
Have functions like SUM, TEXT, VLOOKUP, AVERAGE, COUNT, IF, CONCATENATE, TRIM, MIN and MAX, etc.to speed up the large calculations
What you will master?
Opening and applying multiple formats for spreadsheets at once.
Alternate keys menu for fast access.
Inserting pivot or recommend charts, row and columns in short span of time.
Some Sample Videos:
Class:1- Kicking off with MS Excel.
Class:2- Fundamentals - Naming cells, Rows, and Columns.
Class:3- Getting familiar with Excel Workbook.
Class:4 - Basics of Excel format (New, Open, Close, Save, Save As and more)
Class:5 - Basics of format (Font Size, Style, Color, and more)
Class: 6 - A little bit about formatting the workbook.
Class:7 - Basics of Calculation in Excel.
Class: 8 - Mathematics Fundamentals.
Class:9 - About setting up the Formulas.
Class: 10 - Understanding Functions (like Logical, Text, Statistical, Financial, Date and Time)
Class: 11 - Basics of Sort and Filter Data in Excel.
Class: 12 - Tutorial about filters and their types in excel.
Class: 13 - Overview of Conditional formatting.
Class: 14 - Basics of Creating Charts.
Class: 15 - Training on Chart tool.
Class: 16 - About Chart style and Layouts.
Class: 17 - Session on date range and date series.
Class: 18 - Basics of PivotTables.
Class: 19 - Tutorial on creating PivotTables.
Class: 20 - Inserting slicer and creating calculated fields tutorial.
Class:21 - How to protect the workbook with a password.
Class:22 - About track changes and edit ranges.
Class:23 - How to insert excel objects and charts in Word or PowerPoint.
Class:24 - Basics of macros and automate Tasks.
Class:25 - Tutorial on creating and recording macros
Class:26 - Basics of Proofing.
Class: 27 - How to enable background error checking.
Class: 28 - How to set up the AutoCorrect Options.
Class: 29 - Basics of Printing.
Class: 30 - Tutorial about setup and other things in Printing.
Schedule Your Classes
The duration of the Course is 30 days
Weekdays - Monday to Saturday.
Weekend classes - Saturday and Sunday.
Materials will be provided.
Please note that the Training Structure may vary for each and every student.
Have a Question?
Please send us any questions you may have. We would love to answer it.