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

ADCA
Intermediate
ADCA
(4.7 /5 Rating)

We have designed this course specially for the student who want to learn computer applications in different fields like banking, insurance and accounting. This program allows students to seek profess

  • 400+ Lessons
  • 1000+ Students
CATIA V5
Advanced
CATIA V5
(4.7 /5 Rating)

CATIA is a multi-platform software suite for computer-aided design (CAD), computer-aided manufacturing (CAM), computer-aided engineering (CAE), PLM and 3D. This course is designed to introduce users..

  • 80 Lessons
  • 200+ Students
AUTOCAD (2D,3D)
Advanced
AUTOCAD (2D,3D)
(4.8 /5 Rating)

AutoCAD or automatic computer aided design is a computer software application that is used for designing and drafting of 2D or 3D objects. Earlier around 1982 it was used as a desktop application...

  • 120 Lessons
  • 650+ Students