7 Excel Formatting Secrets That Instantly Make You a Pro

Excel Campus - Jon • November 6, 2025
Video Thumbnail
Excel Campus - Jon Logo

Excel Campus - Jon

@excelcampus

About

Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!

Video Description

In this video, we look at 7 Excel formatting choices (battles) that will help make your reports easier to read and navigate. 👉 Download the example Excel file: https://www.excelcampus.com/tips-shortcuts/formatting-battles/ 🔗LINKS 🧑‍💻 Free Excel Workshop on the Modern Tools and Features: https://www.excelcampus.com/blueprint 🔎 Get free weekly Excel tips: https://www.excelcampus.com/newsletter/ 🎓 Become an Excel expert by joining our online courses: https://www.excelcampus.com/courses Additional Resources: ▶️Why I Don't ALWAYS Recommend Excel Tables: https://youtu.be/9nCnwrEST-c 00:00 Introduction 00:26 Currency vs Accounting 02:08 Line Breaks vs Multiple Headers Rows 03:43 Manual Colors vs Conditional Formatting 05:02 Merge vs Center Across Selection 06:48 Hiding Rows/Columns vs Grouping Rows/Columns 08:01 Custom Number Format vs Manual Typing 09:39 Borders vs Excel Tables