Profile

Cover photo
Exceljet
107 followers|63,418 views
AboutPostsPhotosYouTube

Stream

Exceljet

Shared publicly  - 
 
Excel video: Simplified formula example - 401k Match | Exceljet
1
Add a comment...

Exceljet

Shared publicly  - 
 
Intro to boolean logic in Excel formulas | Exceljet // 3 min video
1
Add a comment...

Exceljet

Shared publicly  - 
 
#Excel video: How to build a simple summary table with COUNTIF and SUMIF | Exceljet http://bit.ly/2fIr3fs // 3 min video
1
Add a comment...

Exceljet

Shared publicly  - 
 
20 tips for Named Ranges in #Excel: simpler formulas, dynamic ranges, hyperlinks, data validation, and more http://bit.ly/2cjYd37
1
Monu Jha's profile photo
 
Hey there
I want some help in excel
Can you please provide me your email I'd ?

Add a comment...

Exceljet

Shared publicly  - 
 
If you're not using Paste Special every day in #Excel, you're losing time. Many hidden gems. http://bit.ly/2cCoTRk
1
Add a comment...

Exceljet

Shared publicly  - 
 
Conditional formatting with custom formulas | #excel
Harness the full power of Excel's formulas and functions to apply conditional formatting with exactly the logic you need.
1
Add a comment...

Exceljet

Shared publicly  - 
 
Excel video: Complex formula example - 401k Match

This is a step-by-step demo of a more complex formula in Excel to calculate the company match for a 401k plan. Short video, about 3 minutes.
1
Add a comment...

Exceljet

Shared publicly  - 
 
How to use VLOOKUP to merge tables in #Excel | http://bit.ly/2fUvhl5 // 3 minute video
1
Add a comment...

Exceljet

Shared publicly  - 
 
#Excel video: How to combine functions in a formula | Exceljet http://bit.ly/2fpjcmS // short video less than 3 minutes.
1
Add a comment...

Exceljet

Shared publicly  - 
 
Excel video: Perfect conditional formatting with dummy formulas | Exceljet http://bit.ly/2eE1cYU // 3 minute video
1
Add a comment...

Exceljet

Shared publicly  - 
 
Tired of the IF function? Replace ugly IFs with MAX or MIN
Sometimes, you want to check the result of a calculation first before you return a final result. Maybe you want to trap negative values, and display zero instead? You can certainly use the IF function to do this, but you might be able to build a more elegant formula with MIN or MAX instead.
1
Add a comment...

Exceljet

Shared publicly  - 
 
Formula Friday: Calculate retirement date in #Excel http://bit.ly/2bTagFI
To calculate a retirement date based on a birth date, you can use the EDATE function. In the example shown, the formula in D6 is: =EDATE(C6,12*60) How this formula works The EDATE function is fully automatic, and will return a date xx months in the future or past, when given a date and the number of months to traverse.
1
Add a comment...
Story
Tagline
Learn Excel faster with visually rich training resources
Introduction
Quality Excel training and resources to help you learn Excel faster
Links
YouTube
Contact Information
Contact info
Phone
801-803-8583
Email