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

C++ Programming
Advanced
C++ Programming
(4.6 /5 Rating)

C Plus Plus Training provide an overview of understanding the object oriented superset of ANSI C. C++ course provides students with a comprehensive study of the object oriented programming Language...

  • 80+ Lessons
  • 300+ Students
Microsoft Power BI
Advanced
Microsoft Power BI
(4.7 /5 Rating)

Become a Business Analyst by working on different real case studies using Power BI by Microsoft in 1.5 months

  • 100+ Lessons
  • 350+ 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