So convenient! Tools to improve EXCEL work efficiency
table of contents
Nice to meet you, I’m Sakashita from Beyond!
I think there are many people who use EXCEL in their daily work.
For those who use it every day, even if it is just a simple operation,
If you do it over and over again, it will take up a lot of time. . .
"I don't want to waste time working on EXCEL!"
“I want to improve work efficiency!”
For such people, we would like to introduce an add-in tool that will improve
What exactly is an add-in?
Excel add-ins are tools that power up Excel.
In addition to the add-ins that originally come with Excel, there are additional add-ins that can be used with Excel.
You can also download it if needed from the Microsoft Download Center
Add-ins are not immediately available by default in Excel.
First, you need to install the add-in and enable it if necessary.
Activate the add-in
*Newly installed add-ins will be automatically activated upon registration, so this operation is not necessary .
-
-
"File" tab - click "Options"
-
Select Add-ins in the left pane and click the Settings button at the bottom of the dialog box.
-
Check the add-ins you want to enable and click "OK"
-
Now that you know how to enable it, let me introduce you to some recommended add-in tools!
RelaxTools Addin ” provides the functionality you want
This is an add-in that installs over 250 functions that make Excel convenient.
The typical functions are like this!
・Grep inside an Excel workbook is possible.
・Convert Excel table to HTML. (Excel can be used as a designer)
- Regular expression search and replacement for strings or cells in shapes
- 2007 compatible preview screen display
- Open workbook with the same name (read-only only)
- Duplicate cell check/Number of characters/Number of bytes Confirmation of
half-width/full-width/numbers/alphabetic characters/alphanumeric characters/date check and main check digit checks, etc.
-Trim before and after cells/character insertion/character deletion/line break deletion, etc.
-Upper case/lower case/Hiragana/Katakana/Full-width/ Half-width conversion, etc.
- Non-standard functions such as swapping matrices/combining vertically with one button
- Emphasis shapes (rectangles, ellipses, arrows, speech bubbles)
- Adjustment functions such as image size, straightening arrows, etc.
・Paste the book name to the clipboard and open the current book location in Explorer
・Color palette compatible with 2003
・Move selection range up/down/left/right
・Manage sheets (sort, select, show/hide, delete sheet names) )
・Divide a book into sheets, merge multiple books into one
, and automatically set the cursor to A1 when saving.
(Partial quote: http://software.opensquare.net/relaxtools/about/ )
If you are unsure, it is convenient to install this alone!
Download here: RelaxTools Addin
Clip Stamp ” allows you to easily create electronic seals
I think there are many opportunities to stamp stamps such as confirmation stamps in the office.
With this clip stamp, you can easily create a seal!
Equipped with a total of 5 types of stamps: date stamps with date, proxy stamps, three-letter stamps, round stamps, square stamps, and two-part stamps.
You can make detailed settings such as font and frame color.
Download here: Clip Stamp
3. "Office Tab" lets you switch between tabs instead of windows
In daily work, it is common to have many Excel windows open at once.
However, if you open more than one, you have to switch between them many times, which can be quite troublesome.
With this tool, you can switch between multiple files using tabs.
This will lead to increased work efficiency!
This also supports Word and PowerPoint.
*Currently, Office Tab appears to be a 30-day trial version. . .
Download here: Office Tab
Improve your Excel skills with add-ins!
There are so many useful functions like this, so if you don't use them, you're missing out!
Let's make effective use of the tools introduced here to improve the efficiency of our work!