Chris Menard
Chris Menard
  • Видео 1 066
  • Просмотров 21 242 711
Essential Excel Keyboard Shortcuts for Selecting Data
Join me as I guide you through essential keyboard shortcuts to quickly select ranges in Excel. Discover the power of Ctrl, Shift, Home, End, and arrow keys to enhance your productivity. I'll share tips for navigating data efficiently, dealing with blanks, utilizing tables, and selecting large ranges with ease. Perfect for both beginners and advanced users, this tutorial is part of my comprehensive Excel training series.
This video is available as a preview of my online Excel Course, available here in the introduction:
courses.chrismenardtraining.com/courses/excel-essentials
The Excel Spreadsheet I used is also available to download from the above link.
00:00 Introduction to Excel Range Select...
Просмотров: 294

Видео

MS Teams NEW feature: Change Group chat Profile Pic
Просмотров 17612 часов назад
In this video, I demonstrate a new feature in Microsoft Teams Chat that allows you to change the picture of a Group Chat. I walk you through the steps of renaming the chat, changing the image, and saving your changes. 00:00 Introduction to New Microsoft Teams Chat Feature 00:04 Renaming and Customizing Group Chats 00:15 Saving and Applying Changes 00:28 Additional Resources and Conclusion And m...
Early vs. Full Retirement - What is the breakeven age for SSA Benefits?
Просмотров 37819 часов назад
In this video, I demonstrate how to calculate the Social Security breakeven age using two methods: a simple formula you can calculate on your phone using the calculator and a detailed example in Excel. The break-even point represents when the cumulative benefits even out. Comparing 62 to 67, you have been collecting money for 60 months. When you turn 67, you start collecting more than you do at...
Combine the UNIQUE and FILTER functions in Excel
Просмотров 678День назад
In this video, I demonstrate two powerful Excel functions - UNIQUE and FILTER. Learn how to use these functions on both Mac and Windows as well as in Excel for the web and Excel 2021. I walk through practical examples, including finding unique departments and filtering training sign-ups. By the end, you’ll know how to combine these functions to streamline your data analysis. 00:00 Introduction ...
Move Meeting Controls: NEW Teams feature - Drag the Presenter toolbar
Просмотров 56114 дней назад
Join me as I showcase a new feature in Microsoft Teams that allows you to move the control bar, officially the Presenter toolbar, while sharing your screen in meetings. I'll provide a step-by-step guide on how to access and utilize this feature, including tips on how to test it yourself. Additionally, I'll highlight the convenience of the toolbar's location memory and its usability across multi...
Copilot in Word: Refine your Word Docs
Просмотров 47314 дней назад
In this video, I demonstrate how to use Microsoft 365 Copilot in Word to refine and perfect your documents. Watch as I plan a three-day conference in November, including setting up breakout sessions, keynote addresses, and after-hours events. See how Copilot makes tasks like formatting and adding details a breeze by following my prompts and generating refined drafts. Whether you're organizing e...
Teams NEW Feature: Meet Now in Group Chat - Ringless notification
Просмотров 35321 день назад
Join me as I dive into the new 'Meet Now' feature in Microsoft Teams Group Chat. Learn how this feature allows seamless impromptu meetings without disturbing all participants, enabling efficient discussions with active members. On the Microsoft Roadmap, this feature was released in May 2024, this feature enhances group communication efforts. Chapters/bookmarks 00:00 Introduction to Meet Now in ...
90,000 Records: Testing Copilot's Abilities in Excel
Просмотров 40721 день назад
In this video, I test Copilot in Excel with over 90,000 records to see if it handles large data sets effectively. I demonstrate sorting, conditional formatting, and formula applications including dollar and percentage differences between fiscal years. Join me to see Copilot in action with extensive data and decide if it meets your needs. 00:00 Introduction and Previous Mistake 00:37 Setting Up ...
NEW feature: Teams - Send Individual Channel Meeting Invites to Members
Просмотров 33628 дней назад
In this video, I demonstrate one of the new features in MS Teams. This feature allows anyone who creates a meeting for a Teams channel to send individual invites by Email to channel members. I show how this works by creating two meetings, one where I choose to use the new feature and one where I create a standard meeting. I show you how the Email appears in the inbox of someone who subscribes t...
Microsoft Teams: Voice-to-Text for Chat Messages | Dictate
Просмотров 387Месяц назад
In this video, I share a valuable tip for Microsoft Teams users who want to use voice-to-text for chatting and creating channel posts. This feature isn't available by default in Teams, but I demonstrate how it can be easily enabled on Windows 11 and mention its compatibility with Windows 10. By pressing the Windows key and H, I activate speech services to dictate messages directly into Teams. I...
Microsoft Teams: Control who can Record
Просмотров 272Месяц назад
In this video, I share how to manage who can record your Microsoft Teams meetings. With meetings I organize, I can record, but so can other Presenters. Presenters are other users in my organization invited to the meeting. As of today, the video recording lives in the OneDrive account of the user that clicks Record. It is located in the Recordings folders in OneDrive. This is a massive issue for...
Can Copilot Cope with Large Data Sets in Excel?
Просмотров 437Месяц назад
In this video, I demonstrate an update to Copilot by testing it with a dataset containing over 2000 records, which is a significant increase from the 35 to 50 records used in my previous demonstrations. I focus on an 'Invoice Date' field within a large spreadsheet to assess Copilot's capability in processing extensive data. Specifically, I challenge Copilot to generate a column chart that total...
Change your Video and Audio Preferences in Teams Meeting
Просмотров 300Месяц назад
In this Teams video, I share a helpful tip on managing audio and video settings aimed to help both before and during meetings. I begin by explaining how to access and modify audio devices and configurations, including how to deal with custom setups when using different devices for speakers and microphones. Additionally, I demonstrate how to switch between cameras and modify settings while parti...
How to export a Plan from Teams Planner to Excel
Просмотров 1,3 тыс.Месяц назад
In this tutorial, I guide you through the process of exporting a plan from Microsoft Teams to Excel. I start in the Teams app and show you my plan named 'Task'. I illustrate that the export process is the same regardless of the plan's name or which view you're in within Teams. Moving to the browser version of Tasks (tasks.office.com), I demonstrate how to access the 'Export Plan to Excel' optio...
Using VALUE Function to convert Text to Dates or Numbers in Excel
Просмотров 921Месяц назад
In this tutorial, I introduce you to converting text into numbers and dates in Excel using the VALUE function, the multiply by one trick, and the T function. I explain how to identify text masquerading as numbers or dates by alignment, the count indication in the Status Bar, and filter options. I demonstrate how to convert text to dates using the VALUE function and how to ensure correct date fo...
DELETE Unwanted Plans in Microsoft Teams Planner
Просмотров 2,8 тыс.Месяц назад
DELETE Unwanted Plans in Microsoft Teams Planner
Buy Now Or Wait? Housing Market Analysis In Excel Reveals The Best Option!
Просмотров 411Месяц назад
Buy Now Or Wait? Housing Market Analysis In Excel Reveals The Best Option!
NEW FEATURE in Teams: Personal Planner
Просмотров 875Месяц назад
NEW FEATURE in Teams: Personal Planner
How to Split Date and Time in Excel with the INT Function
Просмотров 1 тыс.Месяц назад
How to Split Date and Time in Excel with the INT Function
Copilot in Word: Can Copilot Create a Business Plan?
Просмотров 5972 месяца назад
Copilot in Word: Can Copilot Create a Business Plan?
Excel: Create a Two-Color Column Percentage Chart From S&P 500 Data
Просмотров 6232 месяца назад
Excel: Create a Two-Color Column Percentage Chart From S&P 500 Data
Multiple Conditional Formatting with Copilot in Excel
Просмотров 7462 месяца назад
Multiple Conditional Formatting with Copilot in Excel
5 Methods for Running Totals in Excel
Просмотров 1,1 тыс.2 месяца назад
5 Methods for Running Totals in Excel
How to use the Excel DATE function
Просмотров 9382 месяца назад
How to use the Excel DATE function
Check Performance - Optimize Excel Performance
Просмотров 9992 месяца назад
Check Performance - Optimize Excel Performance
Microsoft Copilot in Teams: Live Meeting Recap, Summary and More
Просмотров 1,3 тыс.2 месяца назад
Microsoft Copilot in Teams: Live Meeting Recap, Summary and More
Copilot for Excel - Is it Accurate? 11 Tests Performed
Просмотров 1,3 тыс.2 месяца назад
Copilot for Excel - Is it Accurate? 11 Tests Performed
Excel TEXTBEFORE and TEXTAFTER to Extract Data from Strings
Просмотров 7723 месяца назад
Excel TEXTBEFORE and TEXTAFTER to Extract Data from Strings
Teams Channels: Make Announcements Standout
Просмотров 5183 месяца назад
Teams Channels: Make Announcements Standout
Unlock The Secret: Displaying Seconds On Windows 11 Clock
Просмотров 7863 месяца назад
Unlock The Secret: Displaying Seconds On Windows 11 Clock

Комментарии

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

    lol it's really annoying that the column you were trying to convert was in text. I'm sure there were additional steps you could have avoided if you changed it to a date

  • @lucindarutherford3933
    @lucindarutherford3933 10 часов назад

    This was way quicker than any other videos I've looked at . Thank you

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

    Thank you so much!

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

    Thank you so much sir! This was very helpful

  • @TeresaR-ly4hx
    @TeresaR-ly4hx День назад

    this saved my life-- thank you!

  • @dianeb.5641
    @dianeb.5641 День назад

    My program does not have the icon you used beside new mail. I think it was new item. What form of outlook are you using?

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

    Thanks for the great video! I like your explanation style very much. Simple and effective.

  • @Leemmix.portal
    @Leemmix.portal День назад

    Thanks in advance

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

    Thanks for the video. . It's working with multiple criteria's as well using countifs

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

    wow! Perfect, and so well explained!. I' struggled with this. Would you be able to provid a link to sample data? Thank you so much.

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

    😭😭😭🤕🤕🤕 thank you.

  • @nasragedi-r6x
    @nasragedi-r6x День назад

    can a person not a member of the group access and modify a file

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

      No. You need to be part of the Team to access the channels and file and folders.

    • @nasragedi-r6x
      @nasragedi-r6x День назад

      @@ChrisMenardTrainingThank you for replying. How about if a member of the group shared the link to a not a member. would their name appear on the modified part?

  • @willlsmith8063
    @willlsmith8063 2 дня назад

    That spreadsheet is different class!.....thanks much appreciated......now subscribed.........all the best from Scotland

  • @ChickenNuggets2028
    @ChickenNuggets2028 3 дня назад

    Thankyou so much for this!! Very helpful

  • @twinkle34.-
    @twinkle34.- 3 дня назад

    Thanks for this video Sir 👍👍👍🙏🙏

  • @saraholmes4727
    @saraholmes4727 3 дня назад

    Hi Chris! Ty for the lesson! I work for a non-profit and this is very useful for my surveys. Unfortunately, it only shows Go to Next at the bottom and not next to each question. Can you help me?

  • @moshemaor1731
    @moshemaor1731 3 дня назад

    Hello Criss, A quite simple question in Excel, that has been bothered me for a long time: Given one Vertical colunm: R19 R10 R1000 R101 R11 R1 R2 R20 R9 CR9 CR100 CR1 CR2 Next is the line of result, I would like to get: CR1 CR2 CR9 CR100 R1 R2 R9 R10 R11 R19 R20 R101 R1000 Explanation: First to sort are the letters, Then the numbers. Notice the numbers appear in the order: 1 2 9 100 (For CR) and NOT: 1 100 2 9 (as excel likes) You may use a formula, or any other method, in order to get the correct answer. Thanks in advance, Moshe.

  • @ryanmclaren9873
    @ryanmclaren9873 4 дня назад

    Thanks, Chris. Ryan from the UK here, you have just made this look so simple to use. It is great material and a great video, I will recommend and subscribe.

  • @LuzAvendano-tj2gk
    @LuzAvendano-tj2gk 4 дня назад

    Thank you Chris. You are the best of the best. I hope you get subscribers by the millions!

  • @TimmysTreats
    @TimmysTreats 4 дня назад

    Hi Chris...I need your help. I work for a bank in the compliance department. We are preparing ourselves for the Dodd Frank 1071 ruling. look into CFPB Small Businness lending. Can you show me how I can have vba code permanently stay to allow multiple selections for a dropdown and how can I have a code in place in excel if a specific dropdown is selected another dropdown will populate.

  • @b89atchison
    @b89atchison 4 дня назад

    SO HELPFUL!

  • @thomasm5796
    @thomasm5796 5 дней назад

    Thanks a ton.

  • @monirbahgat
    @monirbahgat 5 дней назад

    Thanks a lot for this very nice way. I have a question: Can I apply this method for a sequence of say two groups: A & B so that IF I added one case in group A or B it will be numbered according to the sequence for that group?

  • @obyadulhuque5510
    @obyadulhuque5510 5 дней назад

    Thanks

  • @glenfarrelly8350
    @glenfarrelly8350 5 дней назад

    I can’t add it says you’re already syncing a personal OneDrive on this computer unlink that account to add a new one

  • @user-mn5my7qi2y
    @user-mn5my7qi2y 5 дней назад

    CAN'T DISPLAY ONLINE SERVICES Close Sorry, we had a server issue and can't display your connected services. Please try again.

  • @ashokkandukury2870
    @ashokkandukury2870 5 дней назад

    Thank you very much for your vedieo, In a Textjoin(), I was searching delimiter for a new line. Thank you once again.

  • @natashar2992
    @natashar2992 6 дней назад

    Thank you Chris! This has definitely helped me and I look forward to learning more from your channel, have subscribed.

  • @AhmedBalfaqih
    @AhmedBalfaqih 6 дней назад

    It took me one minute to subscribe. The extra efforts to film the Share bar convinced me that you will be churning out more great videos. Thank you.

  • @Project1643.
    @Project1643. 6 дней назад

    Can Excel calculate the duration of time over many days? For example, I start my well pump on June 1 at 10 AM and turn it off on June 7 at 3PM. Is there a formula that gives me the amount of hours and minutes the pump was on?

  • @aal2002
    @aal2002 6 дней назад

    Wow! This was GREAT! Thank you!

  • @Frankbrace
    @Frankbrace 6 дней назад

    Just used awesome thank you

  • @aslanpeteredmundpereja9221
    @aslanpeteredmundpereja9221 6 дней назад

    thank you for this video really helps me a lot

  • @meetbhavsar1072
    @meetbhavsar1072 6 дней назад

    Thank you sir😊

  • @TheParaRog
    @TheParaRog 7 дней назад

    Old video but just saved me a whole world of pain, thanks so much for this.

  • @zabeth11173
    @zabeth11173 7 дней назад

    Just helped me big time today!! 🎉Thank you🎉

  • @nirbhaybhargava1509
    @nirbhaybhargava1509 7 дней назад

    my show report filter is greyed out. I cant understand whats the issue. I added the filter in filters area in pivot table fields as well

  • @redrock7617
    @redrock7617 7 дней назад

    Great new feature! some colleague already have it but some others no. Hope it will be released for everyone soon

    • @ChrisMenardTraining
      @ChrisMenardTraining 7 дней назад

      according to Microsoft, it should be this month (June). We'll see, right? :-)

  • @PiuriBeko
    @PiuriBeko 7 дней назад

    Hello Chris am from Papua New Guinea am very interested to join you in excel accounting

  • @reyesmaria323
    @reyesmaria323 7 дней назад

    Nice spreadsheet - thanks! Quick quest tho, where does the Delayed Retirement come into play? Can we just substitute the Full Retirement data points with the Delayed Ret data points to see the breakeven between Early & Delayed? And vice versa, the breakeven between Full & Delayed?

  • @emmadkareem5247
    @emmadkareem5247 8 дней назад

    Thank you for the video but it is very confusing. The mathematical concept needs good explanation before introduction of Vlookup. I am yet to see anyone explain the subject in a real good way!

  • @gregorytaylor2749
    @gregorytaylor2749 8 дней назад

    When I looked at receiving SSA benefits, I learned that if you are still working, the SSA will retain $1 for each $2 that you earn over a specific $ amount. I would have received no SSA benefits, so I decided to wait until full retirement age.

  • @eric_brooks
    @eric_brooks 8 дней назад

    been searching for this for 2 days. Thanks

  • @arielo9332
    @arielo9332 8 дней назад

    thank you! it helped me

  • @HairCastle-ml1bx
    @HairCastle-ml1bx 8 дней назад

    Thank you for your wonderful lesson. Please should I apply page break at the end of each page or before in start another chapter?

  • @BartomiejMatoga-mm3gn
    @BartomiejMatoga-mm3gn 8 дней назад

    Is it safe to add new columns while still collecting responses?

  • @progmell
    @progmell 9 дней назад

    Amazing function TKS.

  • @AmieMaxwell-ip4wl
    @AmieMaxwell-ip4wl 9 дней назад

    Legend. Thank you.

  • @markbradley8198
    @markbradley8198 9 дней назад

    Good goin' Chris! Very helpful.

  • @kacingo
    @kacingo 10 дней назад

    Thank you very much