Welcome to SICT COMPUTER EDUCATION

Certificate IN ADVANCE EXCEL ( S-SICT-ADVEXCEL )

Certificate IN ADVANCE EXCEL ( S-SICT-ADVEXCEL )

BASIC INFORMATION

Admission Now

Ø Apply Custom Formats and Layouts

· Apply Custom Data Formats

· Use Advanced Fill Options

· Apply Advanced Conditional Formatting and Filtering

· Apply Custom Styles and Templates

· Use Form Controls

· Prepare Workbooks for Internationalization

· Use Outlines

· Use Custom Views

· Conditional formatting

Ø Create advanced formulas

· Functions

· Apply functions in formulas

· Mathematical Functions

· Financial functions

· Useful Data Functions

· Some Other Useful Functions

· Look up data by using functions

· Apply advanced date and time functions

· Functions for Manipulating Text

Ø Create sheets

· Salary sheet,

· attendance sheet.

· busbooking sheet.

· booking sheet

· Monthly budget

· (personal, company, wedding)

· Discount sheet

· Commission sheet

· Lookup .

· Hlook-up.

· VLOOKUP.

· Sum, sumif, sumifs,

· Counta, countif, countifs,

· If, ifs, and, or, formula

Ø Use of Scenario

· Create Scenario Summaries

· Use Data Tables

· Create Advanced Charts

· Basic Excel Charts

· Use Area, Scatter & Stock Charts

· Use Surface, Radar & Combination Charts

· Create Custom Chart Templates

· Work with Sparkline’s

· Hyperlinks

· Data entry from

· Text to columns

· Flash feels

· Data validation

· Goal seeks

Ø Pivot tables & charts

· PivotTables

· Use Pivot Charts

· Timeline chart

· Slicer

Ø Manage and Share Workbooks

· Manage Workbook Versions

· Copy Styles within Workbooks

· Copy Macros within Workbooks

· Use Track Changes and Comments

· Merge Workbooks

· Protect Workbooks for Sharing

· Connect To External Data