MS Excel

MS Excel course is offered by Firstman Academy. Since Firstman Academy inception it has imparted quality training to more than 10000 students and many of them were placed in reputed MNCs as well as established Indian companies over a decade.

Organization is currently focused on IT/GIS Training and Services Staffing Firstman Academy has spent over 15 years in innovating, refining and fine tuning its offerings to suit the needs of students, professionals and employees.

Course Content:

• Introduction to Excel
• Introduction to Excel interface
• Understanding rows and columns, Naming Cells
• Working with excel workbook and sheets
• Formatting excel work book
• New, Open, Close, Save, Save As
• Formatting Text: Font Size, Font Style
• Font Color, Use the Bold, Italic, and Underline
• Wrap text, Merge and Centre
• Currency, Accounting and other formats
• Modifying Columns, Rows & Cells
• Perform Calculations with Functions
• Creating Simple Formulas
• Setting up your own formula
• Date and Time Functions, Financial Functions
• Logical Functions, Lookup and Reference
• Functions Mathematical Functions
• Statistical Functions, Text Functions
• Sort and Filter Data with Excel
• Sort and filtering data
• Using number filter, Text filter
• Custom filtering
• Removing filters from columns
• Conditional formatting
• Create Effective Charts to Present Data Visually
• Inserting Column, Pie chart etc
• Create an effective chart with Chart Tool
• Design, Format, and Layout options
• Adding chart title
• Changing layouts
• Chart styles
• Editing chart data range
• Editing data series
• Changing chart
• Analyze Data Using PivotTables and Pivot Charts
• Understand PivotTables, Create a PivotTable
• Framework Using the PivotTable and PivotChart
• Create Pivot Chart from pivot Table.
• Inserting slicer
• Creating Calculated fields