Excel 2013 Urdu Tutorial

Awais Kamran
(0 review)
Rs.1,000
View cart
Excel 2013 Urdu Tutorial

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

  • Chapter 2: Getting Started With Excel 2013

  • Chapter 3: Entering Data

    • Lecture 3.1 Data Entry Locked 0m
    • Lecture 3.2 Using Auto Fill Function Locked 0m
    • Lecture 3.3 Entering Date and Time Locked 0m
    • Lecture 3.4 Using Undo and Redo Locked 0m
    • Lecture 3.5 Using Comments Locked 0m
    • Lecture 3.6 Saving Files Locked 0m

  • Chapter 4: Creating Formulas and Functions

    • Lecture 4.1 Simple Formulas Locked 0m
    • Lecture 4.2 Copying Formulas Locked 0m
    • Lecture 4.3 YTD Formula Locked 0m
    • Lecture 4.4 Percentage Increase Locked 0m
    • Lecture 4.5 Absolute and Relative Reference Locked 0m
    • Lecture 4.6 Auto Sum and Auto Average Locked 0m
    • Lecture 4.7 Some More Functions Locked 0m

  • Chapter 5: Formating

    • Lecture 5.1 Formating Fonts Locked 0m
    • Lecture 5.2 Rows Columns Width and Height Locked 0m
    • Lecture 5.3 Text Allignment Locked 0m
    • Lecture 5.4 Applying Borders Locked 0m
    • Lecture 5.5 Formating Numbers Locked 0m
    • Lecture 5.6 Formating Date and Time Locked 0m
    • Lecture 5.7 Conditional Formating Locked 0m
    • Lecture 5.8 Using Tables Locked 0m
    • Lecture 5.9 Inserting Visuals Locked 0m

  • Chapter 6: Adjusting Worksheet Layout and Data

    • Lecture 6.1 Adding Deleting Rows and Columns Locked 0m
    • Lecture 6.2 Hide Unhide Rows and Columns Locked 0m
    • Lecture 6.3 Move and Copy Locked 0m
    • Lecture 6.4 Find and Replace Data Locked 0m

  • Chapter 7: Printing

    • Lecture 7.1 Page and Layout Locked 0m
    • Lecture 7.2 Using Page Break Preview Locked 0m
    • Lecture 7.3 Page Setup Locked 0m

  • Chapter 8: Charts

    • Lecture 8.1 Creating Charts Locked 0m
    • Lecture 8.2 Chart Types Locked 0m
    • Lecture 8.3 Formating Charts Locked 0m
    • Lecture 8.4 Chart Elements Locked 0m
    • Lecture 8.5 Using Spark Line Locked 0m

  • Chapter 9: Adjusting Worksheet Views

    • Lecture 9.1 Freezing and Unfreezing Locked 0m
    • Lecture 9.2 Using Split Screen Locked 0m
    • Lecture 9.3 Using Outline Locked 0m

  • Chapter 10: Multiple Worksheet and Workbook

    • Lecture 10.1 Adding Deleting Renaming Sheets Locked 0m
    • Lecture 10.2 Copy or Move Worksheets Locked 0m
    • Lecture 10.3 Linking Formulas Locked 0m

  • Chapter 11: If Vlookup and Power Functions

    • Lecture 11.1 Using If Functions Locked 0m
    • Lecture 11.2 VLookup Approximate Locked 0m
    • Lecture 11.3 VLookup Exact Match Locked 0m
    • Lecture 11.4 Sumif Countif and AverageIf Locked 0m

  • Chapter 12: Security and Sharing

    • Lecture 12.1 Protecting Worksheet Locked 0m
    • Lecture 12.2 Protecting Workbook Locked 0m
    • Lecture 12.3 Password Protected Workbook Locked 0m
    • Lecture 12.4 Sharing Workbook Locked 0m
    • Lecture 12.5 Tracking Changes Locked 0m

  • Chapter 13: The Database Feature

    • Lecture 13.1 Sorting Locked 0m
    • Lecture 13.2 Using Subtotals Locked 0m
    • Lecture 13.3 Using Filters Locked 0m
    • Lecture 13.4 Splitting Data Locked 0m
    • Lecture 13.5 Removing Duplicate Values Locked 0m

  • Chapter 14: Pivot Tables

    • Lecture 14.1 Creating Pivot Table Locked 0m
    • Lecture 14.2 Manipulating Pivot Table Locked 0m
    • Lecture 14.3 Creating Groups Locked 0m
    • Lecture 14.4 Grouping Others Locked 0m
    • Lecture 14.5 Using Slicer Locked 0m
    • Lecture 14.6 Pivot Chart Locked 0m

  • Chapter 15: Data Analysis Tool

    • Lecture 15.1 Using Goal Seek Locked 0m
    • Lecture 15.2 Using Solver Locked 0m
    • Lecture 15.3 Using Scenario Manager Locked 0m
    • Lecture 15.4 Using Data Tables Locked 0m

  • Chapter 16: Introduction to Macros

    • Lecture 16.1 What are Macros Locked 0m
    • Lecture 16.2 Recording Macros Locked 0m
    • Lecture 16.3 Running Macros Locked 0m
Awais Kamran
Awais Kamran has been in the field of IT and Teaching for last 10 Years. Having a dual master degree in Computer Science and Commerce, he has been serving in the top educational institute of Pakistan "Punjab Group Of Colleges". He is the pioneer of Urdu Video Tutorials in Urdu language. He has completed more than 50 Urdu Video Tutorials in last 7 years. Beside coaching, he is an expert Web Developer and Search Engine Optimizer. He belongs to the city of Saints (Multan).

Reviews

Average Rating

0
0 rating

Detailed Rating

5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 stars
0
Rs.1,000
View cart