In This Course You can Free Learn complete Microsoft Excel 2013 in Urdu and Hindi Language(Basic to advanced Level with Viedo Tutorial By Muhammad Nouman Qureshi. You Can Learn What Is Microsoft Excel, Tour Of Excel Workspace, The work Book Window, Resizing the Work Book Window, Navigating in work Sheet Working with Menu and Dialog Boxes, Working With Shortcut Menus, Working with Quick Access tool BAr, Working with Formula Bar Exiting Microsoft excel Creating New Files & Templates, Opening and Saving Files Making Selections, Entering Data, Entering Numeric Values Entering Text Values Editing Replacing and Deleting Data, Using undo Redo, Creating Formula Precedence Of Operators Using Cell References in formula, Usin Sheet References in Formula, Editing Formulas Using Text Values in Formula, Selecting and Deleting All work Sheet Data Assingning Names to Ranges Using Auto sum Funtions Using Functions Assigning And Removing Formats, formatting Numbers and Text Horizontal Text Alignment Centering Text across Columns The Fill Option Justify and Wrap Text Option, Vertical Text Alignment Text Orientation and Rotation Formatting Fonts Adding Color's Patterns Adding Graphics Backgroud to Wordsheet, Apply Conditional Formatting, Merging Cells, Controlling Column Width Controlling Row Height, Auto Format Option And Deleting Rows And Columns (Mouse), Filling and Creating Series, Clearing Cell Constants and Formats, Inserting Column and row, Deleting Cell, Rows and Columns Filling Cell Ranges with Data Finding Data, Replacing Data, Spelling Check, Controlling the Appearance of Pages, Printing Sheets, Creating a New Chart Formatting & Editing Charts, Slective Pasting, Working with Multiple Workbooks, Sorting Lists, Using Filter to Analyze Lists Pivot Table and many more.
Topic List (Click On any Lesson and Watch Tutorial)
1. Start Microsoft Excel
2. Tour Of Excel Workspace3. The Work Book Window
4. Resizing the Work Book Window
5. Navigating in work Sheet
6. Working With Menu & Dialog Boxes
7. Working with Shortcut Menus
8. Working with Quick Access Tools Bar
9. 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 Replaqcing & Deleting Data
18. Using Undo and Redo
19. Creating Formula
20. Precedence of Operators
21. Using Cell References in Formula
22. Using Sheet References in Formula
23. Editing formulas
24. Using Text Values in Formula
25. Seleting & Deleting All Work Sheet Data
26. Assigning NAmes To Ranges
27. Using Auto Sum Functions
28. USing Functions
29. Assigning & Removing Formats
30. Formatting Numbers & Text
31. Horizontal Twext Alignment
32. Centering Text Across Columns
33. The Fill Option
34. Justify & Wrap Text Options
35. Vertical Text Alignment
36. Text Orientation and Rotation
37. Formatting Fonts
38. Adding Custom Borders
39. Adding Color's Patters
40. Adding Graphics Background to Worksheet
41. Apply conditional Formatting
42. Merging Cells
43. Controlling Column Width
44. Controlling Row Height
45. Auto format Option
46. Copying & Moving Data
47. Copying Formulas
48. Copying & Moving Columns
49. Inserting Deleting Rows & Columns (Mouse)
50. Filling & Creating Series
51. Clearing Cell Constants & Formats
52. Inserting Columns & Row
53. Deleting Cell, Rows & Columns
54. Filling Data
55. Finding
56. Replacing Data
57. Spelling Check
58. Controlling the Appearance of Pages
59. Printing Sheets
60. Creating a New Char
61. Formatting & Editing Charts
62. Paste Special
63. Working with Multiple Workbooks
64. Freeze Panes
65. Sorting Lists
66. Using Filter To Analyze Lists
67. Pivot Table
68. Text to Columns
69. Data Validation
70. Password
Any More......
No comments:
Post a Comment