Free now and forever through Sabaq.pk website
For Schools
About Us
Media
Success
Sign In
Free now and forever thru Sabaq.pk website
Formulas and Functions
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 5 Formulas and Functions (
16 videos
)
  (
Practice Test
)
5.1: Formulas and Functions (
Practice Test
)
Summarize data using functions
Conditional functions using IF and COUNTIF
Format, Modify and Combine text using functions
Conditional functions IF and AVERAGEIF
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
Lookup data by using VLOOKUP
Lookup data by using HLOOKUP
More Lookup functions: Match and Index
Reference the date and time by using the NOW and TODAY functions
More date functions in Excel
Time functions in Excel
Troubleshoot formulas
Define name ranges and objects
Facebook
Twitter
Instagram
Youtube
Linkedin