Certificate in Computer Software

Tags: MS-Office, Excel, basic

MS-Word

Introduction to MS-Word, Basic File Options, Random Text & Keyboard Shortcuts, Selection and Edit Selection, Font Settings, Advance Lists, Paragraph Settings, Find and Replace, Tables & It's Usages, Pictures, Shapes, SmartArt and Charts, Quick Parts, Drop Cap & Objects, Symbols, Page Backgrounds, Page Setup, A Complete Book Project, Mail Merge, Proofing & Languages, Comments, Track Changes, Compare & Protection, Views & Zooming, Windows, Macros

MS-Excel

Introduction to Excel, Basic Calculations, Basic Functions, Text Functions, Date and Time Functions, IF Condition, Lookup Functions, Mathematical Functions, PMT Functions, Conditional Formatting, Cell & Table Formats, Insertion and Deletion, Sorting and Filtering, Pivot Table and Pivot Chart, Slicer & Timeline, Cell Name Management, Formula Auditing, Calculations, Import & Export Data, Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate, What If Analysis - Scenario Manager, Goal Seek & Data Table, Group, Ungroup & Subtotal, Sheet & File Protection, Freeze Panes, Macros

MS-PowerPoint