Skip to content
Charles Thompson

Charles Thompson

@Charles_k73

Proficient in Excel with strong foundational skills. Experienced in data handling, reporting, and analysis. Practical, step-by-step knowledge ideal for roles in finance, marketing, admin, and project management. Focused on accuracy, efficiency and informed decision-making.

  • Friends: 941
  • Followers: 2
  • Following: 1
  • Community
  • Coaching
  • Digital Marketing

Posts

  • ⌨️ Ctrl + Z: The Excel Shortcut That Saves You From Mistakes

    2025-08-22

    Everyone makes mistakes but in Excel, you can fix them instantly. The Ctrl + Z shortcut is your best friend when it comes to undoing errors and recovering your work. Here’s what you’ll learn in this quick tutorial: * ​🧠​ How Ctrl + Z works to reverse your most recent actions * ​🔁​ How to undo multiple steps (up to 100 in some versions!) * ​🖱​️ How to use the Undo button and dropdown menu to view and revert multiple changes * ​🔄​ Bonus tip: Press Ctrl + Y to redo something you’ve undone it's a full loop of control! Mastering this simple shortcut will save you time, stress, and frustration especially when working with large or complex spreadsheets.

    • #productivityhacks
    • #exceltips
    • #exceltraining
    • #keyboardshortcuts
    • #spreadsheetskills
    • #excelbasics
    • #learnexcel
    • #officeskills
    • #ctrlz
    • #undoinexcel
  • 🖨️ Ctrl + P in Excel: Print Like a Pro in Seconds

    2025-08-21

    Printing your Excel workbook doesn’t have to be a hassle. With the Ctrl + P shortcut, you can instantly open the print menu and get your spreadsheet ready for paper no mouse clicks needed. In this tutorial, you'll learn: * ​🖱​️ How to use Ctrl + P to quickly access the print dialog * ​🛠​️ How to adjust print settings like orientation, margins, scaling and selection * ​🧾​ The difference between printing entire workbooks vs. specific sheets or ranges * ​🧑​‍​💻​ Why keyboard shortcuts like this speed up your Excel workflow This is part of the Excel Mastery series, perfect for beginners and anyone ready to sharpen their Excel skills whether you're using Excel 2010, 2013, 2016 or beyond. Take the shortcut. Save time. Print smarter ​💡​

    • #exceltips
    • #exceltraining
    • #excelproductivity
    • #excelbasics
    • #learnexcel
    • #officeskills
    • #excelmastery
    • #excelshortcut
    • #ctrlp
    • #printexcel
  • 📌 Master Excel Efficiency: Cut Cells Like a Pro with Ctrl + X

    2025-08-20

    Want to speed up your workflow in Excel? Learning to use Ctrl + X is a game-changer. This simple shortcut allows you to cut selected cells, removing their content from one place and pasting it somewhere else no mouse needed. In this tutorial, we’ll break down: * How to use Ctrl + X effectively * When and why to cut data instead of copying it * Tips for avoiding common mistakes when moving cells * Compatibility across Excel 2010, 2013 and 2016 By mastering basic shortcuts like this, you’re laying the foundation for true Excel mastery from beginner tasks to more advanced data manipulation techniques. This is Video #172 in our 175-part Excel Mastery Series perfect for beginners and pros alike. Whether you're learning Excel for the first time or brushing up your skills, this is a quick win you’ll use every day. ​🧠​ Make Excel fun. Make Excel yours.

    • #productivityhacks
    • #exceltips
    • #microsoftexcel
    • #excelshortcuts
    • #exceltraining
    • #spreadsheetskills
    • #learnexcel
    • #excelmastery
    • #officetips
    • #ctrlx
  • ⌨️ Ctrl+V in Excel: It’s More Powerful Than You Think

    2025-08-19

    You probably already use Ctrl+V to paste in Excel. But did you know it's just the _tip of the iceberg_? Pasting is one of the most frequent actions in Excel and knowing different ways to paste can save you serious time. ​🧠​ In this lesson, you'll learn: * How Ctrl+V pastes everything (values, formulas, formatting) * How to refine that with Paste Values Only shortcuts * 5 different ways to paste values with keyboard shortcuts no mouse needed * How to use the Quick Access Toolbar (QAT) or custom add-ins like Paste Buddy for one-click precision ​🎯​ Featured Shortcuts: 1. Alt + E, S, V, Enter 2. Alt + H, V, V 3. Menu Key + V 4. Custom QAT button 5. Ctrl+V, then Ctrl, then V again 6. Custom shortcuts using Paste Buddy ​💡​ Why this matters: * Prevents copying hidden formatting or unwanted formulas * Gives you precise control over what gets pasted * Speeds up repetitive spreadsheet tasks significantly

    • #exceltips
    • #productivitytools
    • #excelshortcuts
    • #excelefficiency
    • #spreadsheetskills
    • #learnexcel
    • #officeskills
    • #pastevalues
    • #ctrlv
    • #keyboardhacks
  • ⌨️ Ctrl+C in Excel: Copy Smarter, Not Just Faster

    2025-08-18

    Everyone knows Ctrl+C copies data but in Excel, mastering this shortcut can save you _hours_ of time and frustration. ​🔁​ Basic Use:Use Ctrl + C to copy: * Cell values * Formulas * Formats * Data for pasting elsewhere in Excel or into other apps like Word or email ​📋​ But did you know? When working with filtered data, Ctrl+C often copies _hidden cells_ too creating messy, inaccurate results. Here’s where the real magic happens: ​👉​ Use \*\*Alt + ;\*\* (Windows) or \*\*Shift + Command + Z\*\* (Mac) to select only visible cells, then press \*\*Ctrl + C\*\* (or Shift + Ctrl + C in custom macro setups) to copy cleanly. ​💡​ This is essential when: * Working with large filtered datasets * Preparing reports or exports * Avoiding hidden data corruption

    • #exceltips
    • #datacleaning
    • #productivitytips
    • #keyboardshortcuts
    • #excelefficiency
    • #excelskills
    • #excelmacros
    • #spreadsheethacks
    • #ctrlc
    • #visiblecells
  • 📌 Excel Shortcut Power: Ctrl+S to Save Like a Pro

    2025-08-16

    You’re mid-task, working hard in Excel… and suddenly, your computer freezes. Sound familiar? Here's how to make sure it never ruins your work again. In today’s post from our Office Essentials series, we’re diving into one of the most important and simplest keyboard shortcuts you’ll ever use: Ctrl + S to save your workbook. But we’re not just stopping at the shortcut. In this video, you’ll learn: ​✅​ How to save an Excel workbook using Ctrl + S ​✅​ Three different ways to save your work ​✅​ How to create backup copies for extra security ​✅​ Why saving regularly is a habit of Excel power users ​💡​ Knowing how to save sounds basic, but forgetting to save is how hours of work get lost. Don’t let it happen to you. ​🎥​ Watch the tutorial now and make Ctrl + S your muscle memory.

    • #exceltips
    • #productivitytools
    • #microsoftexcel
    • #exceltraining
    • #keyboardshortcuts
    • #saveyourwork
    • #excelbasics
    • #excelmastery
    • #ctrls
    • #officeshortcuts
  • 📂 Open Excel Files Instantly with Ctrl + O

    2025-08-15

    Navigating through folders to open a saved workbook? That’s the slow way. Speed up your workflow with one simple shortcut:Ctrl + O instantly open any saved Excel file, right from your keyboard. In this beginner-friendly tutorial, you’ll learn: * How to open existing Excel workbooks using Ctrl + O * Two other quick ways to access your saved files * Why mastering shortcuts like this boosts productivity for any Excel user This tip works perfectly in Excel 2010, 2013, 2016 and beyond. Whether you’re managing budgets, reports, or school assignments, this shortcut gets you where you need to go fast. Mastering Excel starts with the basics and Ctrl + O is one of the easiest (and most useful) shortcuts you’ll use every day.

    • #exceltips
    • #microsoftexcel
    • #excelshortcuts
    • #exceltraining
    • #keyboardshortcuts
    • #excelforbeginners
    • #excelproductivity
    • #learnexcel
    • #officeskills
    • #ctrlo
  • 📘 Master Excel: Create a New Workbook in Seconds with Ctrl + N

    2025-08-14

    Getting started with Excel? One of the first steps to mastering this powerful tool is learning how to work efficiently and that starts with keyboard shortcuts. In today’s tutorial, we’re diving into one of the most essential and time-saving shortcuts in Microsoft Excel: Ctrl + N – Open a new, blank workbook instantly. Instead of navigating through menus or clicking through toolbars, just press Ctrl + N and you're ready to start working on a fresh spreadsheet. This shortcut works across multiple versions of Excel, including Excel 2010, 2013 and 2016. In our first video from the Excel Mastery tutorial series (175 videos in total!), we demonstrate three different ways to create a new workbook, beginning with this fast shortcut. Whether you're a total beginner or looking to sharpen your Excel skills, this is a great place to start. We're using Excel 2013 for demonstration, but don't worry the same strategies work in earlier or later versions too. Whether you're a student, entrepreneur or someone just getting into data management, mastering basic shortcuts will help you save time and work smarter. Let Excel become your powerful ally and have fun learning it! Have questions or Excel struggles? Drop a comment we’re here to help. Let’s learn Excel together! ---

    • #productivityhacks
    • #exceltips
    • #microsoftexcel
    • #excelshortcuts
    • #exceltraining
    • #keyboardshortcuts
    • #excelforbeginners
    • #learnexcel
    • #officeskills
    • #excelmastery
  • Excel Subtraction Demystified: How to Subtract Like a Pro

    2025-08-13

    Subtraction in Excel may seem simple but mastering it unlocks powerful data analysis skills. Whether you're managing budgets, analyzing sales or calculating differences, knowing how to subtract efficiently is essential. ​🧠​ What you’ll learn in this lesson: * How to subtract numbers directly in a cell * Using the “=” formula with the “-” operator for quick calculations * Subtracting values from different cells and ranges * Real-world examples like subtracting expenses from income or one date from another ​💡​ Pro Tip: There’s no built-in SUBTRACT function in Excel subtraction is done using formulas like =A1 - B1. Once you get the hang of it, you can start combining it with other functions like SUM, IF or even conditional formatting for deeper insights. ​📈​ Excel isn’t just about adding things up it's also about knowing what to take away!

    • #exceltips
    • #excelformulas
    • #dataskills
    • #exceltraining
    • #spreadsheetskills
    • #excelbasics
    • #learnexcel
    • #subtractioninexcel
  • 📌 Mastering Sigma Summation in Excel: From SUM to ∑f(x)

    2025-08-12

    Excel is a powerhouse when it comes to mathematical calculations and one of its most essential tools is the SUM() function. Whether you're totaling a column of values, applying conditions to refine your results or diving into more advanced calculations, the SUM function is where it all begins. But what if you want to go beyond simple addition? Enter _sigma summation_ the mathematical notation ∑f(x) used to sum functions over a range of values. In this post, we explore not only the basics of Excel's built-in SUM function but also how to implement custom User Defined Functions (UDFs) to calculate summations like ∑f(x) within a single Excel cell. ​✅​ Standard SUM Function Highlights: * Add individual cells or ranges: =SUM(A1:A10) * Combine multiple ranges: =SUM(A1:A10, C1:C10) * Apply conditions using SUMIF or SUMIFS ​✅​ Advanced: Using UDFs for ∑f(x) in Excel This method leverages a custom function called SigmaSums, allowing you to compute mathematical series directly inside a cell: SigmaSums Arguments: 1. The function to evaluate, as a string (e.g., "x^2") 2. The iterating variable, as a string (e.g., "x") 3. Lower bound of summation 4. Upper bound of summation 5. _(Optional)_ Step value (defaults to 1 if omitted) MultiSigmaSums takes this even further, enabling nested sigma calculations using an array of variables and corresponding bounds/steps. This powerful technique is ideal for educators, students, engineers and data analysts who want to perform symbolic summations without leaving Excel.

    • #exceltips
    • #dataanalysis
    • #spreadsheetskills
    • #learnexcel
    • #sumfunction
    • #sigmasummation
    • #exceludf
    • #excelmath
    • #functionwriting
    • #excelforstudents