Jul 3, 2020
Formatting Cells. Ctrl+9: Hide the selected rows
seen from Finland
seen from Netherlands
seen from United States
seen from Estonia
seen from Germany
seen from United States
seen from United States
seen from Malaysia
seen from China
seen from Germany
seen from France
seen from Macao SAR China
seen from Taiwan
seen from T1
seen from United States
seen from Germany
seen from Germany
seen from Netherlands
seen from Finland
seen from United States
Formatting Cells. Ctrl+9: Hide the selected rows
- #StarTrek #DS9 #BenjaminSisko #CaptianSisko #blacknerdproblems #microsoftexcel https://www.instagram.com/p/B0YrbFnlrQr/?igshid=1v1rbmmt1wc4w
Roger Samara - Useful Tips and Shortcuts for the ease of Microsoft Excel Users
How to Use the IF Formula in Excel
The IF function in Excel helps you make decisions based on conditions. In this video, learn how to use the IF formula to automatically return results like “Pass” or “Fail” based on marks, scores, or other data conditions.
What you’ll learn: • How to use the IF formula in Excel • Understanding logical tests in formulas • Using TRUE and FALSE conditions • Creating automatic Pass/Fail results • Beginner-friendly Excel techniques
Explore Our Excel Courses:
Basic Excel Training Course
Advanced Excel Training Course
Read the Full Blog Visit Our Website
How to Use the COUNTIF Formula in Excel
The COUNTIF function in Excel helps you count cells based on specific conditions or criteria. In this video, learn how to use COUNTIF with both numbers and text, apply conditions like greater than or less than, and count specific names or values easily.
What you’ll learn: • How to use the COUNTIF formula in Excel • Counting cells with specific conditions • Using COUNTIF with numbers and text • Applying criteria like >20 or <20 • Locking ranges with F4 in Excel
Explore Our Excel Courses:
Basic Excel Training Course
Advanced Excel Training Course
Read the Full Blog Visit Our Website
How to Use the COUNT Formula in Excel
The COUNT function in Excel helps you quickly count how many cells contain numeric values in a dataset. In this video, learn how the COUNT formula works, how it ignores text and empty cells, and how Excel automatically updates the result when numbers change.
What you’ll learn: • How to use the COUNT formula in Excel • Counting numeric values in a range • Difference between numbers and text in Excel • Dynamic updating of formulas • Beginner-friendly Excel techniques
Explore Our Excel Courses:
Basic Excel Training Course
Advanced Excel Training Course
Read the Full Blog Visit Our Website
How to Find the Lowest Value Using MIN Formula in Excel
The MIN function in Excel helps you quickly identify the smallest number in a dataset without manual checking. In this video, learn how to use the MIN formula with different cell ranges and see how Excel automatically updates the result whenever values change.
What you’ll learn: • How to use the MIN formula in Excel • Finding the lowest value in a dataset • Using cell ranges across rows and columns • Dynamic updating of Excel formulas • Beginner-friendly Excel techniques
Explore Our Excel Courses:
Basic Excel Training Course
Advanced Excel Training Course
Read the Full Blog
Visit Our Website