Free now and forever through Sabaq.pk website
For Schools
About Us
Media
Success
Sign In
Free now and forever thru Sabaq.pk website
Apply custom data formats and layouts
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 2 Apply custom data formats and layouts (
17 videos
)
  (
Practice Test
)
2.1: Apply custom data formats and validation (
Practice Test
)
Create custom data formats
More Custome format in Excel
Date and time custom formatting in Excel
Time custom format
Section exercise 2.1 Project 1
Section exercise 2.1 Project 2
Section exercise 2.1 Project 3
2.2: Apply advanced conditional formatting and filtering (
Practice Test
)
Configure Data Validation
Create custom conditional formatting rules
Create custom conditional formatting rules that use formulas
Section exercise 2.2 Project 1
Section exercise 2.2 Project 2
Section exercise 2.2 Project 3
2.3: Create and modify custom workbook elements (
Practice Test
)
Create custom themes and theme elements
Insert and configure form controls
Section exercise 2.3 Project 2
2.4: Prepare a workbook for internationalization
Section exercise 2.4
Facebook
Twitter
Instagram
Youtube
Linkedin