Greetings from SKILL BOOMS!

Irfan here, and I have 26 years of experience with Microsoft Excel. I'm passionate about assisting others in becoming proficient Excel users.

In these videos, I offer advice on how to use Excel efficiently to save time and effort. I also talk about things like VBA scripting, macros, and formulae.

My videos are meant to be educational and helpful, I hope. Start learning how to use Excel like a pro by subscribing to my channel right away!


Skill Booms

What happens when you copy the formula =A1+B1 from cell C1 to cell C2 in Excel using relative referencing?

6 months ago | [YT] | 0

Skill Booms

2 years ago | [YT] | 0

Skill Booms

Which Excel function is used to calculate the last day of a specified month based on a given date?

2 years ago | [YT] | 1

Skill Booms

Which of the following is true about the Excel goal seek tool?

2 years ago | [YT] | 1

Skill Booms

Which symbol is used to represent an absolute cell reference in Excel?

2 years ago | [YT] | 3

Skill Booms

What does =COUNTIF(A:A,*apple*) count

A) The number of cells in the range A:A that contain the word "apple".

(B) The number of cells in the range A:A that contain the word "apple" anywhere in the cell, including the beginning, middle, or end.

(C) The number of cells in the range A:A that start with the word "apple".

(D) The number of cells in the range A:A that end with the word "apple"


#Advanced Excel tricks#ExcelOnlineCourse#ExcelTips&tricks#ExcelForAnalysts#MicrosoftExcel Tutorials#MicrosoftExcel#Excel2016#Excel2013#Excel 2019#excelShortcut#ExcelHiddenShortcut#ExcelShortCutsTutorial#KeyboardShortcuts#ExcelHacks#Skillbooms#Skill booms

2 years ago | [YT] | 2

Skill Booms

Which of the following is a keyboard shortcut to create a new Workbook in Microsoft Excel?
A. Ctrl + S
B. Ctrl + N
C. Ctrl + O
D. Ctrl + P

2 years ago | [YT] | 1