ADVANCE CERTIFICATE IN EXCEL ( S-GC-006 )

MS Excel 2016

·   Introduction

·   Access Ribbon With Keyboard Shortcut

·   Expand And Collapse The Ribbon

·   Customize Status Bar

·   Selecting Data

·   Simple Table

·   Paste Options

·   Font Group in Home Tab

·   Alignment Group In Home Tab

·   Number Group In Home Tab

·   Conditional Formatting At Styles Group In Home tab

·   Format As Table At Styles Group In Home Tab

·   Cell Styles At Styles Group In Home Tab

·   Cells Group In Home Tab

·   Functions At Editing Group In Home Tab

·   Fill And Clear Command At Editing Group In Home tab

·   Sort And Filter At Editing Group In Home Tab

·   Find And Select At Editing Group In Home Tab

·   Pivot Table

·   Convert Data To Table At Tables Group In Insert tab

·   Insert Picture At Illustrations Group In Insert tab

·   Insert Clip Art And Shapes At Illustration Group In Insert Tab

·   Insert Smart Art

·   Working With Charts

·   Two Quick Shortcut To Create Chart

·   Spark lines Group In Insert Tab

·   Themes Group In Page Layout Tab

·   If Command

·   Hlookup Command

·   Pmt Command

·   Round Command

·   Concatenate Formula

·   Trim Command

·   Formula Auditing Group In Formulas Tab

·   Import Data From Access And Text

·   Advance Filter

·   Text To Columns Command At Data Tools Group In Data Tab

·   Goal Seek At Data Tools Group In Data Tab

·   Goal Seek At Data Tools Group In Data Tab Second Example

·   Outline Group In Data Tab

·   Protect Sheet And Protect Workbook At Changes Group In Review Tab

·   Navigation Between Workbooks And Worksheets

·   Split Command At Windows Group In View Tab

·   Switch Windows At Windows Group In View Tab

·   Freeze Panes

·   Save Spreadsheet As Pdf

·   Macro

Advance Excel

·   If, And, Or Functions

·   Array Functions

·   Auto fill And Custom List

·   Auto sum With Row Reference And Column Reference

·   Concatenate

·   Condition Formatting With Mod Function

·   Convert Function

·   Count blank And Counta Function

·   Creating Combo Box

·   Large And Small

·   Find, Search And Mid Function

·   Formula Copy Shortcut

·   Hyperlink Through Drag And Drop

·   Index Function

·   Information Function

·   Left And Right Function

·   Macro In Excel

·   Match And Index Function

·   Match Function

·   Mod Function

·   More Text

·   Nested If

·   Proper, Upper And Lower Function

·   Rank Function

·   Replace And Substitute Function

·   Sumif, Countif And Average if Function

·   Sumifs, Countifs, Averageifs Function

·   Text Functions

·   Transpose Function

·   Vlookup

·   Weekday

10TH PASS