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

Master Mind Computers Logo

Ms Excel

Ms Excel course is offered by Master Mind Computers. This Computer Fundamentals tutorial covers a foundational understanding of computer hardware, software, operating systems, peripherals etc. along with how to get the most value and impact from computer technology.

by Master Mind Computers [Claim Listing ]
CTC IT Education Logo

MS PowerPoint

MS PowerPoint course is offered by CTC IT Education. We have been in your service since 1996. We believe in 100 % practical training skills, and knowledge of the latest trends & and techniques. Our IT Faculties are well qualified with good experience to solve all the problems.

by CTC IT Education [Claim Listing ]
Amity Computer Academy Logo

Advance Excel

Advance Excel course is offered by Amity Computer Academy for all ages. The Amity Computer Training Academy will provide you with industry leading educational programs, starting from the basic courses to advanced professional courses.

by Amity Computer Academy [Claim Listing ]
Cokonet Academy Logo

MS Excel (Basic)

MS Excel course is offered by Cokonet Academy. Cokonet is considered to be the most preferred software training destinations in South India. Cokonet trained candidates are currently working in different geographical locations in IT and ITES companies across the globe.

by Cokonet Academy [Claim Listing ]
CADD Training Centre (CADDTC) Logo

Microsoft Word

Microsoft Word course is offered by CADD Training Centre (CADDTC). At CADDTC we are focused on offering quality training to make sure that. Our Centre’s offer excellent training delivery we focus.

by CADD Training Centre (CADDTC) [Claim Listing ]

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