Course Curriculum

Introduction to Microsoft Excel & its properties
  • Workbook properties
  • creating a workbook, saving a workbook, renaming a workbook
  • Worksheet properties, add, delete
  • Name a worksheet, color a worksheet tab
  • move & copy worksheet, select all
Concept of Row & Column
  • Insert row & column, row height, column width
  • Rows, Column, Columns, Hide, unhide/ Cut
  • Copy / Delete, Clear content / Paste, Paste Special
Properties of Cells
  • workbooks
  • worksheets
  • Paste special
  • Paste Special Transpose
Formatting cells
  • Number, Alignment, Font formats
  • Border, Fill, Protection / Use of format painter
  • Conditional formatting/ Advanced Conditional Formatting
  • Print worksheet / Printing properties
Cell Reference
Data Sorting and Filtering
Date Function
  • Now/Extract Date, year, Month, Week no, Week day from given date
  • Text Function-Left, Right, Mid / Len / Proper, Upper,
  • Lower /Concatenate / Find, Search, Substitute, Replace, Round, RoundDown, Roundup
Use Of Formula, Lock the required cells
Count
  • CountA, CountBlank, CountIf, CountIfs
  • Min, Max / Sum, Sumif, Sumifs
  • Subtotal / Average, Averagea, AverageIf, AverageIfs
Double Freeze, Chart validation, Pivot Table, Pivot Chart
Drop down creation
VLOOKUP & HLOOKUP
Index and Match Linking Cells & Sheets
Slicer| Name Manager | What If Analysis | Consolidation
Preparing data for Analysis | Report Visualisation Techniques | Advanced Filter | Record Macro

Course Duration: 1 Month

Overview

MS Excel is a commercialized spreadsheet application that is produced and dispensed by Microsoft for Microsoft Windows and Mac OS operating systems. It highlights the ability to perform essential calculations, use graphing tools, create pivot tables and create macros, among other useful features. It is the most commonly used spreadsheet software in the industry. Tech Booster is the best institute for MS Excel – Basic & Advance.

Career Opportunities for MS Excel experts:

Maximum jobs require Excel skills and/or experience with productivity software, which mean on an average certified Excel skills can maximize your earning potential by 12%. It opens the door to more jobs and careers, especially for individuals that don’t have a college degree.

Various Job Profiles after the completion of MS Excel course:

Data Analyst, Metrics and Analytics Specialist, MIS Executive, Financial Analyst, Market Research Analyst, Big Data Engineer, and many more.

Certificate

Got any queries?

  Need any help? Talk to our counselor-

Ph:+91-8404049881 / +91-8486244779 

ADVANCED EXCEL

Course Includes:

  • Instrutor: Tech Booster
  • Duration: 2 Months
  • book icon Lessons: 120+
  • Enrolled: 650+ students
  • Language: English
  • Certificate: Yes
Start Now

More Courses for You

MOBILE REPAIRING
Advanced
MOBILE REPAIRING
(4.8 /5 Rating)

Tech Booster Institute of Professional Studies mainly provides Mobile repairing course for graduates, undergraduates, and high school drop outs that can help them find proper employment in the...

  • 100+ Lessons
  • 1000+ Students
ETABS
Advanced
ETABS
(4.6 /5 Rating)

Fashion is ever demanding and changing- a constant effort of selection, adoption and change.Fashion and Interior Designing have become one of the fastest growing professions in India in recent times.

  • 40+ Lessons
  • 200+ Students
TALLY with GST
Advanced
TALLY with GST
(4.8 /5 Rating)

Tally.ERP 9 is a financial accounting package and it contains multiple kind of ERP software. Tally has now its global presence in more than 90 countries. Tally’s ERP is mainly used for vouchers,...

  • 120+ Lessons
  • 1000+ Students