Training Links Pakistan.


e-mail:
info@VtrainU.com  Mobile: +92 21 300 2363870, +92 21 320 4035268
CD Training, CD Training, CD Training, computer based training, computer based training


Home  |  Training CDs  |   Services  |  Press Release  |  FAQ  |  Certificate  |  Contact us


    MS Excel Contents

c

01-Starting Microsoft Excel
02-Tour of Excel Workspace
03-The Workbook Window
04-Resizing the Workbook Window
05-Navigating in Worksheet
06-Working with Menus & Dialog Boxes
07-Working with Shortcut Menus
08. Working with Tool Bars
09. Working with Formula Bar
10. Exiting Microsoft Excel
11. Creating New Files & Templates
12. Opening & Saving Files
13. Making Selections
14. Entering Data
15. Entering Numeric Values
16. Entering Text Values
17. Editing Replacing & Deleting Data
18. Using Undo and Redo
19. Creating Formulas
20. Precedence of Operators
21. Using Cell References in Formulas
22. Using Sheet References in Formulas
23. Editing Formulas
24. Using Text Values in Formulas
25. Selecting & Deleting All Worksheet Data
26. Assigning Names to Ranges
27. Using AutoSum Functions
28. Using Functions
29. Assigning & Removing Formats
30. Formatting Numbers & Text
31. Horizontal Text Alignment
32. Centering Text Across Columns
33. The fill Option
34. Justify and Wrap Text Options
35. Vertical Text Alignment
36. Text Orientation and Rotation
37. Formatting Fonts
38. Adding Custom Borders
39. Adding Colors and Patterns
40. Adding Graphic Background to Worksheet
41. Applying Conditional Formatting
42. Merging Cells
43. Controlling Column Width
44. Controlling Row height
45. Auto Format Options
46. Copying and Moving data
47. Copying Formulas
48. Copying & Moving Columns
49. Inserting & Deleting Rows & Col.  (Mouse)
50. Filling & Creating Series
51. Clearing Cell Contents & Formats
52. Inserting Columns & Rows
53. Deleting Cells, Rows & Columns
54. Filling Cell Ranges with Data
55. Finding data
56. Replacing Data
57. Spelling Check
58. Controlling the Appearance of Pages
59. Printing Sheets
60. Creating a New Chart
61. Formatting & Editing Charts
62. Selective Pasting
63. Working with Multiple Workbooks
64. .Sorting Lists
65. Using Filter to Analyze Lists
66. Pivot Table
67. Exercise 01
68. Exercise 02
69. Exercise 03
70. Exercise 04

Payment except by Money Order / Western Union only in the name of Training Links.



Home  |  Training CDs  |   Services  |  Press Release  |  FAQ  |  Certificate  |  Contact us

Training Links Copyright 2003