MS Excel

by Tech Booster Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Tech Booster Logo

img Duration

2 Months

Course Details

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.

 

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
  • Guwahati Branch

    2nd Floor, House No-209, Guwahati

Check out more MS Excel courses in India

Sai Sini Academy Logo

MS Office

MS Office course is offered by Sai Sini Academy. This is an era of industrialization and rapid development. Technical revolution is the keyword in every field. Sai Sini Academy has been started in the year 2015 and running successfully for the past 3 years.

by Sai Sini Academy [Claim Listing ]
Training Basket Logo

Office365 Certification Course

Office 365 of Microsoft is an advanced solution for those who don’t want to miss critical communications and data even when they’re away from work. It is designed for companies with any size and reach to help experts stay associated.

by Training Basket [Claim Listing ]
The British Institutes Logo

Internet, E-mail Course

Internet, E-mail course is offered by The British Institutes for all skill level. The British Institutes is one of India's leading educators, with focus on diverse segments of education, and across learners of multiple age-groups. 

by The British Institutes [Claim Listing ]
Shikshaa Simple Learn Logo

MS Office

In today's fast-paced world, knowing how to use Microsoft Office can boost your chances of success. Whether you're a student, a professional, or a business owner, being good at Microsoft Office can help you get more done and communicate better.

by Shikshaa Simple Learn
Fita Training Logo

Advanced Excel Training

Searching for a Professional Training Institute where you can comprehend the Microsoft Excel Office suite extensively? Join Advanced Excel Training in Chennai at FITA and comprehend the Microsoft Excel Office suite from its basics to the advanced level under the guidance of Expertise.

by Fita Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy