Kenji Explains
Kenji Explains
  • Видео 174
  • Просмотров 31 262 536
How to Mail Merge to Send Personalized Bulk Emails
Use Mail Merge to send customized bulk emails in just one click.
🔥Take our Microsoft Office Bundle: www.careerprinciples.com/courses/microsoft-office-bundle
In this tutorial, you'll learn a super easy method to send personalized bulk emails called mail merge. We'll go from just having a list of details in Excel, to creating a dynamic Word document where fields like the name, the commission, and the product change for each recipient, and finally we'll send all of these customized emails in just one click in outlook.
Mail merge is a feature that allows users to create personalized documents, such as letters, emails, labels, or envelopes, by combining a single template with a data source. This ...
Просмотров: 11 176

Видео

Top Excel Formulas You Should Know in 2024
Просмотров 22 тыс.21 час назад
Learn the most important Excel formulas in just 15 minutes. 🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/asb 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/ye44degdxs Excel has over 470 functions, so knowing which one to use can be rather overwhelming. That's why in this video I'm going to teach you some of the most important Excel functions through ...
How To Compare Excel Files and Find Differences
Просмотров 22 тыс.14 дней назад
How to compare two Excel sheets and find differences between them. 👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/xvexzhqfma In this video I'm going to show you how to compare two separate excel files and find the differences between them. We'll compare for both separate...
10 Awesome Time Saving Hacks in Excel
Просмотров 39 тыс.21 день назад
10 quick and easy time saving hacks in Excel that you literally start using today! 🔥 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/gpwbmpammr In this video we'll go over 10 Excel shortcuts you should know. These are going to be game-changers for your Excel productivity. Firs...
Try This New Formula Instead of Pivot Tables
Просмотров 224 тыс.28 дней назад
Learn the GROUPBY Function in Excel to replace Pivot Tables. 🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/g8g 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/g1vkx5bo9d Stop using pivot tables, you can use the new GROUPBY function in Excel instead. This function is better because it updates automatically. For example, when the original data changes...
Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)
Просмотров 37 тыс.Месяц назад
Easily Create Multiple dependend dropdown lists in Excel. 👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/gunxkv01mh In this video you'll learn how to create multiple dependent dropdown lists in Excel. This will include an XLOOKUP and data validation. Once this is clear, ...
Cell Referencing in Excel (When to add a $ in a cell)
Просмотров 20 тыс.Месяц назад
Cell Referencing in Excel. Learn where to add the $ Sign. 🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55 🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/ucgy9necgp One of the most confusing things in Excel is knowing when to put the dollar sign for cell referencing (applied with the F4 key). Is it before the cell column letter? before the cell row num...
EASILY Make an Automated Data Entry Form in Excel
Просмотров 311 тыс.Месяц назад
EASILY Make an Automated Data Entry Form in Excel
Master the FILTER Formula in Excel (Beginner to Pro)
Просмотров 96 тыс.Месяц назад
Master the FILTER Formula in Excel (Beginner to Pro)
8 Quick & Easy Ways to Save Time at Work!
Просмотров 30 тыс.2 месяца назад
8 Quick & Easy Ways to Save Time at Work!
Intermediate SQL Tutorial (SQL Series Part 2)
Просмотров 15 тыс.2 месяца назад
Intermediate SQL Tutorial (SQL Series Part 2)
Data Analysis Project in Excel (3-Step Framework)
Просмотров 71 тыс.2 месяца назад
Data Analysis Project in Excel (3-Step Framework)
Automate Invoices in Excel (1-Click Export as PDF)
Просмотров 94 тыс.2 месяца назад
Automate Invoices in Excel (1-Click Export as PDF)
Learn SQL Basics in Just 15 Minutes!
Просмотров 117 тыс.3 месяца назад
Learn SQL Basics in Just 15 Minutes!
Dashboard Design Tips! (Data Visualization Crash Course)
Просмотров 21 тыс.3 месяца назад
Dashboard Design Tips! (Data Visualization Crash Course)
Make This Awesome Gantt Chart in Excel (for Project Management)
Просмотров 178 тыс.3 месяца назад
Make This Awesome Gantt Chart in Excel (for Project Management)
10x Your Excel With This New AI Formula
Просмотров 167 тыс.4 месяца назад
10x Your Excel With This New AI Formula
Master Conditional Formatting in Excel (The CORRECT Way)
Просмотров 57 тыс.4 месяца назад
Master Conditional Formatting in Excel (The CORRECT Way)
Take this Excel Interview Test and Avoid Interview Embarrassment
Просмотров 48 тыс.4 месяца назад
Take this Excel Interview Test and Avoid Interview Embarrassment
8 Awesome Excel Add-Ins You Should Know!
Просмотров 37 тыс.4 месяца назад
8 Awesome Excel Add-Ins You Should Know!
Learn Power Pivot in Excel (Better Than Pivot Tables)
Просмотров 83 тыс.4 месяца назад
Learn Power Pivot in Excel (Better Than Pivot Tables)
EASILY Combine Multiple Excel Sheets Into One With This Trick
Просмотров 239 тыс.5 месяцев назад
EASILY Combine Multiple Excel Sheets Into One With This Trick
Learn Excel Essentials in Just 15 Minutes
Просмотров 26 тыс.5 месяцев назад
Learn Excel Essentials in Just 15 Minutes
Make an Interactive Excel Dashboard in 4 Simple Steps!
Просмотров 170 тыс.5 месяцев назад
Make an Interactive Excel Dashboard in 4 Simple Steps!
Take Control of Your Finances in 2024 with Excel!
Просмотров 74 тыс.6 месяцев назад
Take Control of Your Finances in 2024 with Excel!
NEW: Copilot in Excel | Here's why it's incredible!
Просмотров 236 тыс.6 месяцев назад
NEW: Copilot in Excel | Here's why it's incredible!
Make Goldman Sachs Visuals in Excel!
Просмотров 55 тыс.6 месяцев назад
Make Goldman Sachs Visuals in Excel!
Best New Excel Features for 2024
Просмотров 62 тыс.6 месяцев назад
Best New Excel Features for 2024
5 Excel Formulas Everyone Should Know
Просмотров 68 тыс.6 месяцев назад
5 Excel Formulas Everyone Should Know
Do This in Excel to Save Hours of Time (99% of People Don't Know It)
Просмотров 166 тыс.7 месяцев назад
Do This in Excel to Save Hours of Time (99% of People Don't Know It)

Комментарии

  • @Ndofi
    @Ndofi 13 минут назад

    Super easy and many thanks! Looking forward to see more videos.

  • @AD19938
    @AD19938 Час назад

    Love your videos man keep it up

  • @hoperight5280
    @hoperight5280 2 часа назад

    Or you create an index column and assign them number. Then you can delete them. Just an option

  • @abdulbasital-sufyani6828
    @abdulbasital-sufyani6828 2 часа назад

    All are super

  • @WajidGhani-fo7hi
    @WajidGhani-fo7hi 2 часа назад

    I have been learn a lot about excel from you you are best the youtuber for excel love from Pakistan .

  • @sharonvoosa8160
    @sharonvoosa8160 2 часа назад

    Thank you!

  • @elvirazeb4113
    @elvirazeb4113 2 часа назад

    In Option 3 - if you delete all highlighted cells, you delete also the unique information. E.g. 6x Elon musk is deleted instead of 5 duplicates and 1 remaining unique

  • @saberconstruction7224
    @saberconstruction7224 5 часов назад

    How about a video to remove the depreciated equipment off of the books with the required journal entries to balance. Thanks.

  • @venkatachalamiyer7098
    @venkatachalamiyer7098 5 часов назад

    Hi, if one row data is required Unique and sumif also can be used

  • @oluwandetowoju6323
    @oluwandetowoju6323 5 часов назад

    All the methods are unique and simple

    • @K_Michael
      @K_Michael 4 часа назад

      1 &. 2 for me. I like option 2 best

  • @MohitKumar-iw5io
    @MohitKumar-iw5io 7 часов назад

    I'll always be greatful you.

  • @habelabr
    @habelabr 9 часов назад

    Thank you! A very well explained video

  • @cjbrown3396
    @cjbrown3396 11 часов назад

    Hey Kenji I faced a problem when sending the emails. Error shows "ActiveX Component Cant Create Object Run-time 429 Error." Debug line highlighted Set outApp = CreateObject("Outlook.Application"). Could you please help?

  • @user-cy8qh6qe2m
    @user-cy8qh6qe2m 12 часов назад

    I got the bonus but did it this way! =LEFT(C6,SEARCH("(",C6)-1)

  • @user-cy8qh6qe2m
    @user-cy8qh6qe2m 12 часов назад

    I passed! have an interview tomorrow

  • @aymen5506
    @aymen5506 14 часов назад

    You a king for this for real, every other video about sql are just guys yappin about useless things, you got straight to the point, keep up the good work man

  • @junaidimtiaz2394
    @junaidimtiaz2394 16 часов назад

    I would love to learn more about statistical analysis especially regression analysis. Youre lessons are the most concise and time efficient lessons on youtube , so would really appreciate if you could make the requested video.

  • @kellyharper2039
    @kellyharper2039 16 часов назад

    Thanks so much - this was amazing and exactly what I was looking for. Will be exploring more of your content and courses.

  • @manosvenianakis9323
    @manosvenianakis9323 20 часов назад

    I use excel just for fun. My job requires zero to none Excel knowledge. However this test was too easy for Excel interview. Is that just for 1st round?

  • @vasimshaikh6163
    @vasimshaikh6163 22 часа назад

    Mail merge is the best option for bulk mailing. Learned that way back in 2006. But still happy to learn more. Thanks

  • @louisewollerton3400
    @louisewollerton3400 22 часа назад

    I need to arrange 6 people to come on the same day at different interview times. While here, they will need to take part in 4 tasks. How can I schedule them so they don't clash and all be finished by 1pm? (Starting at 9am). Is this doable?

  • @karinadiaz5763
    @karinadiaz5763 22 часа назад

    5:24 I get an error when I use this formula, it gives me a number value. I followed you step by step

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 23 часа назад

    great

  • @mohdabdulmateen5159
    @mohdabdulmateen5159 День назад

    Hey Kenji bro ! Greatly appreciated this video as I’ve got to know these tricks, and the way you explain it feels to learn more.❤❤❤❤❤❤❤❤

  • @NaveenKumar-ic1ky
    @NaveenKumar-ic1ky День назад

    It is not available

  • @AkashGupta-fm2ys
    @AkashGupta-fm2ys День назад

    Very good teaching dear.

  • @divyv20
    @divyv20 День назад

    Hey Kenji , really nice video ! I was wondering if I could help you with more Quality Editing in your videos , make a highly engaging Thumbnail and also help you with the overall youtube strategy and growth ! Pls let me know what do you think ?

  • @jayantsingh9978
    @jayantsingh9978 День назад

    !!!!!!!!!Warning!!!!!!! I found an error kindly resolve it. In the if else rule in timeline 5:30 tge otherwise insert the text will copy the bank name as Barclays to every condition where the commission amount is greater than 4000...... also the bank name does not change as per different people 5:29 after this step

  • @AZ4ZEL666
    @AZ4ZEL666 День назад

    Sir, you explain it very well. THANK YOU SO MUCH❤

  • @karanmalhotra1308
    @karanmalhotra1308 День назад

    Hey Kenji just wanted to check how can we do it if we want to attach some attachments like an excel sheet or PDF

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    amazing

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    excellent

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    great

  • @NodictatorsinKZ
    @NodictatorsinKZ День назад

    This is awesome! Loved it and use it for my projects.

  • @philvuk
    @philvuk День назад

    Awesome video as usual… we want more of it ;))

  • @arih32
    @arih32 День назад

    Hi Kenji. It was a good tutorial. If there is any method to use gmail instead using outlook, kindly guide us

  • @camlex6310
    @camlex6310 День назад

    This is really cool and helpful!! Thanks

  • @stark3221
    @stark3221 День назад

    Bro can you tell me how can i get internships, i am in 2nd year of my college degree pursuing bcom hons

  • @SportsHunterArea
    @SportsHunterArea День назад

    Create video on click product picture add price of that product to total For example: click pizza picture 🍕 add price of pizza to the Total price

  • @coolkidz33
    @coolkidz33 День назад

    Awesome video as always. I have used mail merge but wanted to know if there is a way to customize the subject line for each person. Maybe adding the customer name in the subject line for each email. Do you know if this can be done?

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    awesome

  • @DigitalTrade24747
    @DigitalTrade24747 День назад

    Thanks

  • @ignaciopazgarcia5370
    @ignaciopazgarcia5370 День назад

    King Kenji

  • @nkechiizeji
    @nkechiizeji День назад

    I think Google form is easier.

  • @shreyatiwari4985
    @shreyatiwari4985 День назад

    Very very nice, thank you so much :)

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    amazing

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    superb, keep it up

  • @calvinyip364
    @calvinyip364 День назад

    How can it be use for accounting? Calculate costing etc. or doing conversion

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    great, keep it up

  • @muhammadhasanraza1606
    @muhammadhasanraza1606 День назад

    awesome video, keep it up