• Asia’s #1 & Only Award Winning MS-Excel (Advanced) Training Program WITH 100% PLACEMENT ASSISTANCE

Enter Your Details



Advanced MS - Excel With MIS Reporting

MIS Reporting and Analysis Training - Complete Basic to Expert level Excel and Reporting 

BESTSELLER

    4.7       2365 students enrolled this month

Offer by ATTITUDE ACADEMY    Last updated:- Jul 6, 2020

What you'll learn

  • Fundamentals of MS Excel
  • Excel shortcuts
  • Conditional formatting
  • Data validation
  • In-depth understanding of various functions of MS Excel 
  • Maintain large sets of Excel data in a list or table
  • Formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables

 

Requirements

Computer/Laptops. That all.

Description

MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros This application performs very effectively on arithmetic solution

  •  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                
     

  •  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                

  •  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                

  •  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                
     

  •  How to Filter Records and Data in Excel                
  •  How to Sort Data in Excel                
  •  Removing Duplicate Data in Excel                
     

  •  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

  •  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

  •  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

  •  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

 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

  •  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

  •  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

  •  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

  •  Making the dynamic dashboard in Excel (with Practical Example)
  •  Making GST Invoice In Excel using the multiple function
  •  Making a Attendence Tracker  in excel

Limited Period Offer
INR 999/- INR 7000/- 86% Off
Book Now

7 Days Money-Back Guarantee*

Includes

What you'll learn

  • Fundamentals of MS Excel
  • Excel shortcuts
  • Conditional formatting
  • Data validation
  • In-depth understanding of various functions of MS Excel 
  • Maintain large sets of Excel data in a list or table
  • Formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables

 

Requirements

Computer/Laptops. That all.

Description

MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros This application performs very effectively on arithmetic solution

  •  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                
     

  •  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                

  •  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                

  •  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                
     

  •  How to Filter Records and Data in Excel                
  •  How to Sort Data in Excel                
  •  Removing Duplicate Data in Excel                
     

  •  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

  •  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

  •  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

  •  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

 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

  •  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

  •  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

  •  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

  •  Making the dynamic dashboard in Excel (with Practical Example)
  •  Making GST Invoice In Excel using the multiple function
  •  Making a Attendence Tracker  in excel

Placed Learners


Related Courses

Why Choose Us

BEST FACULTY

100+ BATCHES

100% PRACTICAL

24*7 ONLINE ACCESS

8,676 + PLACED

10+ YEARS

Enter Your Details

Still have questions? Call @+91-9654382235 for answers

  CALL NOW