Excel for Multiple Sheets and Workbooks

(0 review)
View cart
Excel for Multiple Sheets and Workbooks

A lot of people need to work with Excel workbooks comprising a large number of worksheets. Or many others need to merge, copy, consolidate the data sitting in different Excel workbooks. In this course, I am going to teach you the techniques that will help you to manage and work with multiple sheets and workbooks.

Course Features

  • Lectures 20
  • Quizzes 1
  • Duration 1:20 Hours
  • Skill level All level
  • Language Urdu
  • Students 0
  • Assessments Self
  • Chapter 1: Introduction

    • Lecture 1.1 Welcome Locked 0m
    • Lecture 1.2 Exercise Files Locked 0m
  • Chapter 2: Basic Tasks With Multiple Sheets

    • Lecture 2.1 Basic Navigation Tips Part 1 Locked 0m
    • Lecture 2.2 Basic Navigation Tips Part 2 Locked 0m
    • Lecture 2.3 Adding and Deleting Multiple sheets Locked 0m
    • Lecture 2.4 Copying and Moving Sheets Within a Workbook Locked 0m
    • Lecture 2.5 Changing Sheet Tab Colors Locked 0m
    • Lecture 2.6 Hiding and Unhiding Worksheets Locked 0m
  • Chapter 3: Working with Multiple Sheets

    • Lecture 3.1 Displaying Multiple Sheets From Single Workbook Locked 0m
    • Lecture 3.2 Moving, Copying Data Between Sheets Locked 0m
    • Lecture 3.3 Making Changes to Multiple Sheets Simulatneously Locked 0m
  • Chapter 4: Linking Worksheet with Formulas

    • Lecture 4.1 Creating Linkage Formula Locked 0m
    • Lecture 4.2 Creating 3D Formula Locked 0m
    • Lecture 4.3 Cosolidated Table Locked 0m
  • Chapter 5: Working With Multiple Workbooks

    • Lecture 5.1 Navigating Between Opened Workbooks Locked 0m
    • Lecture 5.2 Displaying Multiple Workbooks Locked 0m
    • Lecture 5.3 Copying and Moving Data Between Wokrbooks Locked 0m
  • Chapter 6:

    • Lecture 6.1 Linking Formula for Multiple Workbooks Locked 0m
    • Lecture 6.2 Locating and Managing Links Between Workbooks Locked 0m
    • Lecture 6.3 Cosolidating Data Over Multiple Workbooks Locked 0m
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).


Average Rating

0 rating

Detailed Rating

5 stars
4 stars
3 stars
2 stars
1 stars