@YouTube

@YouTube

Most recents (17)

CheatSheets

@The_CheatSheets

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

CheatSheets

@The_CheatSheets

How to alternate row colors in Excel!

🗂️ Don’t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Read 5 tweets

CheatSheets

@The_CheatSheets

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

Read 5 tweets

CheatSheets

@The_CheatSheets

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

Read 5 tweets

CheatSheets

@The_CheatSheets

🎬 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

CheatSheets

@The_CheatSheets

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

Read 5 tweets

Suryansh Mishra

@SuryansMisra

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

Sachin Kumar

@Sachintukumar

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

Learn Excel to excel

@exceltoexcel

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

Learn Excel to excel

@exceltoexcel

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

Sachin Kumar

@Sachintukumar

📝Which 𝗘𝘅𝗰𝗲𝗹 features you must know as 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁? 🔥

🧵👇

- 𝗣𝗶𝘃𝗼𝘁 𝘁𝗮𝗯𝗹𝗲𝘀 𝗮𝗻𝗱 𝗽𝗶𝘃𝗼𝘁 𝗰𝗵𝗮𝗿𝘁𝘀
- 𝗖𝗼𝗻𝗱𝗶𝘁𝗶𝗼𝗻𝗮𝗹 𝗳𝗼𝗿𝗺𝗮𝘁𝘁𝗶𝗻𝗴
- 𝗖𝗼𝗻𝗰𝗮𝘁𝗲𝗻𝗮𝘁𝗲
- 𝗜𝗳, 𝘀𝘂𝗺𝗶𝗳, 𝗰𝗼𝘂𝗻𝘁𝗶𝗳, 𝗮𝘃𝗲𝗿𝗮𝗴𝗲𝗶𝗳
- 𝗜𝗳 𝗲𝗿𝗿𝗼𝗿𝘀
- 𝗨𝗻𝗶𝗾𝘂𝗲
- 𝗧𝗿𝗶𝗺
- 𝗦𝗼𝗿𝘁
- 𝗖𝗼𝘂𝗻𝘁𝗯𝗹𝗮𝗻𝗸

- 𝗗𝗮𝘆𝘀 𝗮𝗻𝘀 𝗡𝗲𝘁𝘄𝗼𝗿𝗸𝗱𝗮𝘆𝘀
- 𝗥𝗮𝗻𝗸
- 𝗦𝘂𝗺𝗽𝗿𝗼𝗱𝘂𝗰𝘁
- 𝗦𝘂𝗺, 𝗖𝗼𝘂𝗻𝘁, 𝗔𝘃𝗲𝗿𝗮𝗴𝗲
- 𝗠𝗶𝗻, 𝗠𝗮𝘅, 𝗠𝗲𝗱𝗶𝗮𝗻, 𝗦𝘁𝗱𝗲𝘃
- 𝗥𝗶𝗴𝗵𝘁, 𝗟𝗲𝗳𝘁, 𝗠𝗶𝗱

Read 4 tweets

Learn Excel to excel

@exceltoexcel

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

Learn Excel to excel

@exceltoexcel

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

Learn Excel to excel

@exceltoexcel

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

#MrInfluencerUgReports 🇺🇬🇳🇬🇬🇭🇿🇦

@MrInfluencerUg1

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

Ijeoma Okereafor🚀 #DataFestAfrica2022

@MeetIjeoma

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.