5 Simple Tips & Tricks in MS Excel | Part 4| IF | nestedif | if with and & or| countif | sumif

 

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Part 4 : Tip #1 : IF function : Explaining how to apply IF function in excel Tip #2 : Nested IF : IF function within IF Tip #3 : IF with AND & OR : How to apply IF function with AND and OR function Tip #4 : COUNTIF : How to apply COUNTIF function in excel Tip #5 : SUMIF : How to apply SUMIF function in excel Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 3 | Freeze pane | Print title| print selection | break view| setup

 

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Part 3 : Tip #1 : Freeze Panes: Freeze headings to better view Tip #2 : Print Title: Print the selected titles in all the pages Tip #3 : Print Selection: Print only selected area, multiple worksheet printing at a time Tip #4 : Page break view: page break view before printout Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 2 |Transpose | Cond format | Duplicate | dropdown | combine

Tip #1 : Transpose

Tip #2 : Conditional Formatting

Tip #3 : Remove Duplicate

Tip #4 : Dropdownl List

Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel which will make your work flow faster | Part 1

 

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Tip #1 : Column or Row width Adjustment Easy way of adjusting column or row width Tip #2 : Select Data It explains how to select data in an excel sheet easily Tip #3 : Quick Analysis Easy way of applying quick formatting Tip #4 : Fill & Series Easy way of filling data and series of data in cells Tip #5 : Format Painter Applying a format in to another region Please subscribe and share the video... More parts are coming with exiting tips..