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

TELECOM (2G,3G,4G)
Advanced
TELECOM (2G,3G,4G)
(4.8 /5 Rating)

Telecom is one of the emerging and fastest growing field in today’s recessionary environment. Most of the world’s renowned companies are planning to spread their wings in India. Since 3G and 4G ...

  • 120 Lessons
  • 500+ Students
CCNA
Advanced
CCNA
(4.8 /5 Rating)

CCNA is one of the most respected Associate level Certification in the technological world. This program tests a candidate's knowledge and skills required to install, operate, and troubleshoot ...

  • 100+ Lessons
  • 650+ Students
ANDROID
Advanced
ANDROID
(4.7 /5 Rating)

Android is a Linux-based operating system for mobile devices such as smartphones and tablet computers. It is developed by Google. It is software cluster consisting not only operating system but also

  • 120+ Lessons
  • 250+ Students