V1 MS Office HOC under New Scheme (All information)

V2 Introduction to MS Office versions and what we will study

V1 MS Word interface

V2 MS Word Font Face and Font Size

V3 MS Word Font group in Home Tab Complete

V4 MS Word Saving a File and Recover unsaved Files

V5 MS Word Home Tab Paragraph Group

V6 MS Word Clipboard Group

V7 MS Word Home Tab Style Group

V8 MS Word Home Tab Editing Group

V9 Rulers indentation page layout (Margin, orientaiton and size)

V10 Tab Stops ( Left Right Centre and Decimal Tabs)

V1 MS Word Insert Tab (insert Title, Blank Page, Picture, Shape Icon, 3d Models)

V2 MS Word Insert Tab (Smart Art, Screenshots, Text box, symbols)

V3 Basic Header and Footers and Auto Fields

V4 Different headers for First, Even and Odd Pages

V5 Section Breaks and Different header footers for sections

V6 Tables (insert edit delete and autofit)

V7 Table Styles and Sorting

V8 formula in Word tables and Merging the table

V9 MS Word Design Tab (Theme, design, watermark, page color and border)

V10 Pagination Options

V11 Layout Tab (Column, Line Number hyphenation, drop cap)

V12 Quick Access toolbar (with Redo Undo repeat)

V13 Footnote and Endnote

V14 Customizing the ribbon

V1 captions, cross reference and table of figures

V2 MS Word File compatability Mode

V3 Citation and bilbliography

V4 Mail Merge (Extra Content)

V5 Proofing Spelling and grammar check with thesaurus

V6 Review tab track changes

V7 review tab comments and compare

V8 Printing a Document

V9 MS Word Backstage View

V1 Introduction to Excel Interface and how to enter data

V2 Data Entry types Flash fill, Auto complete and shortcuts

V3 Excel formula, Calculation order, name box, forumula bar (ex 1.1 to 1.8)

V4 References in a formula, Introduction to functions, AutoSum functions Ex 2 1 to 2 9

V5 Relative Vs Absolute References Ex 3.1 to 3.5)

V6 Absolute References with Excercise 3.5 and 3.6

V1 Navigation and selection of bigger data

V2 Naming a Range and using in formula

V3 giving names to the ranges collectively and countblank function

V4 Counta and different count functions and their difference

V5 Zero Vs empty cell and the importance of tiny things in excel

V6 Formula Vs Functions, operators, Ampersnad and use

V7 A practical usage of ampersand operator

V8 Introduction to IF function

V9 applying IF function Practice 2 and intorduction to nested IF function practice 1

V10 Nested IF function complex example 2

V1 Some Functions on Text String(len, trim, upper, proper, lower, left, right and Mid)

V2 Practice 1 of Left Right and mid function with a glimpse of text to column option

V3 Exercise 2 of Text Function (Trim, Len, left, right, mid and concatinate)

V4 Find Search and replace functions

V1 Data selection shortcuts and basic single level sorting

V2 Custom sort lists sorting on basis of Cell colour and font colour

V3 Multiple level sorting(adding levels, Deleting levels and moving levels up and down)

V4 Filters and Multiple filters

V5 Subtotal Function with filters with criteria

V6 Sort and unique functions

V1 Conditional Formatting Basics and multiple conditions

V2 Conditional formatting text based and top bottom rules

V3 Conditional Formatting on dates setting condition on the basis of another cell

V4 Finding Duplicate data, rand & randbetween, round to 100s

V5 Databars, colour scales and icon sets

V6 Function based conditions (single and multiple)

Video 1 Format at a table, raname, Style options and Convert to Range

Video 2 Table Slicers

Video 3 Cell Style use modify update and Delete

Video 4 insert Delete Format of Cells, Rows, Columns and Sheets

Video 5 Number Format Currency comma decimals

Video 6 Number Formats Percentage, fractions, Dates and time

Video 7 Negative Number with brackets, colors and codings

Video 8 Grouping of sheets and simultaneous edit

Video 10 Paste Special Arithmatics

Video 9 Paste Special and pasting options

V1 Charts in Excel Using Recommended Charts Adding Chart Sheet

V2 Chart Filters and Chart Coloring Styles

V3 Chart Elements and Quick Layouts

V4 Charts Formatting, Alt text, change charts, select and update data etc

V6 Sparklines

V5 Chart Types (Column Bar stacked percentage stacked Pie treemap and waterfell

V1 Importing Data from TXT CSV image and PDF

V2 Importing Data From Web

V3 Cell Linking and updating the links

V4 Insert Remove and update hyperlinks

V5 Workbook Properties

V6 Cell Comments and notes (insert delete reply print)

V1 Sheet View Tab, Show Zoom arrange all

V2 Printng Large Sheets (print Preview, Fit to x , x pages, scalling, page size and orientation)

V3 Adjusting Columns, rows to repeat at top, Header and footer and margins

V4 center horizontally, vertically, View (normal, page break, page layout)

V5 Printing the document with print setting

Video 1 Powerpoint interface, mode and methods

Video 2 Insterting images, objects ordering, arragement and grouping

Video 3 Slide Design (size background and Themes)

Video 4 Slide presentation(From begning, from current slide, and slideshow views)

Video 5 Transition and its variation

Video 6 Animations basics

Video 7 Animations advance

V2 slide master and master slide part 1

V1 Slides Views, options, slides printing etc.

V3 slide master and master slide part 2

V4 Rehearse timings

V5 record Slide Show

V1 Step by Step Guide for MOB Assessment and exam interface

V2 ICAP Model Paper MS Word Assignment 1 and 2

V3 ICAP Model Paper MS Excel Assignment 1 and 2

V4 ICAP Model Paper MS Power Point Assignment 1 and 2