Course Content
Excel Basics
0/7
01: Introduction to Excel 2019 User Interface
12:37
02: Data entry in Excel
14:56
03: Forming Basics
13:48
04: Borders and Eleignment
13:48
05:Superscript, subscript and undadline
13:48
06: Custom date creation and neumeric entry
14:57
07: Rap text and aline text
11:04
Forming Basics
0/7
08: Conditional formating
09:07
09: Conditional formating logic
10:53
10: Newmeric format
11:04
11: Special format
09:21
12: Marge and Center-Indenting
09:59
13: Row and column formating
09:49
14: Move, Copy, Insert, Find, Replace
09:01
Simple Formula of Excel
0/6
15: Simple formula
08:14
16:Sum and Average
08:56
17: Hyararki operation, insert function
14:44
18: Use of PMT
12:03
19: Use of Absolute Relative Reference
12:23
20:Mixed reference usage
09:46
Application of logical function
0/6
21: Use of If Function and Nested If
14:47
22: Use of End, Or and Knots with If function
14:43
23: Vilook up, H Luke up-Aprooxymate match use
13:23
24:Vilook up, H Luke-Usexct match use
08:18
25: Large Viluk up, use of Chuz function
13:32
26: Match-index
09:50
Usage of Statistical Function
0/2
27: Use of Median-Mode
12:06
28: Max, Min, Count Blank use
11:45
Use of Math function in Excel
0/3
29:Round use
15:22
30: Use of Trunk-int-Aud-Mod
11:06
31:Random-convert use
09:32
Application of a date-time function in Excel
0/4
32:Date-time Basics
12:46
33:Date time function
15:08
34:WickDay-NetworkDay
13:52
35: Date Def-edet-imanth
12:49
Advance formula of Excel
0/5
36: Formula-unique
18:08
37:Frequency distribution-transpos
18:09
38:Find Formula-Auditing Tools
15:54
39: Ro-Column Reference-Copy Column
09:13
40:Formula-Valus-Update
10:02
Pivot table Basics
0/5
41: Pivot table introduction
10:58
42: Recomend-Pivoting Pivot Table
09:49
43: Configur Pivot-Extternal
06:15
44:Consolidating Identical-Menager
14:56
45:Sub-Grand Total-Samarium Table
14:56
Pivot table intermediate
0/5
46: Sorting data-column short
07:27
47:Selection-filter rule
12:37
48:Search filter-slicer-format
12:37
49: Report filter-clearing
12:37
50:Conditional Rules-Top-New
12:37
Pivot table Advanced
0/6
51: Data Bars, Color Scales
13:48
52:Creative Pivot Chart
14:56
53:Filter Pivot Chart-format PC
08:00
54: Change Leaut-chainze chart type
12:37
55: Printing Pivot Table and Chart
12:37
56:Recording and reviews Macro
12:37
Excel chart is basic
0/7
57:Xel chart basic
12:37
58: Building chart
11:59
59: Sparkline-Chart build
11:17
60: Ed Element-Quick Leout
12:37
61: Switch Ro-Column, Change Leout of Source Data
06:10
62: Axis modifi-chart title-link title
12:37
Draft Lesson
Excel chart advanced
0/5
63: Data levels-data tables
12:37
64: Eror's Bars, Gridline Legends
12:37
65: Line-Trendlines
12:37
66:Use Picture - Ed Sheep and Aero
12:37
67: Printing Page Leout, Page Brake Preview
12:37
File sharing and security
0/3
69: Protect Worksheet-Workbook
12:36
70:Sharing-tracking worksheet
12:37
68:Worksheet view, split screen
12:37
MS Word Basic Text Formating
0/5
71:M S Word 2019 User Interface Introduction
12:37
72:Edit text-cut-copy-paste-find-replace command
12:37
73: Edit text-font-case
12:37
74: Pargraph-format
12:37
75: Text in column-table
12:37
MS Word Page Forming
0/7
76: Page formating-leaut-header
12:37
77: Section header-footer
09:33
78: Bullets-numbering
09:03
79:Ellustrate document-Shape-Icons
14:36
80: Auto-caract proofing
07:38
81:Spelling and Grammar
07:14
82: Print-password
08:58
Mail Merge Details
0/3
84: Match field-address block
09:56
85: Merge
09:21
83: Merge the email
00:00
Envelope-levels details
0/4
86: Envelope-levels
14:15
87: Global Phil in
07:04
88: Specific Phil in
10:05
89: Ask Command
09:32
MS Word form is made
0/11
90: Introduction to Form-Developer Tab Interface
12:36
91:formating forms
09:09
92: Controls-Rich-Plain text
08:26
93: Combo box-drop down list
07:41
94: Date Picker-Check box control
07:10
95: Rippit Control-Picture Content Control
05:41
96:Restrict Editing-Group in Control
11:34
97: Word template
05:14
98: Understanding the building block
04:24
99: Building and Save Building Blocks
10:47
100:Developer Control-Building Block
06:05
Power Point Introduction
0/5
101: Introduction to the user interface of Power Point 2019
12:36
102: Discussions on Power Point Theme
12:43
103:Talk about chaining and slide master
09:29
104: Header-Footer-Bakestage Views
07:16
105: Editing the slide
12:43
Various tools of power points
0/15
106: Leout Changing-Section-Rerenge
12:43
107: Use Picture Editing-Guide
11:59
108: Formatting the Picture
12:43
109:Object layering-Rimov background
12:43
110: Use the Eye Dropper Tool
12:43
111: Bullets-numbering-outline text
12:43
112:Ward Art-Text Box
12:43
113: Tables
12:43
114: Ed Sheeps-format Shaipes
12:43
115: Picture cropping
12:43
116: Creating chart
12:43
117: Smart Art-Equation
12:43
118: Editing video-Audio
12:43
119: Slide transition - Animation
12:43
120: Speaker note-handwatt-rehars
12:43
Power Point Slide Presentation Technique
0/7
121: Editing the comment
04:13
122: Presenter view
08:46
123: Save theme-print
06:08
124:Save Power Point Edge Template
08:02
125: Save Power Point Edge PDF/JPG format
07:55
126: Morf animation made
06:59
127: Source content of Microsoft Office font-picture-icon etc
06:10
Microsoft Office Expert: Excel, Word, PowerPoint
Exercise Files
Tutorial 03 – Formatting Finish.xlsx
Size: 128.27 KB
Tutorial 03 – Formatting.xlsx
Size: 129.59 KB
Previous
Next
0% Complete