Excel TV Blog
776 FOLLOWERS
A Community at the Heart of Microsoft Excel Technology. Join over 4,000 Analysts in community that follow us through Excel newsletter and get the latest Excel tips from leaders in the analyst community.
Excel TV Blog
6M ago
The world of spreadsheets has a myriad of possibilities, and we at ExcelTV have always been at the forefront of sharing them with our community. Today, we’re thrilled to announce our partnership with The Active Cell – Financial Modeling World Cup’s official Excel Training Camp.
A Dream Team-Up for Every Spreadsheet Lover
Our shared passion for Excel brought us together, and our mission is to bring the best to our loyal fans. We’re diving deep into the heart of Excel’s newest features, innovative workshops, and networking opportunities. And guess what? This partnership comes with perks just for ..read more
Excel TV Blog
11M ago
Have you ever encountered a problem in Excel where a column of numbers or dates is preceded by an apostrophe, making it impossible to perform calculations or sort the data? Don’t worry, you’re not alone. This pesky little symbol can be a real pain, but fortunately, removing it is not as difficult as you might think. In this article, we will show you step-by-step how to remove apostrophes in Excel, and provide you with some handy tips and tricks along the way.
Table of Contents
What is an Apostrophe in Excel?
Method 1: Find and Replace
Method 2: Text to Columns
Method 3: Formula Bar
Method ..read more
Excel TV Blog
11M ago
Excel is an incredibly powerful tool, allowing users to organize and manipulate data in ways that were previously unimaginable. However, even the most seasoned Excel user can run into issues from time to time, such as accidentally sorting their data in a way they didn’t intend to. If you find yourself in this situation, don’t panic! In this article, we’ll walk you through the steps to unsort in Excel and get your spreadsheet back to the way it was before.
Table of Contents
Understanding Sorting in Excel
The Problem with Sorting: Accidents Happen
How do you Unsort in Excel?
Conclusion
FAQs ..read more
Excel TV Blog
11M ago
Microsoft Excel is a powerful tool used for organizing, analyzing, and manipulating data. While Excel is equipped with numerous features and functions, there are some keyboard shortcuts that can significantly speed up the data entry process. One such keyboard shortcut is “Ctrl+E.” In this article, we will explore what “Ctrl+E” does in Excel and how to use it effectively.
Table of Contents
What is Ctrl-E in Excel?
How to Use Ctrl+E to Format Data
How to Use Crtl+E to Fill Data
How to Use Ctrl+E to Flash Fill Data
How to Use Ctrl+E to Clear Formatting
How to Use Ctrl+E to Edit Cell Contents
H ..read more
Excel TV Blog
1y ago
Are you tired of staring at a boring Excel spreadsheet? Do you want to add some flair to your data? One simple way to make your spreadsheet more visually appealing is to angle cells. In this article, we will show you:
How to angle cells in Excel
How to slant cells in Excel
How to make diagonal cells in Excel
How to make slanted cells in Excel
By the end, you will have a better understanding of this simple yet powerful formatting technique.
Table of Contents
What is Cell Angling in Excel?
Why Angle Cells in Excel?
How to Angle Cells in Excel: Step-by-Step Guide
Tips for Using Cell Angling ..read more
Excel TV Blog
1y ago
Excel is a powerful spreadsheet software that has been around for decades and is used by millions of people all over the world. It is a software that can help you organize, analyze, and present data in a way that is both visually appealing and easy to understand. However, with so many features and functions, it can be overwhelming to know where to start. That's where the excel ribbon comes in.
The excel ribbon is a toolbar located at the top of the Excel window that provides quick access to all of the features and functions that Excel has to offer. In this comprehensive guide, we'll explore e ..read more
Excel TV Blog
2y ago
We all use Excel Spreadsheet and Microsoft Word document every time and we use them individually. But, do you know that Word document can be helpful if you face any problem with Excel Formulas? Yes, you heard it right. You can edit Excel Formulas in Word document easily. Let us say if you have any error in Excel formula and if that formula is too big to find and replace, then you can edit that Excel formula in Word document easily. Excel MVP Oz explains how it can be done.
Let’s get started! 1 – Copy Excel Formula
Let us say you have the large formula and it has some error referring some sheet ..read more
Excel TV Blog
3y ago
We continue with Season 05 and our continued support of the Global Excel Summit. Oz du Soleil joins us to discuss his presentation at the Summit. The topic for his presentation is 'Risk Taking with Content Creation. As you likely know, Oz has been an Excel MVP for several years and was involved as a co-host for many of the Excel TV episodes. In recent years, he has found his passion for creating video content. Specifically, that he found his passion for bringing something new to the table that fits with his love for Improvisation and Story Telling.
15% Off Coup ..read more
Excel TV Blog
3y ago
This is not our typical Excel blog post or video. This is a promotional video that will play at our exhibitor booth the Global Excel Summit.
However, it does contain insight on what the Excel TV Academy is all about (including a coupon code). So I thought it would be nice to share here in the event anyone wants to see what the Academy is all about.
Excel TV Academy 50% Off Coupon Code: ges2021
Click to Take Advantage of the Limited Time Offer
The Global Excel Summit that is coming February 6-9, 2021. It is a virtual conference, so you can enjoy this from the comfort of yo ..read more
Excel TV Blog
3y ago
Note: This was originally recorded in early 2020 and was shelved until now because the Excel Global Summit was postponed due to the global pandemic of 2020.
Starting off Season 05 with a BANG, we bring you Theresa Estrada - Principal Program Manager Lead at Microsoft. She is one of the Keynote Speakers at the Global Excel Summit that is coming February 6-9, 2021. It is a virtual conference, so you can enjoy this from the comfort of your own home.
15% Off Coupon Code: Excel.TV-15%
Click to Check Out the Global Excel Summit
Theresa started out in the a construction business that he ran ..read more