Free now and forever through Sabaq.pk website
For Schools
About Us
Media
Success
Sign In
Free now and forever thru Sabaq.pk website
Data Analysis
Sabaq Skills
Excel by Topic
Excel by Topic (
Total Videos: 67
)
Preference
All Chapters
Chapter 1: Introduction to Excel
Chapter 2: Rows and Columns
Chapter 3: Cells
Chapter 4: Formatting
Chapter 5: Formulas and Functions
Chapter 6: Tables
Chapter 7: Charts
Chapter 8: Manage Workbooks
Chapter 9: Pivot tables
Chapter 10: Data Analysis
Show Content
Select a chapter above and press 'Show Content'. Click a video topic below to view.
Chapter 10 Data Analysis (
8 videos
)
  (
Practice Test
)
10.1: Data Analysis (
Practice Test
)
Import, transform, connect to data
Combine and display data in Excel
Consolidate data by using position and category
Static and Linked Consolidation
Perform what-if analysis by using Goal Seek and Scenario Manager
Perform what-if analysis by using Scenario Manager
Perform what-if analysis by using Data table
Calculate data by using financial functions
Facebook
Twitter
Instagram
Youtube
Linkedin