Part 8 Excel Text Formulas

bahttext,
CHAR,
CLEAN,
CODE,
CONCATENATE,
DOLLER,
EXACT,
ASCII CODE,
CHANGE ASCII TO CHAR,
CHANGE CHAR TO ASCII,
REMOVE NONPRINTABLE CHAR,
Add strings or text,
matching the text,
put doller sign & fix decimal point

Part 7 Excel IF NOT OR

IF,
NOT,
OR,
LOGICAL FORMULAS,
Nested Conditions,
Logical formulas examples

Part 8 HTML Table

table,
tr,
th,
td,
caption,
colgroup,
col,
thead,
tbody,
tfoot,
colspan,
rowspan,
border,
padding,
border-spacing,
text alignment in table,

Part 7 HTML div span meter progress dialog

div, span, meter, progress, dialog,
Grouping Tags, Containers, Block Level Elements,
Line Level Elements,
scalar measurement,
Dialog Box,
value, min, max,

Part 5 Excel Lookup & Reference

VLOOKUP,
IFNA,
IFERROR,

Part 4 Excel LOGICAL FORMULAS

if,
count,
and,
or,
nested if,
chained if,
true,
false

Part 3 MS Excel

if,
count,
and,
or,
nested if,
chained if,
Division calculation Exercise,
Percantage calculation

Part 2 MS Excel

autosum,
Sum, Average, Count,
Max, Min, Maximum, Minimum,
Sort & Filter,
Editing,
fill,
clear,
Ascending order,
Descending Order,

HTML Part 6

HTML List,
ul,
ol,
dl,
Unordered list,
List-style-type,
Ordered list,
Description list,
Child elements,
dt,
data term,
dd,
Data description,
a,
href,
target,
Link,
Hyperlink,
audio,
video,
audio src,
audio loop,
audio controls,
audio autoplay,
source child element,
source, type,
video src,
video loop,
video controls,
video 

      autoplay

Part 1 MS Excel

Home Tab,
Conditional Formatting,
Format as Table,
Format,
Alignment,

Part 10 MS Word

View,
Show,
Zoom,
window,
Synchronous Scrolling,
Asynchronous Scrolling,
Arrange Windows,
Switch Windows,
Read Mode,
Print Layout,
Web Layout,
outline view,
draft view,
Ruler,
gridlines,
navigation pane,
one page zoom,
multiple page zoom,
split window,
view side by side

Part 9 MS Word

Mail merge
mailing in word
sending mail to multiple persons with same content on the one go

Part 8 MS Word

Design Tab
Watermark, page color & page borders etc.
Layout Tab
Page setup & paragraph settings
hyphenation