How to Create Reusable Templates in Word, Excel, and PowerPoint
Templates are time-savers. Instead of recreating the same document, spreadsheet, or presentation layout every time, you can design it once and reuse it whenever you need. Microsoft Word, Excel, and PowerPoint all support custom templates, helping you streamline your work and keep your materials consistent. In this post, we’ll walk through how to create and save reusable templates in each application. https://dellenny.com/how-to-create-reusable-templates-in-word-excel-and-powerpoint/
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I select the name of the plan from a dropdown. Column D which is "Unique ID" Column I which is "Baseline Date" Column L which is "% Complete" Sheet "Tracker" is a Table called "Table1" I am looking for code (which I will activate by a button) which will look on sheet "Tracker" column Name "Workstream / Project" and if it doesn't match "PlanName" then go to the next row. If it matches then it needs to compare from sheet "My Plan" column D with sheet "Tracker" field "Plan Unique ID". If they are the same it needs to copy sheet "My Plan" column I and L to sheet "Tracker" fields "Baseline Due Date" and "Percentage Complete %". Great if you can helpExcel Turns 40: Join the Celebration!
This year marks a major milestone—Microsoft Excel turns 40! In honor of four decades of innovation, we’re kicking off “40 Days of Excel”, a global community celebration spotlighting the features that made Excel iconic. It all started on September 30, 1985, when Excel debuted on the Macintosh, introducing a revolutionary graphical interface for spreadsheets. Since then, Excel has evolved into a productivity powerhouse, empowering people and organizations across the globe. Starting today, August 6, we’ll count down to Excel’s birthday with 40 days of features—each one introduced by an Excel MVP or Creator. These passionate experts will share what makes each feature special, offer pro tips, and tell personal stories of how Excel has shaped their work and creativity. This isn’t just a look back—it’s a 40-day journey through Excel’s evolution, packed with nostalgia, insights, and surprises. We invite you to follow along, learn something new, and share your own Excel memories with us. #Excel40 --- Day 1 Let's get started with some favorite keyboard shortcuts—Deb Ashby Day 2 Some favorite number formatting tricks—Leila Gharani Day 3 Save time every single day with Freeze Panes—Grant Day 4 One of the most iconic and enduring features: AutoSum—Bill Jelen aka Mr. Excel Day 5 Some PivotTable tips and tricks—Leila Gharani Day 6 Automate your workflow in seconds with macro recorder—Grant Day 7 VBA and charting—Jon Peltier Day 8 Use Goal Seek to quickly solve for the exact input value needed to reach a desired result—Bill Jelen aka Mr. Excel Day 9 Conditional formatting—John Michaloudis Day 10 Use data validation to help minimize errors in your spreadsheets—Deb Ashby Day 11 Filter by selection—John Michaloudis Day 12 Excel Tables (aka Ctrl-T tables)—by Jon Acampora Day 13 Dynamic charting with Tables—Jon Peltier Day 14 Show trends at a glance with sparklines—Grant Day 15 Reminiscing and reflecting on a favorite feature: Power Query—Oz du Soleil Day 16 Another favorite feature: PowerPivot—Ken Puls Day 17 Filter data using slicers—Aline Day 18 Analyze trends over time using timeline—Sheet Sensei Day 19 Automatically fill your data using Flash Fill when it senses a pattern—Jon Peltier Day 20 AutoSave had me—Leila Gharani Day 21 Instead of tennising emails, just add a threaded comment—Mynda Treacy Day 22 Create your own customized views using Sheet View—Deb Ashby Day 23 See what changes others have made to your workbook using Show Changes—Jon Acampora Day 24 An all time favorite dynamic array function: the FILTER function—Excel Dictionary Day 25 One of Miss Excel's favorite features: XLOOKUP—Miss Excel Day 26 Find UNIQUE values in your data—Aline Day 27 Write your own Excel functions with LET & LAMBDA—Dim Day 28 Dynamic charting with dynamic arrays—Jon Peltier
Data validation based on value in a cell
Good afternoon, If anyone could help, this would be great. I'm trying to build an Excel in which I can pick a brand in a cell based on data validation, than in another cell I would like to pick a series based on a reduced data validation. And so on with Typenummers. So ideally, I would like to pick a Merk (for this example Lekker), then pick a Serie from a drop down that only shows XL and S (for this example S), and that select a Typenummers from a drop down that only shows 753 and 159. Any advice is welcome, thanks! Reinier - The Netherlands
Auto save is not enabled prompt every time.
In word when I open documents there is a yellow bar telling me autosave is not enabled. I know, I am a grown adult and chose not to have auto save. How can I stop this annoying yellow bar? Whilst we are at it, how can I stop excel from telling my my work book might be slow on every workbook I open? Who in the coding department thinks this is helpful?
Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine
Maximum number of arrays to use with SUMIFS
Hi, I have a situation where I need to sum a column where it would be ideal if SUMIFS could use three (or more) arrays in M365. The following sample SUMIFS nested in a sum statement works fine, but I'd like to add a third column/array after {"D";"E"}. Can anyone tell me if this can be done or should I just use multiple SUMIFS formulas without arrays. I've tried researching this and the closest answer is to use the semi-colon in the second array. However, I'm unable to find information about adding a third array. =SUM(SUMIFS(DATA[Eligibility], DATA[Location], {"A","B"}, DATA[SchoolType], {"D";"E"})) Appreciate your thoughts and suggestions.
