Whatsapp Chat
Send us a message today and we will contact you as soon as possible.

Microsoft Excel training Course

Microsoft Excel training Course

Query Form

What is Microsoft Excel?

It is a spreadsheet program created by Microsoft, it organizes data in columns and rows and allows you to do mathematical functions in a graphic format, represent data(s) and perform a variety calculations. 

Excel runs on Windows, macOS, Android and iOS. 

Our Course Objective.

  • Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
  • Create, open and view a workbook.
  • Save and print workbooks.
  • Enter and edit data.
  • Modify a worksheet and workbook.
  • Work with cell references.
  • Learn to use functions and formulas.
  • Create and edit charts and graphics.

 

Why will BIIT’s Microsoft Excel Course help you.

  • On completion of the course you will be able to organize data in an easy-to-navigate way.
  • You will be skilled at doing basic and complex mathematical functions.
  • You’ll be able to convert large amounts of data into easy to understand and helpful graphics or charts.
  • Analyzing data and making forecast predictions will be simpler.


What are the eligibility pre-requisites before starting? 

*Basic knowledge of computer


Oor Course fee, duration and format details.

Fee: Rs. 4000

Course Duration: 45 Days


Class Mode: Online / Offline

Level: Basic To Advanced

BIIT the best training for short term Microsoft Excel training and all your IT requirements in Laxmi Nagar, East Delhi.


Course Curriculum:

Excel Introduction

 • An overview of the screen, navigation and basic spreadsheet concepts • Various selection techniques • Shortcut Keys

Customizing Excel 

• Customizing the Ribbon • Using and Customizing AutoCorrect • Changing Excel’s Default Options 

 Using Basic Functions

 • Using Functions – Sum, Average, Max,Min, Count, Counta • Absolute, Mixed and Relative Referencing

 Mathematical Functions 

• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT 

 Protecting Excel

 • File Level Protection • Workbook, Worksheet Protection

 Text Functions

 • Upper, Lower, Proper • Left, Mid, Right • Trim, Len, Exact • Concatenate • Find, Substitute

 Date and Time Functions

 • Today, Now • Day, Month, Year • Date, Date if, DateAdd • EOMonth, Weekday 

 Advanced Paste Special Techniques

 • Paste Formulas, Paste Formats • Paste Validations • Transpose Tables 

 Sorting and Filtering

 • Filtering on Text, Numbers & Colors • Sorting Options • Advanced Filters on 15-20 different criteria(s)

 Printing Workbooks

 • Setting Up Print Area • Customizing Headers & Footers • Designing the structure of a template • Print Titles –Repeat Rows / Columns

 What If Analysis

 • Goal Seek • Scenario Analysis • Data Tables (PMT Function) • Solver Tool

 Logical Functions 

• If Function • How to Fix Errors – if error • Nested If • Complex if and or functions

 Data Validation

 • Number, Date & Time Validation • Text and List Validation • Custom validations based on formula for a cell • Dynamic Dropdown List Creation using Data Validation – Dependency List 

 Lookup Functions 

• Vlookup / HLookup • Index and Match • Creating Smooth User Interface Using Lookup • Nested VLookup • Reverse Lookup using Choose Function • Worksheet linking using Indirect • Vlookup with Helper Column Pivot Tables • Creating Simple

 Pivot Tables 

• Basic and Advanced Value Field Setting • Classic Pivot table • Choosing Field • Filtering PivotTables • Modifying PivotTable Data • Grouping based on numbers and Dates • Calculated Field & Calculated Items • Arrays Functions • What are the Array Formulas, Use of the Array Formulas? • Basic Examples of Arrays (Using ctrl+shift+enter). • Array with if, len and mid functions formulas. • Array with Lookup functions. • Advanced Use of formulas with Array.

 Charts and slicers 

• Various Charts i.e. Bar Charts / Pie Charts / Line Charts • Using SLICERS, Filter data with Slicers • Manage Primary and Secondary Axis

 Excel Dashboard 

• Planning a Dashboard • Adding Tables and Charts to Dashboard • Adding Dynamic Contents to Dashboard

 Mail Functions – 

 • Using Outlook Namespace • Send automated mail • Outlook Configurations, MAPI • Worksheet / Workbook Operations • Merge Worksheets using Macro • Merge multiple excel files into one sheet

 

Career Opportunities.

  • Data Analyst. Data Analyst.
  • Growth Analyst. Growth Analyst. …
  • Excel Consultant. QS Quacquarelli Symonds. 
  • Associate-RPA, Tech Support. 
  • Reporting Analyst. Reporting Analyst. 
  • Excel Developer.
  • Data Analyst (Growth).
  • Business Analyst (Banking Domain|SQL|Excel).


 Why is BIIT best For short term Training?

BIIT offers Short Term IT course in advanced excel 2013 which is extremely valuable for businesses. We not only work on theoretical knowledge but also provide practical skills so you’ll understand  concepts using live projects. 

BIIT the best training for short term Microsoft Excel training and all your IT requirements in Laxmi Nagar, East Delhi.


Why Choose BIIT ?

*BIIT is ranked the best IT Training institute in Laxmi Nagar East Delhi because along with the best tutoring, we also offer job support and interview preparation.


*Life Time Validity: 

Once you are enrolled with BIIT for training, you can revise specific topics or the whole syllabus at any time, up to a maximum of 5 years, untill such time as you’re fully competent and confident.


*Training by Professionals: 

You will be trained by professionals who have 8+ years industry experience and extensive teaching expertise.


*Problem Solving Team: 

At BIIT we have experts in all aspects and areas of IT who are ready to help you with any  problems you may face 24×7.


*Our small Batches provide one to one focus on each student.

BIIT the best training for short term Microsoft Excel training and all your IT requirements in Laxmi Nagar, East Delhi.