Discover and read the best of Twitter Threads about #ExcelTips

Most recents (17)

How to AutoFit cell sizes in Excel!

๐Ÿ—‚๏ธ Donโ€™t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel + AI in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel + AI class with Miss Excel!

โ€ข Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mgโ€ฆ
โ€ข Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6oโ€ฆ

Note: This tweet contains affiliate links
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Wed, May 31 at 9am EST
โ€ข Thur, June 1 at 2pm EST
Read 5 tweets
How to alternate row colors in Excel!

๐Ÿ—‚๏ธ Donโ€™t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel + AI in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel + AI class with Miss Excel!

โ€ข Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mgโ€ฆ
โ€ข Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6oโ€ฆ

Note: This tweet contains affiliate links
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Wed, May 31 at 9am EST
โ€ข Thur, June 1 at 2pm EST
Read 5 tweets
How to make a dynamic calendar in Excel!

๐Ÿ—‚๏ธ Donโ€™t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel class with Miss Excel!

๐Ÿค Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Thursday, 27 April 2023, 12PM EST
โ€ข Friday, 28 April 2023, 3PM EST
Read 5 tweets
How to use the series tool in Excel!

๐Ÿ—‚๏ธ Donโ€™t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel class with Miss Excel!

๐Ÿค Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Thursday, 27 April 2023, 12PM EST
โ€ข Friday, 28 April 2023, 3PM EST
Read 5 tweets
Level up in Excel in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel class with Miss Excel!

๐Ÿค Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Thursday, 27 April 2023, 12PM EST
โ€ข Friday, 28 April 2023, 3PM EST
๐ŸŽฌ If you canโ€™t make it live, replays will be available for 24 hours - however extra presents for those who come live!

โœจ Once registered, remember to save the date into your favorite calendar app!

๐Ÿน Have your computer and favorite drink ready! (This will be fun I promise!!!)
Read 4 tweets
How to translate in Google Sheets!

๐Ÿ—‚๏ธ Donโ€™t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! ๐Ÿ’ƒ๐Ÿผ Youโ€™re invited to a FREE live Excel class with Miss Excel!

๐Ÿค Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
ย 
๐Ÿ—“๏ธ Two date / time options (same content at each):
โ€ข Thursday, 27 April 2023, 12PM EST
โ€ข Friday, 28 April 2023, 3PM EST
Read 5 tweets
From F1 to F12, these function shortcuts will help streamline your workflow and make you an #MSExcel pro in no time!
๐Ÿงต
#exceltips #excelshortucts
F1 - Displays the โ€˜Helpโ€™ task pane

F2 - Edit the active cell

F3 - Displays the โ€˜Paste Nameโ€™ dialog box
F4 - Repeat last command

F5 - Displays โ€˜Go toโ€™ dialog box

F6 - Next Pane
Read 7 tweets
6 Must have line charts for business data analysis ๐Ÿ“ˆ๐Ÿ‘Œ ๐Ÿ’ฏ

๐Ÿงต
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
โ–ถ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:

#excel #exceltips #exceltricks #exceltutorials #excelformulas
1. Prevent Duplicate Data Entries in Excel with Custom Data Validation
youtube.com/shorts/oOgZLxBโ€ฆ
2. Make Budgets with spending limits in Excel
youtube.com/shorts/6kw8_baโ€ฆ
Read 12 tweets
Excel FILTER Function is now my FAVOURITE function
Here are NINE examples how FILTER function has simplified super complex tasks for us!

#excel #learnexcel #excelfunctions #exceltips #exceltricks #office365 #excel365
1. How to use FILTER Function to filter data dynamically
youtube.com/shorts/AwKsb5Vโ€ฆ
2. Find common values between two lists or columns
youtube.com/shorts/HlF72AHโ€ฆ
Read 11 tweets
๐Ÿ“Which ๐—˜๐˜…๐—ฐ๐—ฒ๐—น features you must know as ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜? ๐Ÿ”ฅ

๐Ÿงต๐Ÿ‘‡
- ๐—ฃ๐—ถ๐˜ƒ๐—ผ๐˜ ๐˜๐—ฎ๐—ฏ๐—น๐—ฒ๐˜€ ๐—ฎ๐—ป๐—ฑ ๐—ฝ๐—ถ๐˜ƒ๐—ผ๐˜ ๐—ฐ๐—ต๐—ฎ๐—ฟ๐˜๐˜€
- ๐—–๐—ผ๐—ป๐—ฑ๐—ถ๐˜๐—ถ๐—ผ๐—ป๐—ฎ๐—น ๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐˜๐˜๐—ถ๐—ป๐—ด
- ๐—–๐—ผ๐—ป๐—ฐ๐—ฎ๐˜๐—ฒ๐—ป๐—ฎ๐˜๐—ฒ
- ๐—œ๐—ณ, ๐˜€๐˜‚๐—บ๐—ถ๐—ณ, ๐—ฐ๐—ผ๐˜‚๐—ป๐˜๐—ถ๐—ณ, ๐—ฎ๐˜ƒ๐—ฒ๐—ฟ๐—ฎ๐—ด๐—ฒ๐—ถ๐—ณ
- ๐—œ๐—ณ ๐—ฒ๐—ฟ๐—ฟ๐—ผ๐—ฟ๐˜€
- ๐—จ๐—ป๐—ถ๐—พ๐˜‚๐—ฒ
- ๐—ง๐—ฟ๐—ถ๐—บ
- ๐—ฆ๐—ผ๐—ฟ๐˜
- ๐—–๐—ผ๐˜‚๐—ป๐˜๐—ฏ๐—น๐—ฎ๐—ป๐—ธ
- ๐——๐—ฎ๐˜†๐˜€ ๐—ฎ๐—ป๐˜€ ๐—ก๐—ฒ๐˜๐˜„๐—ผ๐—ฟ๐—ธ๐—ฑ๐—ฎ๐˜†๐˜€
- ๐—ฅ๐—ฎ๐—ป๐—ธ
- ๐—ฆ๐˜‚๐—บ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜
- ๐—ฆ๐˜‚๐—บ, ๐—–๐—ผ๐˜‚๐—ป๐˜, ๐—”๐˜ƒ๐—ฒ๐—ฟ๐—ฎ๐—ด๐—ฒ
- ๐— ๐—ถ๐—ป, ๐— ๐—ฎ๐˜…, ๐— ๐—ฒ๐—ฑ๐—ถ๐—ฎ๐—ป, ๐—ฆ๐˜๐—ฑ๐—ฒ๐˜ƒ
- ๐—ฅ๐—ถ๐—ด๐—ต๐˜, ๐—Ÿ๐—ฒ๐—ณ๐˜, ๐— ๐—ถ๐—ฑ
Read 4 tweets
7 *IMPOSSIBLE* looking Excel / GSheets tricks that are POSSIBLE!
#excel #learnexcel #exceltips #exceltricks #office365 #excel365
Attendance Sheet with Checkboxes in GSheets
youtube.com/shorts/M6YLt7Yโ€ฆ
Advance Attendance Sheet in Excel
[With Overtime, Paid Leaves, Half day calculations]
youtube.com/shorts/PsXIdQIโ€ฆ
Read 9 tweets
8 *NEW* Excel Functions that are changing the game!
#excel #learnexcel #excetricks #exceltips
1. UNIQUE Function
- Use UNIQUE Function to remove duplicates: youtube.com/shorts/xgf4Zpsโ€ฆ
- Drop-down lists without duplicates: youtube.com/shorts/z-Ok5hSโ€ฆ
- Combine/merge multiple lists without duplicates: youtube.com/shorts/l8ObRSGโ€ฆ
2. FILTER Function
- Use FILTER Function to filter data: youtube.com/shorts/AwKsb5Vโ€ฆ
- Find common values between lists: youtube.com/shorts/HlF72AHโ€ฆ
- Use FILTER with AND / OR Criteria: youtube.com/shorts/a_zExgPโ€ฆ
- Select and Filter Multiple non-adjacent Columns: youtube.com/shorts/aGLfHkYโ€ฆ
Read 9 tweets
5 must-know Excel skills
#excel #learnexcel #exceltricks #exceltips
1. Learn keyboard + mouse shortcuts:
- Ctrl + E [Flash Fill]:
youtube.com/shorts/uzPo_CPโ€ฆ
- Ctrl + = [Auto Sum]:
youtube.com/shorts/feldd-Pโ€ฆ
- Rearrange columns quickly:
youtube.com/shorts/bvUhr1Aโ€ฆ
- ALT + O + A [Quick format]:
youtube.com/shorts/HHFTv2fโ€ฆ
2. Make drop-down lists in Excel:
- Make lists manually:
youtube.com/shorts/tXOovKnโ€ฆ
- Make lists from data:
youtube.com/shorts/pM2I9qRโ€ฆ
- Dependent drop-down lists:
youtube.com/shorts/TkrGq7Sโ€ฆ
Read 7 tweets
Thread!
Important shortcut keys for computer โคโœŒ
CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
CTRL+Z. . . . . . . . . . . . . . . . . Undo
CTRL+B. . . . . . . . . . . . . . . . . Bold
CTRL+U. . . . . . . . . . . . . . . . . Underline
CTRL+I . . . . . . . . . . . . . . . . . Italic
F1 . . . . . . . . . . . . . . . . . . . . . . Help
F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
Read 32 tweets
EXCEL ZERO TO HERO YOUTUBE PLAYLISTS ๐Ÿงต

PART 1 ๐Ÿ‘‡๐Ÿพ
Excel is the worldโ€™s most popular data analytics tool. Companies and institutions use it to transform raw data and visualize it to gain clear insights. I have carefully curated a list of @YouTube Excel playlists from Wonderful tutors that will take you from 0๏ธโƒฃ to ๐Ÿฆธโ€โ™‚๏ธ this Month.
Read 8 tweets
Thread!
Important shortcut keys for computer โคโœŒ
CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
CTRL+Z. . . . . . . . . . . . . . . . . Undo
CTRL+B. . . . . . . . . . . . . . . . . Bold
CTRL+U. . . . . . . . . . . . . . . . . Underline
CTRL+I . . . . . . . . . . . . . . . . . Italic
F1 . . . . . . . . . . . . . . . . . . . . . . Help
F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
Read 31 tweets

Related hashtags

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.00/month or $30.00/year) and get exclusive features!

Become Premium

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

Donate via Paypal Become our Patreon

Thank you for your support!