• MIS and Data Analytics
  • MS-Excel (Advanced)

Advanced MS - Excel With MIS Reporting

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

  • 10 - 20 weeks
  • 102 Lectures
  • 2365 Student Enrolled
4.7
  • Offer by ATTITUDE ACADEMY
  • Last updated:- Apr 16, 2021
7.jpg
Actual Price

₹999.00 92% Off

Course Features
  • Online Interactive Learning Sessions
  • Practical Videos For Covering Course
  • Complete eBook with Assignments
  • Online Offline Assessments
  • Course Related Blogs & Articles
  • 100% Job Assistance
  • Access on All Device
  • 24*7 Lifetime Access
  • ISO 9001 : 2008 Company
  • Internship Programme for Learners
  • Govt. Recognized Certificate
  • One of the Finest Education Brand in India

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.

What placement assistance will you receive?

Free Placement Preparation Training

Access to curated Internships & Current Job Openings.

Top performers will be highlighted on Attitude Job portal

Requirements

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

Course Circullum

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

Take the final exam online to complete the Advanced MS - Excel With MIS Reporting after which you will be able to download your certificate from Attitude Trainings.

attitude-certificate

How will your training work?

Thought

Classes

Watch recorded & live videos to learn various concepts & get Live Sessions with Trainer for Doubts Clearing.

Planning

Exams

Test your knowledge through quizzes & module tests. Take online exam & get instant result.

Implement

Projects

Get hands on practice by doing assignments and live project

Result

Certificate

Take the final exam to get certified in Advanced MS - Excel With MIS Reporting

Ruchika Bhardwaj

  • Videos
  • 100 Lectures
  • Exp. 5

More than 5 years of Experience in MS-Office, Advanced Excel and MIS. Accounts,Complete knowledge of TALLY software ERP 9 & Tally Prime with GST returns - GSTR1 GSTR-3B , R9 ,BUSY, Taxation, e-filing,compiling and presenting reports, budgets, business plans, commentaries and financial statements.administering payrolls and controlling income and expenditure.administering payrolls and controlling income and expenditure.

  • MIS Expert & Account Expert
out of 5.0
5 Star 0%
4 Star 75%
3 Star 0%
1 Star 0%

Reviews - 1

MD DanishApr 30, 2021

" I belong to Haridwar, Uttarakhand.I have done my Advanced Excel course Online through the LMS & got certified from Attitude Academy, I am very glad to say that the Online course was very effective for me, I had completed my assignments online & got complete support from the team of Attitude Academy, so definitely would like to recommend to all join Attitude Academy & become skilled like me. "

Was this review helpful?

Releated Courses

₹1999
  • 8682 Views
  • 4.7 Reviews
₹2000
  • 8682 Views
  • 4.7 Reviews
₹1500
  • 8682 Views
  • 4.7 Reviews
₹1299
  • 8682 Views
  • 4.7 Reviews
₹1299
  • 8682 Views
  • 4.7 Reviews

How will your doubts get solved?

You can post your doubts on the Q&A forum which will be answered by the teachers within 24 hours.

100% Placement Assistance

Meet Our Placed Students

TRIBHUVAN

data entry operator

bhagwan das shop

AMAN SINGH RAWAT

MIS executive

subhlakshmi

ASHISH MANI

Backend

Rishtadepot

LAXMI

data entry operator

HI-TECH syndicated

PANKAJ SEMWAL

MIS Executive

siso project governance solutions

VAIBHAV

MIS Executive

HI-TEK SYNDICATE Pvt. Ltd

RAJAT JAIN

Backend Operation

Sun Life Insurance Pvt. Ltd

JASPREET KAUR

MIS Executive

Grace International Pvt. Ltd

ARTI

MIS Executive

HDFC Bank

SHIVAM PAUL

Customer Support

iEnergizer

Commonly Asked Questions

There are no prerequisites for this training as it is of beginner level. Everything that you need to know about Advanced MS - Excel With MIS Reporting would be taught to you from scratch.

You can watch the videos and take quizzes & tests on any device including mobile. However, for assignments and practice, use of desktop or laptop is required.

To do this training, you would need a computer with a minimum 1 GB ram and Windows 8 or later (64 bit).

You can choose your preferred batch date while signing up for the training program and start accordingly.

No, you will be only getting a soft copy of the certificate which you can download and print out if required.

  • You will receive free access to Placement Preparation Training on the platform which covers resume writing, cover letter writing, how to search and apply for internships and jobs on Attitude, and interview preparation. This training comes with a lifetime access meaning you can use it later also if you are not applying for internships or jobs right now.
  • Access to curated internships & jobs related to the training - after completing the training, you would receive a list of handpicked internships or jobs every week that you can apply to as per your preference.
  • If you are a top performer, a badge of achievement will be added to your Attitude resume and shown to the employers when you apply to internships or jobs on Attitude.

While many of our students have found their desired internships or jobs after completing their training, Attitude Trainings does not guarantee an internship or job. However, if you study sincerely (including doing exercises, assignments, and projects) and make good use of our placement assistance feature, it will become easier for you to get a placement using the skills learned in the training.

You could try making the payment from a different card or account (of a friend or family). Otherwise, you can follow the instructions on how to make an offline payment.

The amount deducted will come back to your account within 3-5 working days. This is the normal duration your bank will take to credit the amount back into your account.

₹999.00 92% Off

Join Thousand of Happy Students!

Subscribe our newsletter & get latest news and updation!