Discover and read the best of Twitter Threads about #exceltricks
Most recents (14)
How to AutoFit cell sizes in Excel!
๐๏ธ Donโt forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
๐๏ธ 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
โข 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
ย
๐๏ธ Two date / time options (same content at each):
โข Wed, May 31 at 9am EST
โข Thur, June 1 at 2pm EST
How to alternate row colors in Excel!
๐๏ธ Donโt forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
๐๏ธ 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
โข 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
ย
๐๏ธ Two date / time options (same content at each):
โข Wed, May 31 at 9am EST
โข Thur, June 1 at 2pm EST
How to make a dynamic calendar in Excel!
๐๏ธ Donโt forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
๐๏ธ 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
๐ค 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
ย
๐๏ธ Two date / time options (same content at each):
โข Thursday, 27 April 2023, 12PM EST
โข Friday, 28 April 2023, 3PM EST
How to use the series tool in Excel!
๐๏ธ Donโt forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
๐๏ธ 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
๐ค 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
ย
๐๏ธ Two date / time options (same content at each):
โข Thursday, 27 April 2023, 12PM EST
โข Friday, 28 April 2023, 3PM EST
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
๐ค 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
ย
๐๏ธ 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!!!)
โจ 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!!!)
How to translate in Google Sheets!
๐๏ธ Donโt forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
๐๏ธ 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
๐ค 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
ย
๐๏ธ Two date / time options (same content at each):
โข Thursday, 27 April 2023, 12PM EST
โข Friday, 28 April 2023, 3PM EST
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
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.
Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:
#excel #exceltips #exceltricks #exceltutorials #excelformulas
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โฆ
youtube.com/shorts/oOgZLxBโฆ
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
Here are NINE examples how FILTER function has simplified super complex tasks for us!
#excel #learnexcel #excelfunctions #exceltips #exceltricks #office365 #excel365
๐Which ๐๐
๐ฐ๐ฒ๐น features you must know as ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐? ๐ฅ
๐งต๐
๐งต๐
- ๐ฃ๐ถ๐๐ผ๐ ๐๐ฎ๐ฏ๐น๐ฒ๐ ๐ฎ๐ป๐ฑ ๐ฝ๐ถ๐๐ผ๐ ๐ฐ๐ต๐ฎ๐ฟ๐๐
- ๐๐ผ๐ป๐ฑ๐ถ๐๐ถ๐ผ๐ป๐ฎ๐น ๐ณ๐ผ๐ฟ๐บ๐ฎ๐๐๐ถ๐ป๐ด
- ๐๐ผ๐ป๐ฐ๐ฎ๐๐ฒ๐ป๐ฎ๐๐ฒ
- ๐๐ณ, ๐๐๐บ๐ถ๐ณ, ๐ฐ๐ผ๐๐ป๐๐ถ๐ณ, ๐ฎ๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ๐ถ๐ณ
- ๐๐ณ ๐ฒ๐ฟ๐ฟ๐ผ๐ฟ๐
- ๐จ๐ป๐ถ๐พ๐๐ฒ
- ๐ง๐ฟ๐ถ๐บ
- ๐ฆ๐ผ๐ฟ๐
- ๐๐ผ๐๐ป๐๐ฏ๐น๐ฎ๐ป๐ธ
- ๐๐ผ๐ป๐ฑ๐ถ๐๐ถ๐ผ๐ป๐ฎ๐น ๐ณ๐ผ๐ฟ๐บ๐ฎ๐๐๐ถ๐ป๐ด
- ๐๐ผ๐ป๐ฐ๐ฎ๐๐ฒ๐ป๐ฎ๐๐ฒ
- ๐๐ณ, ๐๐๐บ๐ถ๐ณ, ๐ฐ๐ผ๐๐ป๐๐ถ๐ณ, ๐ฎ๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ๐ถ๐ณ
- ๐๐ณ ๐ฒ๐ฟ๐ฟ๐ผ๐ฟ๐
- ๐จ๐ป๐ถ๐พ๐๐ฒ
- ๐ง๐ฟ๐ถ๐บ
- ๐ฆ๐ผ๐ฟ๐
- ๐๐ผ๐๐ป๐๐ฏ๐น๐ฎ๐ป๐ธ
- ๐๐ฎ๐๐ ๐ฎ๐ป๐ ๐ก๐ฒ๐๐๐ผ๐ฟ๐ธ๐ฑ๐ฎ๐๐
- ๐ฅ๐ฎ๐ป๐ธ
- ๐ฆ๐๐บ๐ฝ๐ฟ๐ผ๐ฑ๐๐ฐ๐
- ๐ฆ๐๐บ, ๐๐ผ๐๐ป๐, ๐๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ
- ๐ ๐ถ๐ป, ๐ ๐ฎ๐ , ๐ ๐ฒ๐ฑ๐ถ๐ฎ๐ป, ๐ฆ๐๐ฑ๐ฒ๐
- ๐ฅ๐ถ๐ด๐ต๐, ๐๐ฒ๐ณ๐, ๐ ๐ถ๐ฑ
- ๐ฅ๐ฎ๐ป๐ธ
- ๐ฆ๐๐บ๐ฝ๐ฟ๐ผ๐ฑ๐๐ฐ๐
- ๐ฆ๐๐บ, ๐๐ผ๐๐ป๐, ๐๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ
- ๐ ๐ถ๐ป, ๐ ๐ฎ๐ , ๐ ๐ฒ๐ฑ๐ถ๐ฎ๐ป, ๐ฆ๐๐ฑ๐ฒ๐
- ๐ฅ๐ถ๐ด๐ต๐, ๐๐ฒ๐ณ๐, ๐ ๐ถ๐ฑ
7 *IMPOSSIBLE* looking Excel / GSheets tricks that are POSSIBLE!
#excel #learnexcel #exceltips #exceltricks #office365 #excel365
#excel #learnexcel #exceltips #exceltricks #office365 #excel365
Attendance Sheet with Checkboxes in GSheets
youtube.com/shorts/M6YLt7Yโฆ
youtube.com/shorts/M6YLt7Yโฆ
Advance Attendance Sheet in Excel
[With Overtime, Paid Leaves, Half day calculations]
youtube.com/shorts/PsXIdQIโฆ
[With Overtime, Paid Leaves, Half day calculations]
youtube.com/shorts/PsXIdQIโฆ
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โฆ
- 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โฆ
- Make lists manually:
youtube.com/shorts/tXOovKnโฆ
- Make lists from data:
youtube.com/shorts/pM2I9qRโฆ
- Dependent drop-down lists:
youtube.com/shorts/TkrGq7Sโฆ
Thread!
Important shortcut keys for computer โคโ
CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
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
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
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
Thread!
Important shortcut keys for computer โคโ
CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
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
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
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
