Best Excel Couse | Beginner to Advanced Excel | Complete Excel Course | Learn Excel Basics

[@sagarjangid7940]

The way you taught, is superb.

[@KishanKumar-tv8yw]

1:00:56 FORMAT AS A TABLE
1:09:38 treat as a table and the 2nd line as heading then select the 2nd line and then select FORMAT AS A TABLE then select any optionk
to create a if formula , paste the screenshot of excel data in copilot then ask for a IF formula as per condition and then paste it
1:33:27 count functions

[@KishanKumar-tv8yw]

12:37 Press Alt + Enter to move to the next line within the same cellkff
14:42 Shift + F11 quickly inserts a new worksheet into your workbookk
16:18 rename a sheet Alt + H , Alt + O, Alt + R all continuousfkf
To switch between sheets; Ctrl + Page Up: Move to the previous sheet.
Ctrl + Page Down: Move to the next sheet.
Alt + E + L is used to Delete a Sheet
19:38 shortcut for some words
24:57 macros
26:49 '=9+9
34:23 Select a group of cells in Excel, and you can move within the cells using the Tab button.
35:11 To select the RANDBETWEEN formula from the options shown, you can use the arrow keys to navigate to the desired option and then press the Tab key on your keyboard.
36:45 Use RANDBETWEEN(30,100) to generate a random number, then copy that cell. Select the target cells and press Ctrl + V to paste.
38:06 Shift + Ctrl + Right Arrow: & Shift + Ctrl + Down Arrow:
39:32 if randbetween formula use to freeze the numbers into table slect the cells of numbers press alt the h then v then v
also:
Paste Values Only:
Right-click on the highlighted cells.
Choose Paste Special and select Values.
Alternatively, you can use Ctrl + Alt + V and then press V to paste values only.
40:02 = sum () or alt+=
47:12 =macros in Excel are used to automate repetitive tasks by recording a sequence of actions that can be played back later
Alt + H + K: This applies the comma style to numbers, adding thousand separators.
Alt + H + 9: This decreases the decimal places of the selected number.
1:00:56 FORMAT AS A TABLE
1:09:38 treat as a table and the 2nd line as heading then select the 2nd line and then select FORMAT AS A TABLE then select any optionk
to create a if formula , paste the screenshot of excel data in copilot then ask for a IF formula as per condition and then paste itkk
1:33:27 count functions

[@LawrenceNadar-rv5rv]

Tab front
Shift tab back
alt = for sum

[@caaspirant837]

Sir yeh video poora dekh liya, ache se smj bhi liya. Itna sufficiant h n articleship k liye?

[@soulfulsonal1623]

How to join this course

[@prasannashetty8355]

Thank you for great help and knowledge

[@nainagoel874]

Summary 1:41:40

[@punitdhiman2097]

This is really helpful video of ecxel

[@madhurirachakonda2828]

Is it a paid course, if yes are next videos not in yt n what is the fee for the course ??

[@sonalkhotani7150]

Superb way of teaching, Shivam !! 👍

[@CAShivamPalan]

Thanks a lot 😊

[@isha_agarwal]

18:00

[@poorvajain8069]

Is this course available at present?

[@sjmusicworld8141]

Sir i want to purchase your course ..from where i can purchase

[@tanyasrivastava10]

Please provide the excel fill.

[@shivaanshtulshyan6239]

Sir you told to take pdf of the excel file from youtube, can you please share it

[@rishabhmourya409]

Sir yeh excel ka file kaha par hai please share.

[@KishanKumar-tv8yw]

REVISEION COMPLETED

[@anshuuu99]

1:33:41

[@triptiagarwal7977]

Sir is thus course enough for excel knowledge for a CA

[@CAShivamPalan]

Yes

[@madhurirachakonda2828]

Is it a paid course, 2nd class onwards is not available on yt???

[@CAShivamPalan]

Yes its paid course.

[@basavarajkesarekar566]

Waiting

[@jilnababy8849]

Can i purchase it after few month. Any duration to purchase

[@CAShivamPalan]

Yes

[@benaygupta8511]

Sir I want to purchase 6A Risk Management of yours need guidance can I talk to you once

[@CAShivamPalan]

90227 20882

[@ishikajaiswal4675]

Is certificate is available from this course ?

[@CAShivamPalan]

Yes its is

[@monabansal1848]

Fees of this course?

[@CAShivamPalan]

599