Become EXCEL Certified Professional
Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

Syllabus of Excel
Course Duration & Fees Sturcture
Certification
Syllabus of Excel
MODULE – I INTRODUCTION & GETTING START WITH CREATING WORKSHEETS & WORKBOOKS IN EXCEL
- Creating Workbooks in Excel Blank Workbooks and Templates
- How to Import and Open Files -Directly in Excel
- How to Add, Copy, and Move Worksheets Within Excel/ Workbooks
- What is a Workbook in Excel? Characteristics and Options
MODULE – II FORMATTING WORKSHEETS & WORKBOOKS IN EXCEL
- How to Modify the Worksheet Tab in Excel
- Modifying Page Setup Properties in Excel
- How to Insert & Delete Columns & Rows in Excel
- Workbook Themes Applying & Changing Themes in Excel
- Adjusting Column Width & Row Height in Excel
- How to Insert Watermarks in Your Excel Worksheet
- How to Insert Headers & Footers in Excel
- Using Data Validation in Excel
MODULE – III CONFIGURE TO PRINT & SAVE IN EXCEL
- Setting a Print Area in Excel
- Saving an Excel Workbook File Formats & Options
- How to Print Individual Worksheets in Excel
- How to Set Print Scaling in Excel
- Ensuring Your Excel Workbook is Backwards Compatible
- Printing in Excel How to Configure Workbooks to Print
- How to Modify Print Settings in Excel
- How to Save Excel Workbook Files in Different Formats
- How to Share Your Excel Workbook
MODULE – IV FORMAT & INSERT DATA IN CELLS AND RANGES IN EXCEL
- How to Merge Cells in Excel
- How to Modify Cell Alignment & Indentation in Excel
- Fonts and Font Styles in Excel
- How to Use the Format Painter in Excel
- Shrink to Fit How to fit cell without changing the cell size
- Wrapping Text in Excel: How to Wrap Text within Cells
- The Number Format in Excel Options & Properties
- How to Highlight Cells in Excel
- Cell Styles in Excel Applying & Modifying Styles
- How to Change Text to WordArt in Excel
- How to Append Multiple Worksheets
- How to Find and Replace Data in Excel
- How to Copy and Paste Data in Excel
- Using the tools of Paste Special in Excel
- Using the AutoFill Tool in Excel
- Cells in Excel How to Insert and Delete Cells
MODULE – V FILTER & SORT A TABLE IN EXCEL
- How to Filter Records and Data in Excel
- How to Sort Data in Excel
- Removing Duplicate Data in Excel
MODULE – VI CREATE & MODIFY A TABLE IN EXCEL
- How to Create a Table in an Excel Worksheet
- How to Add & Remove Columns & Rows in an Excel Table
- How to Apply a Style to an Excel Table
- How to Band Rows & Columns in an Excel Table
MODULE – VII SUMMARIZE DATA WITH FUNCTIONS IN EXCEL
- Using the SUM Function in Excel
- Using the MIN and MAX Functions in Excel
- Using the COUNT Function in Excel
- Using the AVERAGE Function in Excel
- Practical assignment: Making a standard Salary sheet in excel
MODULE – VIII FUNCTIONS WITH CONDITIONAL LOGIC AND FORMAT & MODIFY TEXT IN EXCEL
- How to Use the SUMIF Function in Excel
- How to Use the AVERAGEIF Function in Excel
- How to Use the COUNTIF Function in Excel
- Using the RIGHT, LEFT and MID Functions in Excel
- Using the TRIM & CLEAN Functions to Fix Data in Excel
- Using the UPPER and LOWER Functions in Excel
- How to Use the CONCATENATE Function in Excel
MODULE – IX CREATE A CHART IN EXCEL
- Excel Charts & Graphs: Summarizing Data Visually
- How to Change a Chart Type in Excel
- Switch Between Rows & Columns in an Excel Graph’s Source Data
- Quick Analysis in Excel
MODULE – X DATE & TIME, LOGICAL, FINANCIAL, LOOKUP FUNCTIONS IN EXCEL
- Using the Edate & Eomonth function In Excel
- DatedIF: Find the difference between Two Dates
- Networkdays/Networkdays.INTL: Working days Calculation
- What are the types of logical function
- How to use IF function in excel
- How to use IFS function in excel
- How to use AND/OR function in Excel
- Types of errors in excel
- Using the IFerror function when error found in Excel
- Practical assignment: Making a Result sheet
- Using the FV function in Excel on Investments
- Using the PMT,PPMT & IPMT Function in Excel
- Practical Assignment: Making a Loansheet sheet (Quaterly,Monthly,Yearly,Weekly,Half-Yearly)
- Vlookup Function Vs Hlookup Function
- Using vlookup and hlookup with Match
- Lookup Functions with Freezing Conditions
- Using the index Function with or without match function in excel
MODULE – XI IMPORTANT TOOLS IN EXCEL
- Uses of Macro in Excel
- uses of Name Manager in Excel
- Remove Duplicates :How to Remove duplicates from the list of data
- Data Tools: data validation,consolidation,Text to Columns, Advance Filter
- What IF Analysis:data table,scenario manager,Goal Seek
MODULE – XII PRACTICLE APPLICATIONS IN EXCEL
- Making the dynamic dashboard in Excel (with Practical Example)
- Making GST Invoice In Excel using the multiple function
- Making a Attendence Tracker in excel
Course Duration & Fees Sturcture
Course Duration – 45 Day
Fees Structure
Installment – 5000/-
One Time – 4000/-
Certification
Provide Certification After Completed Course