Microsoft Office 2010 Advanced Excel Online Certified Course
Chapter
1 : Applying Range Names to Formula
Chapter
3 : Autofill and Custom List
Chapter
4 : Autosum Row and Column Reference
Chapter
5 : Centering the Worksheet Data
Chapter
6 : Changing Label Orientation
Chapter
7 : Changing Worksheet in One Go
Chapter
8 : Column Label Change in Number Label
Chapter
9 : Comment Shape
Chapter
11 : Conditional formating
Chapter
12 : Conditional Formatting with Mod Function
Chapter
13 : Controlling Display of the Scrollbar
Chapter
14 : Convert Function
Chapter
15 : Copy Numbers Only
Chapter
16 : Countblank Counta
Chapter
17 : Countif, Sumif and Averageif Function
Chapter
18 : Create Bar Graph
Chapter
19 : Create Button
Chapter
20 : Creating Combo Box
Chapter
21 : Cycle Font Color
Chapter
22 : Data Validation
Chapter
23 : Deleting Graphics When Deleting Rows
Chapter
24 : Dependent Dropdown List
Chapter
25 : Entered Values are Divided by 100
Chapter
26 : Enterkey Behaviour
Chapter
27 : Find Search and Mid function
Chapter
28 : Formula Copy
Chapter
29 : Gride Line Color and Formula Bar Off and On
Chapter
30 : Hide Graphics
Chapter
31 : Hiding Error On Printout
Chapter
32 : Hlookup Function
Chapter
34 : If, OR, AND Function
Chapter
35 : Index Function
Chapter
36 : Information Function
Chapter
37 : Insert and Edit Data Multiple Worksheet
Chapter
38 : Insert Sheets
Chapter
39 : Insert Total Row
Chapter
40 : Insert Watermark
Chapter
41 : Large and Small Function
Chapter
42 : Left and Right Function
Chapter
43 : Lookup Formula
Chapter
44 : Macro Function
Chapter
45 : Manipulating Objects
Chapter
46 : Match and Index Function
Chapter
47 : Match Function
Chapter
48 : Mod Function
Chapter
49 : More Text Function
Chapter
51 : Open a Copy of Workbook
Chapter
53 : Print Comment In Excel
Chapter
54 : Print Gridlines and Headings
Chapter
55 : Printing a Draft of Worksheet
Chapter
56 : Printing a Portion of Worksheet
Chapter
57 : Printing Rows Conditionally
Chapter
58 : Printing Without Opening Workbooks
Chapter
59 : Print Page Number at the Bottom of Each
Chapter
60 : Print Several Worksheet on Single Page
Chapter
61 : Proper, Upper and Lower Function
Chapter
62 : Quickly Copy Formula
Chapter
63 : Quickly Insert Current Date and Time
Chapter
64 : Quickly Transpose
Chapter
65 : Rank Function
Chapter
66 : Replace and Substitute Function
Chapter
68 : Selecting Group of Cells
Chapter
69 : Selecting Ranges with Keyboard
Chapter
70 : Share Workbook
Chapter
71 : Shortcut to Viewing Formulas
Chapter
72 : Spelling Check
Chapter
73 : Split Column Data
Chapter
74 : Switch Between Workbooks
Chapter
75 : Text Convert Number
Chapter
76 : Text Function
Chapter
77 : Transpose Function
Chapter
78 : Trick to Changed Predefined Group Name
Chapter
79 : Trick to Create Own New Tab
Chapter
80 : Trick to Insert Picture Comment
Chapter
81 : Trick to Open Specific Workbooks
Chapter
82 : Turn Off and On Worksheet and Scrollbar
Chapter
83 : Unprotect Spreadsheet
Chapter
84 : Vlookup Function
Chapter
85 : Weekday Function