![Knack Training](/img/default-banner.jpg)
- Видео 174
- Просмотров 1 427 873
Knack Training
США
Добавлен 5 апр 2019
We're business educators - Microsoft 365, Power Platform, and Copilot; Project Management, Presentation Design, Data Visualization, and Accessibility.
Use Microsoft 365 Copilot for Everyday Excel Functions | Everyday Office
Microsoft Copilot is an incredibly useful tool that's been tacked onto each of the Office products. In this tutorial, Drew Tattam from Knack Training shows you several useful automations that can make your analysis of the data in your spreadsheet easier.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
- www.knacktraining.com/blog/
- www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
- www.knacktraining.com/blog/
- www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
Просмотров: 408
Видео
Use Microsoft 365 Copilot to Create a Presentation from a Document | Everyday Office
Просмотров 1073 месяца назад
If you have an elaborate report written up in Microsoft Word, starting a new presentation can be a daunting task. In this demonstration, Drew Tattam from Knack Training demonstrates how we can ask Microsoft 365 Copilot to generate slides from this file and jump into editing immediately thereafter. Everyday Office is the media arm of Knack Training, a software and professional development traini...
Power Automate Flows - Send Specific SharePoint Files via Email | Everyday Office
Просмотров 503 месяца назад
Do you need to be notified when specific work is done in a SharePoint site? In this video, Drew Tattam from Knack Training demonstrates how Power Automate can determine whether a file meets your criteria, then email you a copy of the file to look it over. This is a very useful automation for busy managers! Everyday Office is the media arm of Knack Training, a software and professional developme...
Project Management Essentials - recorded webinar | Everyday Office
Просмотров 1024 месяца назад
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: - www.knacktraining.com/blog/ - www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
Including Accessible Design in your Everyday Work - recorded webinar | Everyday Office
Просмотров 354 месяца назад
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: - www.knacktraining.com/blog/ - www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
Looking at the Future of Work with Microsoft Copilot - recorded webinar | Everyday Office
Просмотров 1244 месяца назад
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: - www.knacktraining.com/blog/ - www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
How to Use Copilot with Microsoft Outlook | Everyday Office
Просмотров 4056 месяцев назад
Microsoft 365 Copilot includes tools for automation and AI discussion in each of the Microsoft desktop and cloud applications. In this video, Drew Tattam from Knack Training demonstrates how Copilot can be leveraged in Outlook. Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content ca...
How to Use Copilot in Microsoft Word TODAY! | Everyday Office
Просмотров 1506 месяцев назад
The new Microsoft 365 Copilot for businesses is available broadly - is it worth it? In this video, Drew Tattam from Knack Training demonstrates several ways that Copilot can improve you creation of Word documents. Try it out! Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can ...
XLOOKUP to replace VLOOKUP, HLOOKUP, and INDEX & MATCH | Everyday Office
Просмотров 2397 месяцев назад
XLOOKUP is now widely available in Excel for Microsoft 365, and it's so much better than VLOOKUP it's a no-brainer to change. With XLOOKUP, you can look vertically or horizontally, as well as find matches in your data left-to-right or right-to-left. 0:00 Introduction 0:26 Why use lookup functions? 2:41 Replace VLOOKUP with XLOOKUP 4:14 Replace INDEX and MATCH with XLOOKUP 5:37 Replace HLOOKUP w...
Introduction to Project Management Fundamentals - a Webinar | Everyday Office
Просмотров 2777 месяцев назад
Many professionals are thrust into project management roles without any formal training in the field of Project Management. In this webinar, we begin to introduce these concepts and best practices, so you can be more impactful in your daily efforts. Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orland...
Using Power Automate in the Cloud - Full Webinar | Everyday Office
Просмотров 1478 месяцев назад
Knack Training runs multiple classes on Power Automate - in the cloud and on the desktop. In this webinar, led by Drew Tattam, we cover the essentials of creating your first cloud workflow. Learn to simplify your working day in minutes! Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More c...
Webinar: Data Mining in Excel - Pivot Tables, Power Query, and Power Pivot | Everyday Office
Просмотров 4579 месяцев назад
As part of the webinar series Insights with Knack Training, Neil Malek recorded the following hour-long session using Microsoft Excel to experiment with data mining techniques. During the data mining process, we must compile and clean useful data; then categorize that data; then analyze and visualize it. We used Pivot Tables, Power Query, and Power Pivot tools and techniques to accomplish these...
New Excel Functions - Recorded Webinar | Everyday Office
Просмотров 1789 месяцев назад
With the versions Excel 2019, 2021, and 365, Microsoft has been introducing new functions into the application. In this webinar, Neil Malek from Knack Training leads an hour-long exploration of various new functions. Included in this session are XLOOKUP, UNIQUE, FILTER, VSTACK, TOCOL, WRAPROWS, TEXTBEFORE, TEXTAFTER, TEXTSPLIT, LET, and LAMBDA. 0:00 Introduction 8:10 XLOOKUP function 19:00 UNIQ...
Create a Stock Price Slider Chart in Excel | Everyday Office
Просмотров 7 тыс.4 года назад
Indicating where the Current Price falls between the Low 52-wk Price and the High 52-wk Price could be done in a number of ways. In this video, we replicate a chart requested on reddit.com/r/excel with a Stacked Bar chart and a little extra math. Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, ...
Locking Label Locations for Excel Charts | Everyday Office
Просмотров 9 тыс.4 года назад
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: - www.knacktraining.com/blog/ - www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.
Replacing Random Formatting with Headings in Word | Everyday Office
Просмотров 4444 года назад
Replacing Random Formatting with Headings in Word | Everyday Office
Understanding SORT, FILTER, UNIQUE, and Dynamic Array Functions with Alan Murray
Просмотров 3884 года назад
Understanding SORT, FILTER, UNIQUE, and Dynamic Array Functions with Alan Murray
Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office
Просмотров 46 тыс.4 года назад
Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office
Using Template Emails and Rules for an AutoResponder in Outlook | Everyday Office
Просмотров 29 тыс.4 года назад
Using Template Emails and Rules for an AutoResponder in Outlook | Everyday Office
Using a Macro to Respond to Emails with a Template | Everyday Office
Просмотров 49 тыс.4 года назад
Using a Macro to Respond to Emails with a Template | Everyday Office
Using Quick Steps for Responding with Template Emails | Everyday Office
Просмотров 41 тыс.4 года назад
Using Quick Steps for Responding with Template Emails | Everyday Office
Custom Date Sort Orders in Power Pivot | Everyday Office
Просмотров 6 тыс.4 года назад
Custom Date Sort Orders in Power Pivot | Everyday Office
Use Anti-Join in Excel with Power Query | Everyday Office
Просмотров 2,5 тыс.4 года назад
Use Anti-Join in Excel with Power Query | Everyday Office
Using Power Query and Power Pivot for a Reusable Custom Calendar Table | Everyday Office
Просмотров 5 тыс.4 года назад
Using Power Query and Power Pivot for a Reusable Custom Calendar Table | Everyday Office
Use Power Query as a VLOOKUP Replacement | Everyday Office
Просмотров 39 тыс.4 года назад
Use Power Query as a VLOOKUP Replacement | Everyday Office
Recalling Emails in Outlook by Delaying Delivery | Everyday Office
Просмотров 7 тыс.4 года назад
Recalling Emails in Outlook by Delaying Delivery | Everyday Office
Convert Multiple Tables into a Single Pivot Table with Power Query | Everyday Office
Просмотров 6 тыс.4 года назад
Convert Multiple Tables into a Single Pivot Table with Power Query | Everyday Office
Power Query Calculated Columns - Dates and Logical | Everyday Office
Просмотров 39 тыс.4 года назад
Power Query Calculated Columns - Dates and Logical | Everyday Office
Text to Rows in Power Query | Everyday Office
Просмотров 6874 года назад
Text to Rows in Power Query | Everyday Office
Update a Pivot Table from an External Database with Power Query | Everyday Office
Просмотров 3 тыс.4 года назад
Update a Pivot Table from an External Database with Power Query | Everyday Office
Any joy with the follow up for getting back to all data if blank and selecting multiple regions?
Thanks a lot for this beautiful teaching and great way of explanation for beginners to can understand easily
boycott Wix
Perfectly explained
After merge queries, the data is not in the sequence anymore. How to solve it?❤
Looks like the slicer function??
I dont get the option to add the other Pivot table what should I do
Informative video! Rather than all the clicking on this and that - why not just assign the wanted text to a shortcut abbrev like theme or a3 or any quick combo that will insert the text instantly.
Thanks for sharing such a great technique by making it appear so simple. Could you please share practice sheet to follow along.
How to do this in Google sheets
How do I add a phrase at the beginning of each paragraph for a section in a report?
So much easier in 2007, just create some menu options, so thank you for the video
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
how can you match the positive and negative amounts in excel power query
I'd set the rule to reply to the subject of the email you send originally. Chances are they'll reply to that first. Then an extra rule to put those replies in a specific folder to review later
Excellent, Congratulations.
How come I can't see Co-Pilot in the Home ribbon of my 365 Excel?
Thank you is not sufficient. Thank you. Please keep on doing this. It is really helpful.
THANK YOU!
I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
do you need microsoft office subscription for adding data in powerpivot table
can you restrict editing? I'm worried about someone accidentally deleting or overwriting something important! thanks for sharing!
Wish there was exercise files for practice. Good tutorial
Thanks for that ! The way you explained the link with SharePoint here finally settled it for me how this will work with teams also ..
Here is the scenario: I have master data table, and the another table is Countries and Race. The master data has several columns + countries, with the Race column with blanks. So when I receive new data set I paste it in the master data table replacing the previous/old data and I have to place the race related to each country. Some rows don't have country because not all the individuals are foreigners. My question is after all these queries you set up, if I delete the old data from the master, paste new data set, will the query updating by refreshing, or I have to set up the whole process making the queries? What should I do with the Country Column that has blank. Should I trick it? putting type blank on the Country row and put on the Race column from the Countries and Race list as 12-Unknown? then after merging I would get rid of the blank texting. There are 100, 1000 rows where you don't want to type the race manually or use combo box with excessive clicks and select the race that hurt your hands causing injuries.
This was very helpful. Is there a way to force send emails immediately if you'd like?
Great video. If I have some dark background slides and want default text to be light but then some light background slides and want dark default, is that possible?
Incredibly helpful, thanks!!!
Can you do this with an email alias?
I actually learned some new tricks! like the subpage drag. thank you :)
Thank you for this informations
Hi, useful video. Is it possible to save the search by using different aspects, like not read + a specific category? When I click on a different criteria, the previous one will be unflagged. Thanks
😋 Promo`SM
wowww... very useful
Nice and easy to understand.
DUDE. Absolute lifesaver. Sitting there reformatting Jasper AI's wack af code for hundreds of product descriptions that would take 10 people a month to write (and I'm 1 person) without Jasper takes SOOO LONG even with the replace tool. Your video made it 1 button. A+++ video.
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
Look who is back, thanks Neil
You saved my life I spent a lot of time trying to figure a workaround. This will work. Very helpful thanks.
Thank you for sharing, it worked for me. Keep sharing your knowledge 😊
Can i hire you for an hour to help me with setting up a rule or condition in outlook 365?
I've finally found the perfect way to mirror a bar chart! Thank you!!!
The video is really a great help to many working professionals and helped me a lot. Thank you.
Surely it is quicker to read the csv in with power query as in the video, format, then load the whole table, then user a slicer for region? I know the table is large but excel handles millions of rows but its a lot simpler and deals with any new region.
Another excellent video, logical examples and clear delivery. Thank you so much
Hi team, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?
Thank you, It was great!
Vstack just blew my mind!
This was very helpful, thank you for taking the time. Much appreciated. 🙏
Thanks a lot for the video.. Could you include the link of the file, please?