Video 1 Changes in IT AFC 04 between 2013 Edition and 2019 Edition

Video 2 Changes in MS Excel 2010 vs 2016 ITAFC04 book edition 2013 vs 2019 (Chapter 4 to 8)

Video 3 Changes in MS Word Chapter 9 to 11

Video 4 Changes in PowerPoint Chapter 12 to 14 and one new chapter

Video 1 Introduction to MS Office Suite

video 2 introduction to MS Word Entring and formatting data (font face font sie and font case)

Video 3 Alphabets, Paragraph word count dialog box (copy paste and paste options) auto text

Video 4 Pagination options

Video 5 tabs and tab stops

Video 6 sorting of paragraph and tables

Video 7 bullets numbering and multi level numbering

Video 8 Page margin, Orientation & size

Video 9 Paragraph margin, indentation, watermark, page colour, page border

Video 10 Style sets, Edition style set, making new style set, table of contents navigation pane and

Video 11 Footnote and Endnote

Video 12 Insert Picture Edit, Resize, Rotate and wrap text around object in MS Word

Video 13 Insert Clip Art, Edit wrap points order and group objects in MS Word

Video 14 Word Art and Font Effects

Video 15 Drop Cap

Video 16 Text Box in MS word

Video 17 Symbols in MS Word

Video 18 Tables in MS Word (inserting editing, Auto fit, grid lines, split, table styles)

Video 19 Tables in MS Word (Formula)

video 20 Tables in MS Word (Sorting in Table)

Video 21 Tables in MS Word (convert text to table and convert to text) Done

Video 22 MS Word Header Footer and page numbers section breaks

Video 23 Line numbers & Columns

Video 24 Proofing Spelling and grammar check with thesaurus

video 25 Page break, Section breaks(even page, odd page, next page)

Video 26 Review tab track changes

Video 27 review tab comments and compare

Video 28 captions, cross reference and table of figures

Video 29 Citation and bilbliography

Video 30 Document save and save as, different types of output pdf, xps, versions of word document un

Video 31 Backstage view(open, close, info, Security tabs)

video 1 (Difference between MS word MS powerpoint and MS Excel

Video 2 MS Powerpoint Interface

Video 3 Inserting and editing Picture, Clip Art, Screenshot, Shapes, text box and wordart

Video 5 Rulers (Show, hide),Grid lines, Guides

video 6 Editing text based contents

Video 7 Design Tab( page setup, slide orientation, themes and backgrounds)

video 8 Transition Tab (Slide show, Effects and effect options, sound and duration)

Video 9 Animation Part 1 (entrance effects and effect options)

Video 10 Animation Part 2 (add animation, emphasis, exit and custom path)

Video 11 Animation Part 3 (timing, Duration, delay, after with previous, animation pane and sounds)

video 12 Animation Part 4 (Trigger for animation)

video 13 Slide Show tab (Examinable supplement, rehearse timing and record slide show)

Video 14 View Tab (normal view, slide sorter, Notes page view, Rule, guidelines, guides, greyscale)

Video 15 powerpoint backstage view Part 1( save, save as, open & Close Vs Exit)

Video 16 Powerpoint backstage view Part 2 (Info, mark as final, encrypt with password)

Video 17 Power point backstage view Part 3 New(blank, new from existing, templates), printing

Video 19 Slide masters Part 2 (slide masters, slide show tabs, slide sortrer)

Video 1 Introduction to MS Excel 2010Part 1 (Excel interface, Quick Access Toolbar and its Customization and Windo

Video 2 Introduction to MS Excel 2010 part 2 (Ribbon and its customization, ROW, column, cells, sheets, name box)

Video 3 Introduction to MS Excel 2010 Part 3(Formula Bar, Rowcolumn Header, scroll bars, data type)

Video 4 Entring Data into the cells (data type, selection methods, ways of entring data)

Video 5 Home Tab font group & Key tip badge

Video 6 Home Tab Alignment group, wrap text and merge cells, fit data in a cell, shrink to fit

Video 7 Insert Tab, insert equation symbols, fold unfold tabs, customizing ribbon and quick access toolbar

Video 8 Number formatting Part 1 (Currency, scientific notation, increase decrease decimal)

Video 9 Number formats part 2 (special formatting, Custom number formating, Date format introduction)

Video 10 Number format part 3 ( Date entry and date formats)

Video 11 Number format part 4 (Thousand separators, difference between starik, zero, question mark in number

Video 12 Number Format Part 5 (condition in number format and phone number formats)

Video 13 Fill handle

1 Power of Microsoft Excel data ananlysis

2 Introduction to formula ( operators and operands)

3 introduction to formula( cell reference, precedents, dependents and calculation options)

4 multiple operators, basic excel errors copycut paste formula and relative references)

5 absolute references practice and F4 behaviour

6 introduction to function

7 basics of functions and entring your first function

8 Data Analysis Fuctions

9 Functions relating to text

10 Rounding Functions

11 V Lookup Function basics with naming cells and range

12 H look up and keyboard selection tools

13 Ture and false arguments of vlookup function

14 Logical Functions

15 basics of IF Function

16 Advance IF Function

17 nested IF Function

18 Count, Counta, Countblank, countif and Countifs

19 Count, Countif, sum, sum if with complex condition and data dropdowns

20 Recall practice of dropdowns, sumifs & reletive absolute references

21 Introduction to Pivot Table

22 Date Functions and date & Time logic

23 Date and time further study

24 Financial Functions

Video 1 Goal Seek

Video 2 Formula Auditing ( trace precedents,dependents,show formula, evaluate formula)

Video 3 Data selection shortcuts and basic single level sorting

Video 4 Custom sort lists(days and Months)

Video 5 Multiple level sorting

Video 6 Filters and Multiple filters

Video 7 Subtotal Function with filters

Video 8 Filters relating to date (and pivot table for dates)

Video 9 Conditional Formatting

Video 10 Tables and format as a table

Video 11 Charts(layout format and design) Sparklines

Video 12 (comments show, copy, print and delete)

Video 13 (Find and select, goto special)

Mock and Practice Questions