Free now and forever through Sabaq.pk website
For Schools
About Us
Media
Success
Sign In
Free now and forever thru Sabaq.pk website
Create advanced formulas
Sabaq Skills
Excel Expert
Excel Expert Certification (
Total Videos: 73
)
Preference
All Chapters
Chapter 1: Manage Workbook options and settings
Chapter 2: Apply custom data formats and layouts
Chapter 3: Create advanced formulas
Chapter 4: Create advanced charts and tables
Show Content
Select a chapter above and press 'Show Content'. Click a video topic below to view.
Chapter 3 Create advanced formulas (
30 videos
)
  (
Practice Test
)
3.1: Apply functions in formulas (
Practice Test
)
Perform logical operations using IF, AND, OR, and NOT functions
Perform logical operations by using nested functions
Perform statistical operations by using the SUMIFS,
AVERAGEIFS, and COUNTIFS functions
Section exercise 3-1
More on Section exercise 3-1
3.2: Lookup data using functions (
Practice Test
)
Lookup data by using VLOOKUP
Lookup data by using HLOOKUP
More Lookup functions: Match and Index
Section exercise 3-2
3.3: Apply advanced date and time functions (
Practice Test
)
Reference the date and time by using the NOW and TODAY functions
More date functions in Excel
Time functions in Excel
Section exercise 3.3
3.4: Perform data analysis and business intelligence (
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
Section exercise Project 1
Section exercise Project 2
Section exercise Project 3
Section exercise Project 4
3.5: Troubleshoot formulas
Troubleshoot formulas
Section exercise 3.5
3.6: Define named ranges and object
Define name ranges and objects
Section exercise 3.6
Facebook
Twitter
Instagram
Youtube
Linkedin