Excel for Multiple Sheets and Workbooks
Rs.500
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
- Lecture 1.2 Exercise Files Locked
-
Chapter 2: Basic Tasks With Multiple Sheets
- Lecture 2.1 Basic Navigation Tips Part 1 Locked
- Lecture 2.2 Basic Navigation Tips Part 2 Locked
- Lecture 2.3 Adding and Deleting Multiple sheets Locked
- Lecture 2.4 Copying and Moving Sheets Within a Workbook Locked
- Lecture 2.5 Changing Sheet Tab Colors Locked
- Lecture 2.6 Hiding and Unhiding Worksheets Locked
-
Chapter 3: Working with Multiple Sheets
- Lecture 3.1 Displaying Multiple Sheets From Single Workbook Locked
- Lecture 3.2 Moving, Copying Data Between Sheets Locked
- Lecture 3.3 Making Changes to Multiple Sheets Simulatneously Locked
-
Chapter 4: Linking Worksheet with Formulas
- Lecture 4.1 Creating Linkage Formula Locked
- Lecture 4.2 Creating 3D Formula Locked
- Lecture 4.3 Cosolidated Table Locked
-
Chapter 5: Working With Multiple Workbooks
- Lecture 5.1 Navigating Between Opened Workbooks Locked
- Lecture 5.2 Displaying Multiple Workbooks Locked
- Lecture 5.3 Copying and Moving Data Between Wokrbooks Locked
-
Chapter 6:
- Lecture 6.1 Linking Formula for Multiple Workbooks Locked
- Lecture 6.2 Locating and Managing Links Between Workbooks Locked
- Lecture 6.3 Cosolidating Data Over Multiple Workbooks Locked