- 104
- 382 449
Doctor Excel
United States
Приєднався 15 гру 2018
Everyday I share with you a new Excel tip to help you become an Excel Champion, impress your boss and accelerate your career
Excel function SUMIF: How to use the sumif formula in Excel - Doctor Excel
⚡ Download the Excel file (#101) excelsior-training.com/excel-bonus-files
👇 All bonus info below
Doctor Excel shows you how to use the function SUMIF in this Excel video Course
⚡ Download the Excel file (#101) excelsior-training.com/excel-bonus-files
#doctorexcel #learnexcel #exceltraining
👇 All bonus info below
Doctor Excel shows you how to use the function SUMIF in this Excel video Course
⚡ Download the Excel file (#101) excelsior-training.com/excel-bonus-files
#doctorexcel #learnexcel #exceltraining
Переглядів: 1 027
Відео
Excel function INDIRECT: how to use the excel indirect formula - Doctor Excel
Переглядів 4525 років тому
⚡ Download the Excel file (#104) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to learn he Excel function INDIRECT ⚡ Download the Excel file (#104) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel function MATCH explained: how to understand the Match formula - Doctor Excel
Переглядів 1715 років тому
⚡ Download the Excel file (#098) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel show you how to master the Excel function MATCH ⚡ Download the Excel file (#098) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel function: Multiply and Product formulas - Doctor Excel
Переглядів 2105 років тому
⚡ Download the Excel file (#102) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel Shows you the functions to use to multiply and how to compute a product in Excel ⚡ Download the Excel file (#102) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel SUBTRACT formula: How to subtract in Excel
Переглядів 95 тис.5 років тому
⚡ Download the Excel file (#097) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to subtract in Excel and how to use the subtract function ⚡ Download the Excel file (#097) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel function Index: How to MASTER it - Doctor Excel
Переглядів 1145 років тому
⚡ Download the Excel file (#100) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel show you how to master the excel formula INDEX ⚡ Download the Excel file (#100) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Percentage %: Which Excel formula for percentage? - Doctor Excel
Переглядів 1175 років тому
⚡ Download the Excel file (#099) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to compute and display percentages in Excel ⚡ Download the Excel file (#099) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel formulas: Average and Weighted average - Doctor Excel
Переглядів 735 років тому
⚡ Download the Excel file (#103) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel show you how to master the Excel function AVERAGE We will compute a regular average and a weighted average with formulas ⚡ Download the Excel file (#103) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel function COUNTIF: Count specific values with a formula
Переглядів 2765 років тому
⚡ Download the Excel file (#096) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to count only the values that meet a specific criteria with the Excel function COUNTIF. You will learn how to use the COUNTIF formula to count values according to a condition and the sample file is available for download right below ⚡ Download the Excel file (#096) excelsi...
Excel template - Invoice with automatic backup- Doctor Excel #095
Переглядів 4265 років тому
⚡ Download the Excel file (#095) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to add an automatic invoice backup to your invoice generator ⚡ Download the Excel file (#095) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Template - Invoice with automatic number - Doctor Excel #094
Переглядів 13 тис.5 років тому
⚡ Download the Excel file (#094) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to add automatic invoice numbering to your invoice template ⚡ Download the Excel file (#094) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Template - Automatic invoice with customer information - Doctor Excel #093
Переглядів 2,7 тис.5 років тому
⚡ Download the Excel file (#093) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to add automatic customer information to your invoice template ⚡ Download the Excel file (#093) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Template - Automatic invoice Part 1- Doctor Excel #092
Переглядів 2305 років тому
⚡ Download the Excel file (#092) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to build an automatic invoice template, with automatic subtotals ⚡ Download the Excel file (#092) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Formula - How to consolidate several files into one - Doctor Excel #091
Переглядів 845 років тому
⚡ Download the Excel file (#091) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you what formula to use to consolidate several files into one. This way you will be able to consolidate several reports into one single files. ⚡ Download the Excel file (#091) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel template - Evergreen calendar (works for any year) - Doctor Excel #090
Переглядів 7965 років тому
⚡ Download the Excel file (#090) excelsior-training.com/excel-bonus-files 👇 All bonus info below Doctor Excel shows you how to build a calendar template that will work for any year. We will use formulas to build everything so that the calendar will always work for any year. ⚡ Download the Excel file (#090) excelsior-training.com/excel-bonus-files #doctorexcel #learnexcel #exceltraining
Excel Formulas- Replace nested IF with SWITCH and IFS - Doctor Excel #089
Переглядів 2155 років тому
Excel Formulas- Replace nested IF with SWITCH and IFS - Doctor Excel #089
Excel Formula: Unique sorted dropdown list - Doctor Excel #088
Переглядів 2375 років тому
Excel Formula: Unique sorted dropdown list - Doctor Excel #088
Excel Macro: Solve the world's HARDEST Sudoku with VBA - Doctor Excel #087
Переглядів 8 тис.5 років тому
Excel Macro: Solve the world's HARDEST Sudoku with VBA - Doctor Excel #087
Excel time saver: Select every odd row (or all even rows) - Doctor Excel #086
Переглядів 43 тис.5 років тому
Excel time saver: Select every odd row (or all even rows) - Doctor Excel #086
Excel Reverse Lookup: Find value in first row and columns - Doctor Excel #085
Переглядів 2745 років тому
Excel Reverse Lookup: Find value in first row and columns - Doctor Excel #085
Excel Dashboard Template - Year Progress Bar - Doctor Excel #084
Переглядів 3965 років тому
Excel Dashboard Template - Year Progress Bar - Doctor Excel #084
Excel MAGIC: Gantt chart without using complicated charts- Doctor Excel #083
Переглядів 1475 років тому
Excel MAGIC: Gantt chart without using complicated charts- Doctor Excel #083
Excel formula:Automatically go to searched value in table - Doctor Excel #082
Переглядів 705 років тому
Excel formula:Automatically go to searched value in table - Doctor Excel #082
List of all Excel sheets with a 1 click shortcut - Doctor Excel #081
Переглядів 355 років тому
List of all Excel sheets with a 1 click shortcut - Doctor Excel #081
Excel formula: How to Rank values - Doctor Excel #080
Переглядів 445 років тому
Excel formula: How to Rank values - Doctor Excel #080
Excel LIFE SAVER Shortcut: Display calculator shortcut- Doctor Excel #079
Переглядів 1005 років тому
Excel LIFE SAVER Shortcut: Display calculator shortcut- Doctor Excel #079
SPEED UP Excel: Replace 12 Vlookups by 1 Match - Doctor Excel #078
Переглядів 735 років тому
SPEED UP Excel: Replace 12 Vlookups by 1 Match - Doctor Excel #078
Excel Formula - Automatic Alphabetical sort - Doctor Excel #077
Переглядів 8 тис.5 років тому
Excel Formula - Automatic Alphabetical sort - Doctor Excel #077
Excel Formula - Automatic Sum of the last 5 values - Doctor Excel #076
Переглядів 705 років тому
Excel Formula - Automatic Sum of the last 5 values - Doctor Excel #076
Excel Formula: Calculate the average age from dates of birth - Doctor Excel #075
Переглядів 8 тис.5 років тому
Excel Formula: Calculate the average age from dates of birth - Doctor Excel #075
Download link not working
How the year 1900 become 2020. What did you click? Sorry I didn't get it. huhu
THANKS .its really healpful to me
Utter rubbish, honestly! what a waste of time, no one came watch how fast you can build a sheet, this is the first negative i have ever given!
I tried the =E2+7 and got a Value Error.
Thy. you are best teacher
F4 not working on my laptop
To advance for me and way too fast with the clicking ( set up)
Merci
F 4 is not working for me
Thank you so much. I am glad to know this my work become easier to me ... Thank you so much again....
Fuck excel and fuck this video
Good morning, You can't see the following line: If (sudoku(i, j) = 0) Or (sudoku(i, j) = "") Or (Len(sudoku(i, j)) > 1) Or (total_digits(sudoku) <> total.... Can you tell me the rest of the line? Thanks
To be honest, if I had hand picked my data I would have spent less time than I've spent searching for you video, but when I found it...... man it feels good to know this neat trick! Thank you sir! Merci!!
Thx but it doesn't work if you have hidden row. do you happen to have a fix? thx
Most useless topic
Thank you so much
But you did not calculate the average age ...
thanks for the tips bro
Thanks
i followed your formula and it include my header to the sorting, if i exclude the header row from the range ill get an error on the next row of countif. can you help me?
Based.
Thank you
I figures it out on how to make a range. If someone wants to know hit me up
Range??
This guy is excellent.
Hi, can you help me? I want to compare two strings in different cells (in order), and the return value is the number of matched characters. The caracters are limited to: A, B, C, D and E. They are alternatives of a test. For example: cell A1: DCBCCBD (the candidate's answers) cell B1: BABCDBD (the correct answers) He just asked the third, fourth and sixth question correct. Then, I need to return in cell C1: 3 (the number of correct answers). How can I do it?
How to do it with the same column? Like if I put a city in column B, it will sort the column B, not the column H you created. Thank you.
Its help full
Thank you sir
Thank you!!!
I am really struggling!! I’m trying to create a register In Excel and all I need is to have every Monday and Thursday dates next to each other going down from A2 onwards and then then have the names of people going across from B1, c1 etc onwards can anyone help me!!!! What is the formulas I need. I’m really finding it hard! I’m not an expert with Excel, just a beginner.
So basically for the dates to plus 4 days each time. Monday-Thursday!
Man is so confusing p😐
this is amazing.... t'es genie
thanks!
what if the mileage rate is half a cent more? Right now it is 58.5/mile
Go away
I would like the date on my spread sheet to automatically add 7 days to my date cell every 7 days. Is that possible?
Yes with formula =row+3
@@msbeautifulcore8881 da so simple. Thank you
Thank You
thanks. i was looking for it. it was so helpfull. _/\_
Well that was easy Thank you.
You completely lost me in the 2nd example thats far too long i switched off. The first way was better. Thanks.
Thank you, very useful
Thanks a lot 👍
send the download file plss
Nice
You don't show how not to have doubles!
Great video, merci beaucoup!!
F4 on my PC does not work, so why are you saying something that's untrue. frustration
try press (Fn + F4) if you are window user
Hello, thank you for the explanation. Could you please help me to know if there's a way to send this pop notification to my colleagues as well, so that they know the deadline is today or something like that! . Thank you!
Very nice and helpful tutorial