Tech Tap

Tech Tap

Welcome to our KZbin channel! Here, we focus on providing helpful tutorials and tips on a variety of software tools, including Microsoft Excel, Camtasia, Microsoft Word, PowerPoint, Adobe After Effects, Adobe Illustrator, Blender, and other technical solutions.

Our Microsoft Excel tutorials cover everything from basic functions and formulas to advanced data analysis techniques. We also offer tips and tricks for using Camtasia to create high-quality screencasts and video tutorials, as well as guides for using Microsoft Word and PowerPoint to create professional documents and presentations.

For those interested in graphic design and video production, we have tutorials on Adobe After Effects and Adobe Illustrator, as well as Blender for 3D animation and modeling. Additionally, we provide technical solutions for common software issues and troubleshooting tips to help you optimize your workflow.

How to Remove Table Formatting in Microsoft Excel

2:40

How to Remove Table Formatting in Microsoft Excel

4 ай бұрын

Creating barcodes in Microsoft Excel

2:10

Creating barcodes in Microsoft Excel

4 ай бұрын

Adding text to cells in Microsoft Excel

3:36

Adding text to cells in Microsoft Excel

5 ай бұрын

Replacing or removing text in Microsoft Excel

2:57

Replacing or removing text in Microsoft Excel

5 ай бұрын

Find out In which branch do John open the most current accounts for new customers in Microsoft Excel

3:01

Find out In which branch do John open the most current accounts for new customers in Microsoft Excel

5 ай бұрын

Find out What types of accounts do john open most often in Microsoft Excel by using Pivot table

3:00

Find out What types of accounts do john open most often in Microsoft Excel by using Pivot table

6 ай бұрын

Discover the Money Spent on Account Openings with Excel Pivot Table

4:28

Discover the Money Spent on Account Openings with Excel Pivot Table

6 ай бұрын

Creating pivot table along with conditional formatting

1:54

Creating pivot table along with conditional formatting

6 ай бұрын

Modification of various field in pivot table, Microsoft Excel

2:30

Modification of various field in pivot table, Microsoft Excel

7 ай бұрын

Creating pivot table in Microsoft Excel by using manual method

2:34

Creating pivot table in Microsoft Excel by using manual method

7 ай бұрын

Automatic Pivot table in Microsoft Excel

2:34

Automatic Pivot table in Microsoft Excel

7 ай бұрын

Create random number and text in Microsoft excel

4:34

Create random number and text in Microsoft excel

7 ай бұрын

Delete blank cells in Microsoft excel

0:53

Delete blank cells in Microsoft excel

7 ай бұрын

Creating Auto outline & Manual outline in Microsoft Excel

4:18

Creating Auto outline & Manual outline in Microsoft Excel

8 ай бұрын

Creating a dependent list in Microsoft Excel

2:58

Creating a dependent list in Microsoft Excel

8 ай бұрын

Accepting only values that don't exceed a total in Microsoft Excel

2:15

Accepting only values that don't exceed a total in Microsoft Excel

8 ай бұрын

Data Validation Formula Examples in Microsoft Excel

3:18

Data Validation Formula Examples in Microsoft Excel

8 ай бұрын

Specifying Validation Criteria in Microsoft Excel

3:14

Specifying Validation Criteria in Microsoft Excel

8 ай бұрын

Creating a Drop Down List in Microsoft Excel

3:29

Creating a Drop Down List in Microsoft Excel

8 ай бұрын

International number format to Indian number format in Microsoft Excel

4:14

International number format to Indian number format in Microsoft Excel

9 ай бұрын

Filling gaps in Microsoft Excel

1:36

Filling gaps in Microsoft Excel

9 ай бұрын

Rearranging columns in Microsoft Excel

1:45

Rearranging columns in Microsoft Excel

9 ай бұрын

Text join or column join in Microsoft Excel by using Concat & textjoin formula

3:39

Text join or column join in Microsoft Excel by using Concat & textjoin formula

9 ай бұрын

Classifying Data by using vlookup in Microsoft Excel

2:32

Classifying Data by using vlookup in Microsoft Excel

9 ай бұрын

Split cells in rows & columns in Microsoft Excel

2:35

Split cells in rows & columns in Microsoft Excel

9 ай бұрын

Using if & countif to extract information in Microsoft Excel

3:56

Using if & countif to extract information in Microsoft Excel

9 ай бұрын

Using vlookup for Classifying values in Microsoft Excel

2:23

Using vlookup for Classifying values in Microsoft Excel

9 ай бұрын

Changing vertical data to horizontal data in Microsoft Excel

4:54

Changing vertical data to horizontal data in Microsoft Excel

9 ай бұрын

extract the number from column in Microsoft Excel

2:04

extract the number from column in Microsoft Excel

9 ай бұрын

Пікірлер

@aniketmaroo9144

@aniketmaroo9144 27 күн бұрын

Excellent - very well explained 🙂 Thank you

@johnedward6657

@johnedward6657 Ай бұрын

Thank you very much for the very useful information.

@svenkatkadiyam7291

@svenkatkadiyam7291 Ай бұрын

very uselful

@AnLu_electronics

@AnLu_electronics 2 ай бұрын

Great. Thanks you. This guide is clear and carefull. Video easy to understand. It is exactly thing I need.

@kashj237 2 ай бұрын

why doesnt this work for 00,000 ? it doesnt work for thousands, only higher it works

@Techtap007 2 ай бұрын

It is perfectly working for thousands. This will not work for 00,000 because 00,000 will consider zero only.

@chaskawaii6610

@chaskawaii6610 3 ай бұрын

Super useful, thank you.

@TanyaLysachenko

@TanyaLysachenko 3 ай бұрын

Doesn't work!!!

@Techtap007 3 ай бұрын

=SUBSTITUTE(A1,",",".")

@AshokX985 3 ай бұрын

👍

@lisa045714 4 ай бұрын

Thank you was very helpful!

@Unknown-oo9vh 5 ай бұрын

How to Substitute the below value from Dot to comma and comma to dot. Value : 2.273,58

@Techtap007 5 ай бұрын

One of the Method is use flash fill, which is available in Data- Data tools - Flash Fill

@Techtap007 5 ай бұрын

=SUBSTITUTE(A1,".",",")

@Techtap007 5 ай бұрын

=SUBSTITUTE(A1,",",".")

@ruthcdsilva 5 ай бұрын

Thank you!

@bettymalone3769

@bettymalone3769 5 ай бұрын

'Promosm'

@ExcelExplorers786

@ExcelExplorers786 6 ай бұрын

Your dedication and capabilities have left me in awe. Any insights for my work?

@LuisMartinez-sz1nu

@LuisMartinez-sz1nu 6 ай бұрын

Thank you for these videos. I have a question do you know SQL I am becoming a data analyst and this is extremely helpful

@Techtap007 6 ай бұрын

Thank you for your comment. No i do not know SQL.

@dellmarco 6 ай бұрын

THANKS!!!!!!

@mellitabarretto7345

@mellitabarretto7345 7 ай бұрын

Very helpful, thank you very much.😊

@juliahicksfav 10 ай бұрын

thank you so much, it worked! Not even ChatGPT could help me on this one

@MukeshKumar-wq7xw

@MukeshKumar-wq7xw 11 ай бұрын

Awesome

@MukeshKumar-wq7xw

@MukeshKumar-wq7xw 11 ай бұрын

Incredible sir 🎉

@jonathan10melo

@jonathan10melo 11 ай бұрын

Thanks a lot!!!!!!

@pathanismail 11 ай бұрын

Is this Tapas sir ?

@Techtap007 11 ай бұрын

Yes, How are you?

@pathanismail 11 ай бұрын

@@Techtap007 it feels great to have you on youtube

@younimoon9567 Жыл бұрын

sorry not helpfull

@Techtap007 Жыл бұрын

Let me know what exactly you are looking for?

@Tushm270 Жыл бұрын

Page break krne ke bad series b har page par 1 s shuru s ho to kse hoga

@Techtap007 Жыл бұрын

If you're asking. The serial number has been inserted automatically by the Microsoft Excels, after you're using page break. Generally, page break is related to page preview for print out. It will not change any data in your Excel file. You must do it manually. Thank you.

@nicolevillacorta4865

@nicolevillacorta4865 Жыл бұрын

thank you!

@Techtap007 Жыл бұрын

You're welcome!

@petersnow5726 Жыл бұрын

😑 "Promo SM"

@nidhithakker5652

@nidhithakker5652 Жыл бұрын

Thank you sir

@moogu_ Жыл бұрын

Thank you so much for making this:)

@Techtap007 Жыл бұрын

You're so welcome!

@bernadettegamboa4684

@bernadettegamboa4684 Жыл бұрын

I have MS365 and I do not have this option.

@Techtap007 Жыл бұрын

This is available in installed version. Otherwise you can go to the insert and insert picture.

@tarunbrahmabhatt2711

@tarunbrahmabhatt2711 Жыл бұрын

How can draw a dynamic line between two strike price acording spot price and than spot price change line also change our place in option chain in google sheet how do it

@Techtap007 Жыл бұрын

To draw a dynamic line between two strike prices according to the spot price in Google Sheets, you can use a combination of functions and conditional formatting. Here are the steps: 1. Create a table with the strike prices, option premiums, and any other relevant data. 2. In a separate cell, enter the current spot price. 3. Using the "IF" function, create a new column that compares the spot price to the strike prices. For example, if the spot price is greater than the strike price, the function should return "Above", and if the spot price is less than the strike price, the function should return "Below". 4. Apply conditional formatting to the strike prices column based on the results of the IF function. For example, you can use a green fill color for strike prices that are "Above" the spot price, and a red fill color for strike prices that are "Below" the spot price.

@Techtap007 Жыл бұрын

=IF(A1>$C$1,TRUE,FALSE) Note: Here, A1 is the first cell of the strike prices column, and $C$1 is the cell containing the spot price. You can adjust these cell references as per your requirement.

@tarunbrahmabhatt2711

@tarunbrahmabhatt2711 Жыл бұрын

I want a dynamic line between two which strike near spot not colour how can add line in google sheet