Share this page!

Excel Dictionary ☕️ Profile picture
Twitter logo
Sep 20 • 2 tweets • 1 min read
How to create barcodes in Excel. 🤯 #excel
Follow me @exceldictionary for even more Excel tips and tricks.

And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com/collections/ex…

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Excel Dictionary ☕️

Excel Dictionary ☕️ Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @exceldictionary

Excel Dictionary ☕️ Profile picture
Sep 21
7 Excel Quick Analysis (QA) that analyze your data, so you don't have to:
1. Running Total

Calculating data metrics like running total can be tricky, but not with QA. Select the data you want to calculate > QA > Totals tab > Running Total. As you can see, Excel auto-calculated the running total and even inserted all the formulas for us!
2. % Total

Now that we know how to calculate the running total with QA, let’s learn how to calculate % of the total. Select the data you want to calculate > QA > Totals tab > % Total. Once again, Excel auto-calculated % of the total for each value and inserted all the formulas!
Read 9 tweets
Excel Dictionary ☕️ Profile picture
Sep 15
5 Excel shortcuts to improve daily productivity:
1. Copying Data

99% of Excel users copy and paste data daily, so why not do it as efficiently as possible? Just select the data you want to copy, hold CTRL, and drag the data to where you want it to be pasted.
2. Moving Data

Now that we know how to quickly copy data, let’s learn how to quickly move it. Instead of cutting and pasting, select the data you want to move, hold SHIFT, and drag the data to its new location.
Read 7 tweets
Excel Dictionary ☕️ Profile picture
Sep 8
6 Excel features that will blow your mind:
1. Data Types (DT)

Spare yourself the google search and let Excel search for you using DT. DT pull real-time data into Excel. To convert text strings into linked DT, just select the data category under the data tab. Now, simply select the attributes you want to pull into Excel.
2. Flash Fill (FF)

Say goodbye to writing complex functions to manipulate data, and hello to FF. FF automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will auto-fill the pattern down the column!
Read 8 tweets
Excel Dictionary ☕️ Profile picture
Sep 1
10 must-know Excel shortcuts:
1. CTRL E

CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.
2. ALT =

Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
Read 12 tweets
Excel Dictionary ☕️ Profile picture
Aug 25
6 essential text formatting hacks every Excel user should know: ✍️
1. Split Cell

Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
2. Rotate Text

Rotating text is a great way to clean up your worksheet by removing unnecessary space in cells caused by long data headers. To rotate text, simply select the cells containing the text you want to rotate > Home tab > Orientation > Select desired orientation.
Read 8 tweets
Excel Dictionary ☕️ Profile picture
Aug 2
7 Excel Data Visualization Tricks to learn in 5 minutes or less. 📊
1. Sparklines

A sparkline is a mini in-cell line chart that visually represents data trends.

To add a sparkline, go to the Insert tab > Line > insert the range of the cells you want to visualize and hit okay. Lastly, fill the sparklines down the column using the fill handle.
2. Color Scales

Color Scales highlight cells in a range to indicate how large or small the value is compared to other values.

To add color scales, select the cells you want to visualize > Home tab > Conditional Formatting > Color Scales > Select any style.
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

Send Email!

Email the whole thread instead of just a link!

Separate emails with commas

:(