logo
Find a Training Center x

MS Office 2019

  • No Rating
  • (0 Reviews)
  • 1 User Enrolled

MS Office 2019

MS Word, MS Powerpoint, MS Excel

  • No Rating
  • (0 Reviews)
  • 1 User Enrolled
  • 999
  • 1500


Course Content

3 sections • 97 lectures • 15h 19m total length
00 Intro - Interface-1
4min
01 Home Tab - Font n Formatting-2
13min
02 Home Tab - Text Effects n Typography-3
10min
03 Home Tab - Advanced Font Options-4
11min
04 Home Tab - Paragraph Menu-5
11min
05 Home Tab - Alignment n Spacing-6
5min
06 Home Tab - Paragraph More Options-7
4min
07 Home Tab - Paste Special-8
12min
08 Home Tab - Styles-9
6min
09 Home Tab - Find-10
6min
10 Home Tab - Wildcard Find-11
14min
11 Home Tab - Find n Replace Goto-12
17min
12 Insert Tab - Table-13
7min
13 Insert Tab - Illustrations-14
13min
14 Insert Tab - Addins n Links-15
15min
15 Insert Tab - Header n Footer-16
12min
16 Insert Tab - Textbox Wordart Quickparts Objects-17
19min
17 Insert Tab - Symbols n Equations-18
7min
18 Design Tab - Complete-19
16min
19 Layout Tab - Page Setup n Page Break-20
7min
20 Layout Tab - Section Break-21
20min
21 Layout Tab - Line Number Hyphenation-22
14min
22 References Tab - Table of Contents-23
10min
23 References Tab - Citations n Captions-24
12min
24 References Tab - Index Table of Authorities-25
10min
25 Mailing Tab - Envelopes n Labels-26
3min
26 Mailing Tab - Mail Merge-27
21min
27 Mailing Tab - Mail Merge Wizard-28
3min
28 Review Tab - Proofing n Comments-29
11min
29 Review Tab - Track changes n Compare-30
12min
30 Review Tab - Restrict Editing-31
4min
31 Draw Tab - Brief-32
2min
32 View Tab - Complete-33
16min
33 View Tab - Macros-34
7min
34 File Tab - Properties n Word Options-35
6min
35 Hindi Typing-36
3min
01 Home Tab
9min
02 Insert Tab
8min
03 Zoom
8min
04 Design Tab
5min
05 Transition
4min
06 Animation Tab
12min
07 Slide Show Tab
10min
08 Record Slide Show
8min
09 Review-View Tab
7min
10 Saving Presentation
5min
11 Recording Video
3min
01 An Overview
4min
02 Basics of Excel
6min
03 Font n Alignment
13min
04 Number Format - Text, Number, Currency, Accounting, Date, Time
9min
05 Number Format - Percentage, Fraction, Scientific
12min
06 Number Format - Digit Grouping, Custom Formats
8min
07 Conditional Formatting - Writing Data
12min
08 Conditional Formatting - Rules
10min
09 Conditional Formatting - Color Scales, Manage Rules, Styles
10min
10 Cells - Insert, Delete, Format
8min
11 Editing - Fill, Flash Fill, Clear, Sort n Filter
12min
12 Insert - Pivot Table Creation
12min
13 Pivot Table - Analysis
11min
14 Recommended Pivot Table
9min
15 Charts, Maps, Sparklines
13min
16 Insert - Slicer, Timeline, Header Footer, Symbols
7min
17 Page Layout
18min
18 Formulas Tab - Function, Name Manager
16min
19 Formula Auditing, Watch Window, Calculation
9min
20 Formulas - Sum, Average, Count, Max, Min
7min
21 Formulas - EMI Calculation (PV, Rate, NPER, PMT)
14min
22 Formulas - Financial (Future Value, PER, IPMT, PPMT)
11min
23 Formulas - Depriciation (DB)
8min
24 Formulas - Logical Functions (If, And, Or)
6min
25 Formulas - Logical Functions Combination (If, And, Or, Not)
11min
26 Formulas - Text Functions (Trim, Left, Right, Mid)
6min
27 Formulas - Text Function (Find)
7min
28 Formulas - Text Function (Replace)
3min
29 Formulas - Text Functions (Concatenate, Upper, Lower, Proper)
4min
30 Formulas - Date n Time (Now, Date, Days360)
11min
31 Formulas - Today, Day, Month, Year, Hour, Minute, Networdays, Networkdays.Intl
7min
32 Formulas - Lookup (V Lookup)
9min
33 Formulas - VLookup (Absolute Reference, Exact Match)
15min
34 Formulas - Vlookup (Approximate Match)
5min
35 Formulas - Lookup (HLookup)
5min
36 Formulas - Lookup (Match, Index)
9min
37 Formulas - ABS, Log, Power, Fact, Rand, Randbetween, Decimal, Dec2Hex, Base, Hex2Dec
13min
38 Formulas - SumIf
8min
39 Data - Get Data, Connections, Filter
10min
40 Data - Advance Filter
13min
41 Data - Text to Columns, Remove Duplicates
20min
42 Data - Validation
6min
43 Data - Consolidate
11min
44 Data - Whatif Analysis (Scenario Manager, Goal Seek)
11min
45 Data - Whatif Analysis (Data Table)
11min
46 Data - Forecast Sheet
4min
47 Data - Group, Ungroup, Subtotal
9min
48 Workbook Views, Zoom, Arrange, Freezepanes, Split, Switch Windows
9min
49 Macros
8min
50 Review - Proofing, Comments, Protect, Ink(Draw)
7min

Requirements

  • 10th

Description

All essentials of MS Office 2019 Package

Recently Added Courses

blog
Last Updated 6th September 2021
  • 17
  • 3000
blog
Last Updated 6th November 2020
  • 7
  • Free
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999

About the Instructor

instructor
About the Instructor

Admin Account of SmartoVersity