8 Awesome Excel Add-Ins You Should Know!

Free Excel Add-ins to boost your productivity.

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:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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.

[power-reconcile]

Awesome introduction video to Excel add-ins. Thanks for sharing!

[sarahadel]

this video was useful for me! thank you.

[gitali]

Never knew i can add add-ins in an excel sheet. Thank you!

[DataStadium]

Thank you so much for the great & informative video!

[supafly]

wow Been an excel user for so long I did not even notice the ADD INs button ever

[bassguitarplayer]

Excellent! Bro you're the master of Excel...

[benosborne]

Great info. Can I create a qt code in excell and insert that in another document?

[meliorism]

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?

[mrhoneystinger]

Hey Kenji... off the wall question. What editing software do you use?

[rafayhussain]

Great Sir
Thanks for making an informative video

[ashishbhasin]

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. 👍

[vikashkumar-krpl]

Is it possible to make custom word document as default in word?

[gamingzoneplayeroff]

@kenjiExplains please make a video on how to perisnalize first in excel sheet using gpt for free

[ojobohruth]

how can i activate my data types option on my excel ribbon

[AzeezulGani]

I really have a problem with my excel, it doesn't show the option to import data from image, how shall I do that?

[CrazyGuy]

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?

[nessim.liamani]

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.