Search this site
Embedded Files
Skip to main content
Skip to navigation
SF Learning
Home
Basic knowledge
Microsoft Office
Microsoft Word
Microsoft Word Tutorial
Microsoft Excel
Microsoft Excel Tutorial
MS Office Suggestions
Advanced Excel
Shortkut Keys
Useful Formulas
VLOOKUP Formula
HLOOKUP formula
MATCH formula
INDEX Formula
INDIRECT Formula
OFFSET Formula
CHOOSE Formula
ADDRESS Formula
FIND Formula
LEN Formula
MID Formula
SUBSTITUTE Formula
TEXT Formula
TEXTJOIN Formula
TRIM Formula
DATE Formula
DATEVALUE Formula
EOMONTH Formula
NETWORKDAYS Formula
NOW Formula
TODAY Formula
AVERAGEIF Formula
COUNTIF Formula
COUNTIFS Formula
SUMIF Formula
SUMIFS Formula
SUMPRODUCT Formula
Powerful Dynamic Array Function
VLOOKUP by cell background color
AREAS Formula
COLUMN Formula
COLUMNS Formula
HYPERLINK Formula
LOOKUP Formula
ROW Formula
ROWS Formula
TRANSPOSE Formula
XLOOKUP Formula
BAHTTEXT Formula
CHAR Formula
CLEAN Formula
CODE Formula
CONCAT Formula
CONCATENATE Formula
DOLLAR Formula
EXACT Formula
FIXED Formula
LEFT Formula
LOWER Formula
NUMBERVALUE Formula
PROPER Formula
REPLACE Formula
REPT Formula
RIGHT Formula
SEARCH Formula
T Formula
UNICHAR Formula
UNICODE Formula
UPPER Formula
VALUE Formula
DATEDIF Formula
DAY Formula
DAYS Formula
DAYS360 Formula
EDATE Formula
HOUR Formula
MINUTE Formula
MONTH Formula
NETWORKDAYS.INTL Formula
SECOND Formula
TIME Formula
TIMEVALUE Formula
WEEKDAY Formula
WEEKNUM Formula
WORKDAY Formula
WORKDAY.INTL Formula
YEAR Formula
YEARFRAC Formula
AND Formula
FALSE Formula
IF Formula
IFERROR Formula
IFNA Formula
IFS Formula
NOT Formula
OR Formula
SWITCH Formula
TRUE Formula
CELL Formula
ERROR.TYPE Formula
INFO Formula
ISBLANK Formula
ISERR Formula
ISERROR Formula
ISLOGICAL Formula
ISNA Formula
ISNONTEXT Formula
ISNUMBER Formula
ISREF Formula
ISTEXT Formula
N Formula
NA Formula
TYPE Formula
Basic Charts
Line Chart
Column Chart
Bar Chart
Stacked Column Chart
Stacked Bar Chart
Pie Chart
Doughnut Chart
Area Chart
Combo Chart
Advanced Chart
Battery Chart
Speedometer Chart
Test Tube Chart
Progress Circle chart
Half Circle KPI Charts in Excel using Doughnut Charts
Moving Man Chart
Dynamic Chart with check boxes
Dynamic Variance Arrows Chart with Check Boxes
Sort And Filter
Data Sorting
Sort By Color
Data Filter
Text,Number And Date Filters
Filter By Color
Advanced Filter
Pivot Table
Insert a Pivot Table
Data Sorting in Pivot Table
Filters in Pivot Table
Value Field Settings in Pivot Table
Columns in Pivot Table
Groups/Ungroup in Pivot Table
Report Layouts In Pivot Table
Subtotals and Grand Totals
Pivot Charts
Slicers in Pivot Table
Timeline in Pivot Table
Refresh Pivot and Change Data Source
Calculated Fields/Items in Pivot Table
Show Details in Pivot table
Pivot Tables, Slicers and Timeline Styles
Data Validation
Whole Number Validation
Decimal Number Validation
List (Drop down) Creation
Date Validation
Time Validation
Text Length Validation
Custom (Formula) Validation
Input Message
Error Alert (Stop,Warning and Information)
Circle Invalid Data
Conditional Formatting
Highlight Cells Rules
Top Bottom Rules
Data Bars
Color Scales
Icon Sets
Format all cells based on their values
Format only cells that contain
Format only top or bottom ranked values
Format only values that are above or below average
Format only unique or duplicate values
Use a formula to determine which cells to format
Manage and Clear Rules
Auto Fill and Flash Fill
Fill-Down,Up,Left,Right,Series and Justify
Auto Fill and Custom List
Flash Fill
Find And Replace
Common Errors In Excel Formulas And How To Fix Them
VBA Course
Introduction
Macro Recording
Variables and Data type
Comments
Input Box and Message Box
IF THEN ELSE
Select Case
Workbooks
Worksheets
Cells and Range
Formatting
Cut, Copy and Paste
Sort and Filter
Loops in VBA
VBA and Worksheet Functions
User Defined Functions
Error Handling
ADODB Connection
Most useful VBA Command
Products
Restaurant Management System
Inventory Management System
Utility Tool
Task Management
Attendance Management
Sale/Purchase
Function Kit
Excel Dashboard
Sales Dashboard In Excel
Process Dashboard
Performance Dashboard
Project Management Dashboard
Outbound Dashboard In Excel
Incentive Dashboard In Excel
Zonal Dashboard
Quick Dashboard
C-SAT Dashboard
Free Templates
Inventory Management Template for Multiple Locations
Patient Database & Prescription
Invoice Management System
Leave Management System
Age Calculator
Digital Clock
Exam Application Form with timer
Visitors Log Book
Time Picker
Freelancing
Digital Marketing
Google Ads
Google Ads Manager Account creation
Google Ads Account creation
Linked with Client Account
Keyword Rearch
Google search ads/ PPC ads
Live project google ppc ads
Live project keyword rearch
CPA Marketing
What is cpa marketing
Why cpa marketing is best for beginners
Types of action in cpa marketing
What we need in cpa marketing
Best offer category in cpa marketing
Traffic secret for cpa marketing
How to track traffic for cpa marketing
Wrong idea on cpa marketing
How to find best cpa network
How to create account in CPA Marketing
Product research for cpa marketing
FREE CPA MARKETING 1
Banner Design from Canva
Create Landing Page
Free Traffic Method
Tumblr.com
gettr.com
qwikad.com
parler.com
pbase.com
9gag.com
minds.com
meta.stackexchange.com
qiita.com
feedly.com
bilibili.com
nairaland.com
flipboard.com
coub.com
deviantart.com
imgur.com
storeboard.com
pastebin.com
lu.ma
mastodon.social
wattpad.com
teletype.in
peakd.com
getpocket.com
pearltrees.com
Power BI
Location Map
My business site
About us
Contact us
Registration for Admission
Privacy Policy
SF Learning
Home
Basic knowledge
Microsoft Office
Microsoft Word
Microsoft Word Tutorial
Microsoft Excel
Microsoft Excel Tutorial
MS Office Suggestions
Advanced Excel
Shortkut Keys
Useful Formulas
VLOOKUP Formula
HLOOKUP formula
MATCH formula
INDEX Formula
INDIRECT Formula
OFFSET Formula
CHOOSE Formula
ADDRESS Formula
FIND Formula
LEN Formula
MID Formula
SUBSTITUTE Formula
TEXT Formula
TEXTJOIN Formula
TRIM Formula
DATE Formula
DATEVALUE Formula
EOMONTH Formula
NETWORKDAYS Formula
NOW Formula
TODAY Formula
AVERAGEIF Formula
COUNTIF Formula
COUNTIFS Formula
SUMIF Formula
SUMIFS Formula
SUMPRODUCT Formula
Powerful Dynamic Array Function
VLOOKUP by cell background color
AREAS Formula
COLUMN Formula
COLUMNS Formula
HYPERLINK Formula
LOOKUP Formula
ROW Formula
ROWS Formula
TRANSPOSE Formula
XLOOKUP Formula
BAHTTEXT Formula
CHAR Formula
CLEAN Formula
CODE Formula
CONCAT Formula
CONCATENATE Formula
DOLLAR Formula
EXACT Formula
FIXED Formula
LEFT Formula
LOWER Formula
NUMBERVALUE Formula
PROPER Formula
REPLACE Formula
REPT Formula
RIGHT Formula
SEARCH Formula
T Formula
UNICHAR Formula
UNICODE Formula
UPPER Formula
VALUE Formula
DATEDIF Formula
DAY Formula
DAYS Formula
DAYS360 Formula
EDATE Formula
HOUR Formula
MINUTE Formula
MONTH Formula
NETWORKDAYS.INTL Formula
SECOND Formula
TIME Formula
TIMEVALUE Formula
WEEKDAY Formula
WEEKNUM Formula
WORKDAY Formula
WORKDAY.INTL Formula
YEAR Formula
YEARFRAC Formula
AND Formula
FALSE Formula
IF Formula
IFERROR Formula
IFNA Formula
IFS Formula
NOT Formula
OR Formula
SWITCH Formula
TRUE Formula
CELL Formula
ERROR.TYPE Formula
INFO Formula
ISBLANK Formula
ISERR Formula
ISERROR Formula
ISLOGICAL Formula
ISNA Formula
ISNONTEXT Formula
ISNUMBER Formula
ISREF Formula
ISTEXT Formula
N Formula
NA Formula
TYPE Formula
Basic Charts
Line Chart
Column Chart
Bar Chart
Stacked Column Chart
Stacked Bar Chart
Pie Chart
Doughnut Chart
Area Chart
Combo Chart
Advanced Chart
Battery Chart
Speedometer Chart
Test Tube Chart
Progress Circle chart
Half Circle KPI Charts in Excel using Doughnut Charts
Moving Man Chart
Dynamic Chart with check boxes
Dynamic Variance Arrows Chart with Check Boxes
Sort And Filter
Data Sorting
Sort By Color
Data Filter
Text,Number And Date Filters
Filter By Color
Advanced Filter
Pivot Table
Insert a Pivot Table
Data Sorting in Pivot Table
Filters in Pivot Table
Value Field Settings in Pivot Table
Columns in Pivot Table
Groups/Ungroup in Pivot Table
Report Layouts In Pivot Table
Subtotals and Grand Totals
Pivot Charts
Slicers in Pivot Table
Timeline in Pivot Table
Refresh Pivot and Change Data Source
Calculated Fields/Items in Pivot Table
Show Details in Pivot table
Pivot Tables, Slicers and Timeline Styles
Data Validation
Whole Number Validation
Decimal Number Validation
List (Drop down) Creation
Date Validation
Time Validation
Text Length Validation
Custom (Formula) Validation
Input Message
Error Alert (Stop,Warning and Information)
Circle Invalid Data
Conditional Formatting
Highlight Cells Rules
Top Bottom Rules
Data Bars
Color Scales
Icon Sets
Format all cells based on their values
Format only cells that contain
Format only top or bottom ranked values
Format only values that are above or below average
Format only unique or duplicate values
Use a formula to determine which cells to format
Manage and Clear Rules
Auto Fill and Flash Fill
Fill-Down,Up,Left,Right,Series and Justify
Auto Fill and Custom List
Flash Fill
Find And Replace
Common Errors In Excel Formulas And How To Fix Them
VBA Course
Introduction
Macro Recording
Variables and Data type
Comments
Input Box and Message Box
IF THEN ELSE
Select Case
Workbooks
Worksheets
Cells and Range
Formatting
Cut, Copy and Paste
Sort and Filter
Loops in VBA
VBA and Worksheet Functions
User Defined Functions
Error Handling
ADODB Connection
Most useful VBA Command
Products
Restaurant Management System
Inventory Management System
Utility Tool
Task Management
Attendance Management
Sale/Purchase
Function Kit
Excel Dashboard
Sales Dashboard In Excel
Process Dashboard
Performance Dashboard
Project Management Dashboard
Outbound Dashboard In Excel
Incentive Dashboard In Excel
Zonal Dashboard
Quick Dashboard
C-SAT Dashboard
Free Templates
Inventory Management Template for Multiple Locations
Patient Database & Prescription
Invoice Management System
Leave Management System
Age Calculator
Digital Clock
Exam Application Form with timer
Visitors Log Book
Time Picker
Freelancing
Digital Marketing
Google Ads
Google Ads Manager Account creation
Google Ads Account creation
Linked with Client Account
Keyword Rearch
Google search ads/ PPC ads
Live project google ppc ads
Live project keyword rearch
CPA Marketing
What is cpa marketing
Why cpa marketing is best for beginners
Types of action in cpa marketing
What we need in cpa marketing
Best offer category in cpa marketing
Traffic secret for cpa marketing
How to track traffic for cpa marketing
Wrong idea on cpa marketing
How to find best cpa network
How to create account in CPA Marketing
Product research for cpa marketing
FREE CPA MARKETING 1
Banner Design from Canva
Create Landing Page
Free Traffic Method
Tumblr.com
gettr.com
qwikad.com
parler.com
pbase.com
9gag.com
minds.com
meta.stackexchange.com
qiita.com
feedly.com
bilibili.com
nairaland.com
flipboard.com
coub.com
deviantart.com
imgur.com
storeboard.com
pastebin.com
lu.ma
mastodon.social
wattpad.com
teletype.in
peakd.com
getpocket.com
pearltrees.com
Power BI
Location Map
My business site
About us
Contact us
Registration for Admission
Privacy Policy
More
Home
Basic knowledge
Microsoft Office
Microsoft Word
Microsoft Word Tutorial
Microsoft Excel
Microsoft Excel Tutorial
MS Office Suggestions
Advanced Excel
Shortkut Keys
Useful Formulas
VLOOKUP Formula
HLOOKUP formula
MATCH formula
INDEX Formula
INDIRECT Formula
OFFSET Formula
CHOOSE Formula
ADDRESS Formula
FIND Formula
LEN Formula
MID Formula
SUBSTITUTE Formula
TEXT Formula
TEXTJOIN Formula
TRIM Formula
DATE Formula
DATEVALUE Formula
EOMONTH Formula
NETWORKDAYS Formula
NOW Formula
TODAY Formula
AVERAGEIF Formula
COUNTIF Formula
COUNTIFS Formula
SUMIF Formula
SUMIFS Formula
SUMPRODUCT Formula
Powerful Dynamic Array Function
VLOOKUP by cell background color
AREAS Formula
COLUMN Formula
COLUMNS Formula
HYPERLINK Formula
LOOKUP Formula
ROW Formula
ROWS Formula
TRANSPOSE Formula
XLOOKUP Formula
BAHTTEXT Formula
CHAR Formula
CLEAN Formula
CODE Formula
CONCAT Formula
CONCATENATE Formula
DOLLAR Formula
EXACT Formula
FIXED Formula
LEFT Formula
LOWER Formula
NUMBERVALUE Formula
PROPER Formula
REPLACE Formula
REPT Formula
RIGHT Formula
SEARCH Formula
T Formula
UNICHAR Formula
UNICODE Formula
UPPER Formula
VALUE Formula
DATEDIF Formula
DAY Formula
DAYS Formula
DAYS360 Formula
EDATE Formula
HOUR Formula
MINUTE Formula
MONTH Formula
NETWORKDAYS.INTL Formula
SECOND Formula
TIME Formula
TIMEVALUE Formula
WEEKDAY Formula
WEEKNUM Formula
WORKDAY Formula
WORKDAY.INTL Formula
YEAR Formula
YEARFRAC Formula
AND Formula
FALSE Formula
IF Formula
IFERROR Formula
IFNA Formula
IFS Formula
NOT Formula
OR Formula
SWITCH Formula
TRUE Formula
CELL Formula
ERROR.TYPE Formula
INFO Formula
ISBLANK Formula
ISERR Formula
ISERROR Formula
ISLOGICAL Formula
ISNA Formula
ISNONTEXT Formula
ISNUMBER Formula
ISREF Formula
ISTEXT Formula
N Formula
NA Formula
TYPE Formula
Basic Charts
Line Chart
Column Chart
Bar Chart
Stacked Column Chart
Stacked Bar Chart
Pie Chart
Doughnut Chart
Area Chart
Combo Chart
Advanced Chart
Battery Chart
Speedometer Chart
Test Tube Chart
Progress Circle chart
Half Circle KPI Charts in Excel using Doughnut Charts
Moving Man Chart
Dynamic Chart with check boxes
Dynamic Variance Arrows Chart with Check Boxes
Sort And Filter
Data Sorting
Sort By Color
Data Filter
Text,Number And Date Filters
Filter By Color
Advanced Filter
Pivot Table
Insert a Pivot Table
Data Sorting in Pivot Table
Filters in Pivot Table
Value Field Settings in Pivot Table
Columns in Pivot Table
Groups/Ungroup in Pivot Table
Report Layouts In Pivot Table
Subtotals and Grand Totals
Pivot Charts
Slicers in Pivot Table
Timeline in Pivot Table
Refresh Pivot and Change Data Source
Calculated Fields/Items in Pivot Table
Show Details in Pivot table
Pivot Tables, Slicers and Timeline Styles
Data Validation
Whole Number Validation
Decimal Number Validation
List (Drop down) Creation
Date Validation
Time Validation
Text Length Validation
Custom (Formula) Validation
Input Message
Error Alert (Stop,Warning and Information)
Circle Invalid Data
Conditional Formatting
Highlight Cells Rules
Top Bottom Rules
Data Bars
Color Scales
Icon Sets
Format all cells based on their values
Format only cells that contain
Format only top or bottom ranked values
Format only values that are above or below average
Format only unique or duplicate values
Use a formula to determine which cells to format
Manage and Clear Rules
Auto Fill and Flash Fill
Fill-Down,Up,Left,Right,Series and Justify
Auto Fill and Custom List
Flash Fill
Find And Replace
Common Errors In Excel Formulas And How To Fix Them
VBA Course
Introduction
Macro Recording
Variables and Data type
Comments
Input Box and Message Box
IF THEN ELSE
Select Case
Workbooks
Worksheets
Cells and Range
Formatting
Cut, Copy and Paste
Sort and Filter
Loops in VBA
VBA and Worksheet Functions
User Defined Functions
Error Handling
ADODB Connection
Most useful VBA Command
Products
Restaurant Management System
Inventory Management System
Utility Tool
Task Management
Attendance Management
Sale/Purchase
Function Kit
Excel Dashboard
Sales Dashboard In Excel
Process Dashboard
Performance Dashboard
Project Management Dashboard
Outbound Dashboard In Excel
Incentive Dashboard In Excel
Zonal Dashboard
Quick Dashboard
C-SAT Dashboard
Free Templates
Inventory Management Template for Multiple Locations
Patient Database & Prescription
Invoice Management System
Leave Management System
Age Calculator
Digital Clock
Exam Application Form with timer
Visitors Log Book
Time Picker
Freelancing
Digital Marketing
Google Ads
Google Ads Manager Account creation
Google Ads Account creation
Linked with Client Account
Keyword Rearch
Google search ads/ PPC ads
Live project google ppc ads
Live project keyword rearch
CPA Marketing
What is cpa marketing
Why cpa marketing is best for beginners
Types of action in cpa marketing
What we need in cpa marketing
Best offer category in cpa marketing
Traffic secret for cpa marketing
How to track traffic for cpa marketing
Wrong idea on cpa marketing
How to find best cpa network
How to create account in CPA Marketing
Product research for cpa marketing
FREE CPA MARKETING 1
Banner Design from Canva
Create Landing Page
Free Traffic Method
Tumblr.com
gettr.com
qwikad.com
parler.com
pbase.com
9gag.com
minds.com
meta.stackexchange.com
qiita.com
feedly.com
bilibili.com
nairaland.com
flipboard.com
coub.com
deviantart.com
imgur.com
storeboard.com
pastebin.com
lu.ma
mastodon.social
wattpad.com
teletype.in
peakd.com
getpocket.com
pearltrees.com
Power BI
Location Map
My business site
About us
Contact us
Registration for Admission
Privacy Policy
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse