8 Awesome Excel Add-Ins You Should Know!
Вставка
- Опубліковано 27 чер 2024
- Free Excel Add-ins to boost your productivity.
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
In this tutorial, we cover Excel Add-ins step by step. First we learn to install Excel add-ins from scratch. Then, we cover 8 Excel add-ins to boost your productivity. These include the activity timer to track time spent on tasks in Excel, the people graph for an awesome excel visual, chatgpt in Excel to ask for anything, FRED to track and source economic data, QR4Office to get generate QR codes, Wikipedia to drag and drop any information from the internet, and finally the calendar add-in to insert the exact date and time.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - How to Install Excel Add-Ins
0:40 - Activity Timer Add-In
2:01 - People Graph Add-In
3:06 - Chat GPT in Excel
4:45 - FRED
6:40 - QR4Office
8:12 - Wikipedia
9:27 - Analysis Toolpack
12:14 - Mini Calendar
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
🤩Take our Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
Give me coupon code for your Excel and power Bi bundle please :)
Thanks for all the great tips!!
Awesome introduction video to Excel add-ins. Thanks for sharing!
Nice to see you back Kenji
Thank you for watching :)
this video was useful for me! thank you.
Never knew i can add add-ins in an excel sheet. Thank you!
Thank you so much for the great & informative video!
Glad it was helpful!
Excellent! Bro you're the master of Excel...
Thank you so much 😀
wow Been an excel user for so long I did not even notice the ADD INs button ever
Awesome! Glad it was helpful :)
Glad to see this
Lets go!
Great Sir
Thanks for making an informative video
thank you for watching :) glad you liked it!
Sir How can I contact you to get more information or ask some questions
Great info. Can I create a qt code in excell and insert that in another document?
Very useful for all financial analysts.
Can you also make a video on adding in tools for MS Word. It will be a great help. 👍
Thanks for your comment, I'll keep your suggestion noted but can't promise anything :)
Super sir❤
thank you!
Hey Kenji... off the wall question. What editing software do you use?
Good video
Glad to hear that!
Many thanks Kenji. Just to ask a follow up question, can we use AI formulas for our specific data, how to make the AI functions refer the data?
@kenjiExplains please make a video on how to perisnalize first in excel sheet using gpt for free
Is it possible to make custom word document as default in word?
ChatGPT summary :
Here's a breakdown of the eight awesome free Excel add-ins discussed in the video:
1. **Activity Timer Add-In**:
- Allows you to record time spent on different activities.
- Simply add activities, start recording time, switch between activities, and end recording.
- Useful for tracking time spent on tasks, especially for consultants or students.
2. **People Graph Add-In**:
- Creates visual representations of data.
- Customize graphs with various themes, shapes, and colors.
- Dynamically updates with changes in data.
3. **Chat GPT for Excel**:
- Enables interaction with ChatGPT directly within Excel.
- Use formulas to ask questions and receive answers, leveraging AI capabilities.
- Supports various functions, including asking questions and generating tables.
4. **FRED (Federal Reserve Economic Data)**:
- Provides access to economic data from the Federal Reserve Bank of St. Louis.
- Retrieve data on GDP, national income, and more.
- Offers options to customize data retrieval based on parameters like time frame and geography.
5. **QR for Office Add-In**:
- Generates custom QR codes directly within Excel.
- Customize QR codes with URLs, email addresses, phone numbers, etc.
- Useful for adding interactivity or linking to external content.
6. **Wikipedia Add-In**:
- Accesses Wikipedia articles directly within Excel.
- Retrieve text and images from Wikipedia articles.
- Insert selected content into Excel for analysis or reference.
7. **Analysis Toolpack Add-In**:
- Provides a set of data analysis tools within Excel.
- Perform descriptive statistics, correlations, and more.
- Useful for conducting advanced data analysis directly within Excel.
8. **Mini Calendar Add-In**:
- Adds a mini calendar and date picker to Excel.
- Easily select dates and times for data entry or tracking purposes.
- Customize calendar settings, such as week start day and display options.
These add-ins offer a range of functionalities, from data analysis and visualization to time tracking and data retrieval, enhancing the capabilities of Excel for various tasks and workflows.
how can i activate my data types option on my excel ribbon
❤
I really have a problem with my excel, it doesn't show the option to import data from image, how shall I do that?
I assume these add-ins won't be available for a user that does not have these add-ins. Meaning not advisable to share these files if other users don't have these add-ins?
Hey there, if you don't have the add-ins you can download them as I should towards the beginning of the video
first
thanks!