Microsoft Office Specialist-Excel Certification (Free Training)
Sale Date Ended
Register for 8 hours of Excel Training and receive a globally valid certificate in Excel signed by Microsoft Satya Nadella.
You can add MOS specialist tag to your profile and upload the certificate on LinkedIn. The Certificate is recognized globally and can be checked online for authentication by recruiters.
This is a limited time offer and we have limited certificates to offer. So grab your certificate before the offer expires.
You also receive training from our renowned corporate trainers who have taught Excel in major corporates in India.
Course contents are as follows:
Create and Manage Worksheets and Workbooks: Create a workbook, Add a worksheet to an existing workbook, Copy and move a worksheet, Search for data within a workbook, Navigate to a named cell, range, or workbook element, Insert and remove hyperlinks, Rename a worksheet, Change worksheet order, Insert and delete columns or rows, Adjust row height and column width, Hide or unhide worksheets, Hide or unhide columns and rows, Customize the Quick Access toolbar and Display formulas etc.
Manage Data Cells and Ranges: Replace data, Cut, copy, or paste data, Paste data by using special paste options, Fill cells by using AutoFill, Insert and delete cells, Merge cells, Modify cell alignment and indentation, Format cells by using Format Painter, Wrap text within cells, Apply number formats, Apply cell formats, Apply cell styles, Insert sparklines, Outline data and Apply conditional formatting etc.
Create Tables: Create an Excel table from a cell range, Convert a table to a cell range, Add or remove table rows and columns, Apply styles to tables, Configure table style options, Insert total rows, Filter records, Sort data by multiple columns, Change sort order,Remove duplicate records and creating & designing Pivot table etc.
Perform Operations with Formulas and Functions: Insert references, Perform calculations by using the SUM function, Perform calculations by using MIN and MAX functions, Perform calculations by using the COUNT function and Perform calculations by using the AVERAGE function etc.
Perform Operations with Formulas and Functions: Perform logical operations by using the IF function, Perform logical operations by using the SUMIF function, Perform logical operations by using the AVERAGEIF function and Perform statistical operations by using the COUNTIF function and Vlookup etc.
Create Charts and Objects: Create a new chart, Add additional data series, Switch between rows and columns in source data, Analyze data by using Quick Analysis, Resize charts, Add and modify chart elements, Apply chart layouts and styles etc.