- 161
- 4 147
Excelevate
เข้าร่วมเมื่อ 24 ก.พ. 2018
How YOU Doodlin'? Episode 003 - The Habits of Highly Effective People - #1 Be Proactive
In this walking video episode of How YOU Doodlin'?, we discuss the first of Stephen Covey's Habits of Highly Effective People: Be Proactive.
Key Takeaways:
1. Being proactive (or prepared) is an extremely important mindset.
2. Do some research before going somewhere new or starting somewhere new.
3. Ask people who have been there before - what would they do the same or differently.
4. Learn from your own experiences, especially the ones that don't go so well. Write it down while it's fresh in your mind!
Make sure to subscribe so you don't miss the other habits!
Key Takeaways:
1. Being proactive (or prepared) is an extremely important mindset.
2. Do some research before going somewhere new or starting somewhere new.
3. Ask people who have been there before - what would they do the same or differently.
4. Learn from your own experiences, especially the ones that don't go so well. Write it down while it's fresh in your mind!
Make sure to subscribe so you don't miss the other habits!
มุมมอง: 7
วีดีโอ
10 Ways to Navigate Excel Sheets!
มุมมอง 9514 วันที่ผ่านมา
In this video, we'll look at 10 different ways to navigate sheets in Excel, from slowest to fastest. Want to learn more? Check out the blog article here: excelevate.co/wp/2024/07/03/ten-ways-to-navigate-excel-sheets/ Want to save dozens of hours a year? Try out the macros mentioned in this video and many more here: excelevate.co/wp/home/xlev8-add-in/
How YOU Doodlin'? Episode 002 - The Power of Habits (Part 2)
มุมมอง 121 วันที่ผ่านมา
In this walking video episode of How YOU Doodlin'?, we discuss more about the power of habits. Key Takeaways: 1. Make it as easy as possible to build good habits - remove all the excuses and plan ahead. 2. Make it difficult to keep doing bad habits - replace triggers with alternatives to reduce them. 3. Set reminders - digital and physical. Leave them when and where they will be effective. 4. U...
Best Practices for Excel-Driven Account Reconciliations
มุมมอง 41หลายเดือนก่อน
This video discusses ten tips for optimizing your Excel-driven account reconciliations. Get a copy of the template discussed in this video here: excelevate.co/wp/2024/06/19/excel-account-reconciliation-best-practices/
How YOU Doodlin'? Episode 001 - The Power of Habits
มุมมอง 10หลายเดือนก่อน
In this pilot walking video episode of How YOU Doodlin'?, we discuss the power of habits. Key Takeaways: 1. It takes roughly 3 weeks to build a new habit or break a bad habit. 2. To build a new habit, use the 5P Framework: PURPOSE - Why do you want to build this habit? PLAN - How are you going to build this habit? PRIORITY - When are you going to work on this habit? PRACTICE - What steps are yo...
XLEV8 Macro: Comment Picker
มุมมอง 632 หลายเดือนก่อน
Macro Minute Monday - Comment Picker This shows how you can make it much easier to use legacy comments in Excel with several options like insert, edit, delete, toggle, and more in one picklist menu shortcut. Best of all, you can include comments in one central sheet where you can track them and ensure they don't get missed. Save a lot of time and make Excel comments a whole lot easier and quicker!
XLEV8 Macro: Insert Counter Formula
มุมมอง 772 หลายเดือนก่อน
Macro Minute Monday - Insert Counter Formula This shows how you can easily and quickly insert a dynamic counter formula in Excel, leveraging the SEQUENCE and COUNTA functions. It prompts you for how many rows it should evaluate and updates when you add or remove data in the referenced rows. Save a lot of time and make counting rows in Excel a whole lot easier!
See how I automated making hundreds of LinkedIn posts with Excel and PowerPoint
มุมมอง 362 หลายเดือนก่อน
Get the template here: excelevate.co/wp/downloads/excel-to-powerpoint-template/ In this video, we walk through how I built an Excel template and integrated it with PowerPoint to create .png and .pdf files to share a nicely formatted a year's worth of daily posts with a impactful quote and a humorous dad joke using VBA.
XLEV8 Macro: Delete Picker
มุมมอง 412 หลายเดือนก่อน
Macro Minute Monday - Delete Picker This shows how you can easily and quickly perform delete commands in Excel with a shortcut-driven picklist. This brings together many delete-related actions that are spread all across Excel. Save a lot of time and make deleting a whole lot easier!
XLEV8 Macro: Insert Picker
มุมมอง 682 หลายเดือนก่อน
Macro Minute Monday - Insert Picker This shows how you can easily and quickly perform insert commands in Excel with a shortcut-driven picklist. This brings together many insert-related actions that are spread all across Excel, along with some unique commands. Save a lot of time and make inserting a whole lot easier!
XLEV8 Macro: Toggle Borders
มุมมอง 1093 หลายเดือนก่อน
Macro Minute Monday - Toggle Borders This shows how you can easily and quickly toggle through your favorite borders with one shortcut. There are many specific details and options you can apply with borders, and this lets you easily and quickly reuse that logic! Save a lot of time and make Excel borders a whole lot easier!
XLEV8 Macro: Conditional Formatting Picker
มุมมอง 383 หลายเดือนก่อน
Macro Minute Monday - Conditional Formatting Picker This shows how you can easily and quickly apply native and custom conditional formatting options that help add polish to your files and reduce risk by identifying hard-coded items, errors, and exceptions. Save time and make conditional formatting a whole lot easier!
XLEV8 Macro: Sort Picker
มุมมอง 723 หลายเดือนก่อน
Macro Minute Monday - Sort Picker This shows how you can easily and quickly sort horizontally, vertically, across sheets, and save your favorite sort criteria to use over and over again. Save time and make sorting in Excel a whole lot easier!
XLEV8 Macro: Misc Picker
มุมมอง 83 หลายเดือนก่อน
Macro Minute Monday - Misc Picker This shows how you can easily and quickly run common commands that are spread all over, such as freeze panes, showing/hiding/grouping/ungrouping/auto-sizing rows and columns, toggling gridlines, headings, the formula bar, and the clipboard pane.
XLEV8 Macro: Formula Picker
มุมมอง 2354 หลายเดือนก่อน
Macro Minute Monday - Formula Picker This shows how you can easily and quickly save, search for, and reuse your favorite formulas big and small. The more formulas you enter, the more time you can save!
10 Excel Keyboard Shortcuts You Can't Live Without
มุมมอง 704 หลายเดือนก่อน
10 Excel Keyboard Shortcuts You Can't Live Without
XLEV8 Excel Add-in - Free Lite Version - Demo - Save 20+ Hours a Year with Formatting!
มุมมอง 994 หลายเดือนก่อน
XLEV8 Excel Add-in - Free Lite Version - Demo - Save 20 Hours a Year with Formatting!
XLEV8 Add-in - Q1 2024 Update - 12 Awesome New Time-Saving Features
มุมมอง 304 หลายเดือนก่อน
XLEV8 Add-in - Q1 2024 Update - 12 Awesome New Time-Saving Features
XLEV8 Macro: Select To Bottom / Select To Right
มุมมอง 74 หลายเดือนก่อน
XLEV8 Macro: Select To Bottom / Select To Right
Data Validation: Keeping Your Excel Files Clean
มุมมอง 1165 หลายเดือนก่อน
Data Validation: Keeping Your Excel Files Clean
Nice video, thanks for sharing! ❤❤ Please feel free to checkout another option - Power Reconcile add-in for Microsoft Excel, which make it super easy for bank reconciliation in Excel with 3 easy steps.
Great stuff, as always, Derek.
Wow
Amazing
Nice!
I am starting to like your videos more and more
Promo`SM 🙏
you need to mirror your videos i guess
I have been looking to create bulk zip folders but had no idea how to. Your video is super helpful Liked and Subbed!
I have been looking to create bulk zip folders but had no idea how to. Your video is super helpful
Does it work on power query tables too?
Great idea...I just added this and I'll push it out shortly!
If you like this, you'll love our upcoming live, cohort class called Extreme Excel Efficiency, kicking off Monday, October 9. You'll be a part of an awesome community where we'll all learn from each other and as a bonus, earn 8 CPE credits! maven.com/excelevate/extreme-excel-efficiency/ Below are a couple of goodies we've shared to give even more examples of the types of items we'll be covering. Top 50 Next-Level Excel Features: maven.com/p/0403f7 All About Number Formats: Tips, Tricks, and 50 Practical Examples: maven.com/p/83855d #Excel #Efficiency #Top10Tips
How did you get the macro search box?
Hey Riajul, thanks for the feedback below! The macro search box is a modal form with a combo box, among other form elements. There are 350+ macros in the add-in, and a list of them is stored in the background, and that is used for the search suggestions as you type. While there is a nice UI ribbon to the add-in, I couldn't remember where everything was, and I've built auto-complete search boxes before, so it seemed like a great addition, and it has been. I copied that approach to several other macros for searching through files, sheets, named ranges, drop-down lists, etc. It's like a shortcut to everything.
Good quick solution
Excellent instructional video. Thank you.
0:38 If you are from USA, Canada, Australia, NZ, or EU I will setup your blog and setup it to earn money w h a t s a p p +7 9 6 7 1 5 7 0 5 8 1