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

DATA ANALYTICS
Advanced
DATA ANALYTICS
(4.9 /5 Rating)

Learn to analyze any data.

  • 400+ Lessons
  • 650+ Students
Hardware and Networking
Intermediate
Hardware and Networking
(4.7 /5 Rating)

Comprehensive training on computer hardware and networking, including assembly, maintenance, and troubleshooting

  • 200+ Lessons
  • 1000+ Students
Data Science with Python
Advanced
Data Science with Python
(4.8 /5 Rating)

Master the Art of Data Science and Analytics. Our Data Science Training Program is designed for beginners, professionals, and organizations to gain hands-on experience in data analysis.

  • 350+ Lessons
  • 5000+ Students