MODULE- I

• 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- I

• 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- I

• 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- I

• 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                

MODULE- I

• 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- I 

• How to Filter Records and Data in Excel                

• How to Sort Data in Excel                

• Removing Duplicate Data in Excel                

MODULE- I

• Conditional Formatting in Excel: Applying & Modifying Formatting

• Sparklines in Excel: How to Insert & Modify a Sparkline

• How to Transpose Columns & Rows in Excel

• Creating & Modifying Named Ranges in Excel

• Outlines in Excel: How to Create an Outline

• Outlines in Excel: How to Collapse Groups of Data in an Outline

• How to Insert a Subtotal in an Excel Worksheet

MODULE- I 

• 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- I

• How to Use Formulas & Functions in Excel

• Cell References in Excel: Relative, Absolute & Mixed

• Defining Order of Operations in Excel

• Referencing Cell Ranges and Other Worksheets in Formulas

MODULE- I 

• 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- I

• How to Use the SUMIF Function in Excel

• How to Use the AVERAGEIF Function in Excel

• How to Use the COUNTIF Function in Excel

MODULE- I 

• 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- I

• 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- I

• Using the Edate & Eomonth function In Excel

• DatedIF: Find the difference between Two Dates

• Networkdays/Networkdays.INTL: Working days Calculation

MODULE- I  

• 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

MODULE- I  

• 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)

MODULE- I 

• 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- I 

• 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- I

• Making the dynamic dashboard in Excel (with Practical Example)

• Making GST Invoice In Excel using the multiple function

• Making a Attendence Tracker  in excel