Excel 2013 Urdu Tutorial
Rs.1,000
Welcome
Excel 2013 Urdu Tutorial is a complete guide. If you really willing to learn Excel 2013, then it is the perfect guide for you. This course cover each and every aspect of Excel 2013 . It starts from the description of the interface. Then it gradually moves toward advanced topics. This course not only covers the basics. But it also explain intermediate and advanced techniques.
Some of the topics covered are as under:
- Use of Pivot Table
- Use of Macros
- Use of Functions
- Use of Formulas.
Excel is the most widely used application around the world. About 90% PC users have it installed. There is an interesting fact about Microsoft Excel that Graphical User Interface was invented to support the spreadsheet programs.
Course Features
- Lectures 78
- Quizzes 1
- Duration 6 Hours
- Skill level All level
- Language Urdu
- Students 0
- Assessments Self
-
Chapter 1: Introduction
- Lecture 1.1 Welcome
- Lecture 1.2 Use of Exercise Files
-
Chapter 2: Getting Started With Excel 2013
- Lecture 2.1 Excel Usage
- Lecture 2.2 Excel Ribbon and Tabs
- Lecture 2.3 Quick Access Tool Bar
- Lecture 2.4 Workbook and Work Sheets
- Lecture 2.5 Formula Bar
- Lecture 2.6 Status Bar
- Lecture 2.7 Navigation
- Lecture 2.8 Shortcut Menu
- Lecture 2.9 Back Stage Area
-
Chapter 3: Entering Data
- Lecture 3.1 Data Entry Locked
- Lecture 3.2 Using Auto Fill Function Locked
- Lecture 3.3 Entering Date and Time Locked
- Lecture 3.4 Using Undo and Redo Locked
- Lecture 3.5 Using Comments Locked
- Lecture 3.6 Saving Files Locked
-
Chapter 4: Creating Formulas and Functions
- Lecture 4.1 Simple Formulas Locked
- Lecture 4.2 Copying Formulas Locked
- Lecture 4.3 YTD Formula Locked
- Lecture 4.4 Percentage Increase Locked
- Lecture 4.5 Absolute and Relative Reference Locked
- Lecture 4.6 Auto Sum and Auto Average Locked
- Lecture 4.7 Some More Functions Locked
-
Chapter 5: Formating
- Lecture 5.1 Formating Fonts Locked
- Lecture 5.2 Rows Columns Width and Height Locked
- Lecture 5.3 Text Allignment Locked
- Lecture 5.4 Applying Borders Locked
- Lecture 5.5 Formating Numbers Locked
- Lecture 5.6 Formating Date and Time Locked
- Lecture 5.7 Conditional Formating Locked
- Lecture 5.8 Using Tables Locked
- Lecture 5.9 Inserting Visuals Locked
-
Chapter 6: Adjusting Worksheet Layout and Data
- Lecture 6.1 Adding Deleting Rows and Columns Locked
- Lecture 6.2 Hide Unhide Rows and Columns Locked
- Lecture 6.3 Move and Copy Locked
- Lecture 6.4 Find and Replace Data Locked
-
Chapter 7: Printing
- Lecture 7.1 Page and Layout Locked
- Lecture 7.2 Using Page Break Preview Locked
- Lecture 7.3 Page Setup Locked
-
Chapter 8: Charts
- Lecture 8.1 Creating Charts Locked
- Lecture 8.2 Chart Types Locked
- Lecture 8.3 Formating Charts Locked
- Lecture 8.4 Chart Elements Locked
- Lecture 8.5 Using Spark Line Locked
-
Chapter 9: Adjusting Worksheet Views
- Lecture 9.1 Freezing and Unfreezing Locked
- Lecture 9.2 Using Split Screen Locked
- Lecture 9.3 Using Outline Locked
-
Chapter 10: Multiple Worksheet and Workbook
- Lecture 10.1 Adding Deleting Renaming Sheets Locked
- Lecture 10.2 Copy or Move Worksheets Locked
- Lecture 10.3 Linking Formulas Locked
-
Chapter 11: If Vlookup and Power Functions
- Lecture 11.1 Using If Functions Locked
- Lecture 11.2 VLookup Approximate Locked
- Lecture 11.3 VLookup Exact Match Locked
- Lecture 11.4 Sumif Countif and AverageIf Locked
-
Chapter 12: Security and Sharing
- Lecture 12.1 Protecting Worksheet Locked
- Lecture 12.2 Protecting Workbook Locked
- Lecture 12.3 Password Protected Workbook Locked
- Lecture 12.4 Sharing Workbook Locked
- Lecture 12.5 Tracking Changes Locked
-
Chapter 13: The Database Feature
- Lecture 13.1 Sorting Locked
- Lecture 13.2 Using Subtotals Locked
- Lecture 13.3 Using Filters Locked
- Lecture 13.4 Splitting Data Locked
- Lecture 13.5 Removing Duplicate Values Locked
-
Chapter 14: Pivot Tables
- Lecture 14.1 Creating Pivot Table Locked
- Lecture 14.2 Manipulating Pivot Table Locked
- Lecture 14.3 Creating Groups Locked
- Lecture 14.4 Grouping Others Locked
- Lecture 14.5 Using Slicer Locked
- Lecture 14.6 Pivot Chart Locked
-
Chapter 15: Data Analysis Tool
- Lecture 15.1 Using Goal Seek Locked
- Lecture 15.2 Using Solver Locked
- Lecture 15.3 Using Scenario Manager Locked
- Lecture 15.4 Using Data Tables Locked
-
Chapter 16: Introduction to Macros
- Lecture 16.1 What are Macros Locked
- Lecture 16.2 Recording Macros Locked
- Lecture 16.3 Running Macros Locked