Excel.Xpress

Guess The Year & Win a FREE Excel Class! 📊 - Excel_Xpress

Hey friends! A few years ago, I embarked on a career and personal life transformation, and I can confidently say that the time and resources invested have been worthwhile. However, I've learned that the journey of transformation is a continuous process of learning and growth because "The skill it takes to start anything is not the skill it takes to remain, last, and outlast." So, whatever level you are, you need to Learn! Learn!! Learn!!!

I'm feeling nostalgic today and decided to share three throwback pictures with you all. 📷 Can you guess what year Picture 2 was taken? 🤔 If you get it right, you'll win a FREE Excel class with me - Excel_Xpress 🎉

Here's the deal:
🔍 Picture 1: A blast from the past, 8 years ago! Can you believe how time flies?
🔒 Picture 2: This one's a mystery, waiting for your detective skills to crack!
🕰️ Picture 3: Captured in 2023, a glimpse into more recent memories.

To enter this challenge:
👍 Like this post and follow me!
🔍 Take your best guess at the year Picture 2 was taken!
💬 Leave your guess in the comments below!

To maximize the class, you MUST:

- Be ready and eager to learn Microsoft Excel (either at Basic, Intermediate, or Advanced levels).
- Have access to a Personal Computer (PC)
- Have a Strong Internet connection for an Online class.

Ready to sharpen your Excel skills further? Whether you're an individual looking to enhance your proficiency or a corporate organization seeking tailored training solutions, I'm here to help! With years of experience in training individuals and organizations on Excel, I offer comprehensive courses that cater to your specific needs and objectives.

Tag your friends to join the fun! The winner(s) with the correct guess will receive a FREE class with Excel_Xpress. Let's see who's got the sharpest eye for detail! 🔎💼

📌📌Please note: This offer is valid until 11:59 PM on May 16th, 2024.

Hello Excel Enthusiasts

What are your 3 most frequently used Excel Functions and Formulas?
Share with us - Excel_Xpress

ACCESSING YOUR WORKBOOK STATISTICS

Workbook Statistics is an amazing feature in Excel that provides you with the counts and other information about your current worksheet and the entire workbook.

For instance, if you receive a workbook from a colleague and you want to know how many sheets it contains without scrolling through, try Workbook Statistics and get the result in splits of seconds.

STEPS:
1. Select the "Review" tab as highlighted on the attached image

2. Select "Workbook Statistics" which is directly under the "Insert" tab

Automatically, the information displays.

Shortcut Keys: Ctrl + Shift + G

NOTE: This same method of accessing Workbook Statistics is not available in Excel 2013 and older versions.

Try this out and share the valuable information you got about your workbooks/worksheets.

To expressly view your workbook statistics, simply hit Ctrl + Shift + G

Hello Excel Enthusiasts

Do you know you can EXTRACT FORMULA FROM A CELL AS TEXT?

An Excel FORMULATEXT function helps you extract Formula as a Text string from a cell. This has been introduced in Excel for almost a decade now.

For instance, if a formula is used in a cell(s) and I want to show the formula array or the synthax to my students in a text form, then FORMULATEXT is the best deal in the game.

Looking at the image here, Column D (Full Name) contains CONCATENATE function which is the combination of Column B (Last Name) and Column C (First Name).
Then Column E (FORMULATEXT) displays the formula in Text form.

The synthax is very simple. Just one argument 👌

=FORMULATEXT(reference)

Where reference is the cell that contains the formula of your interest.

TRY THIS: Copy a formula in one cell and paste in another cell. What happens there will help you appreciate more the magic of FORMULATEXT.

Trust this is helpful or do want to know more about it?
Kindly share your views and questions with us.



Excel_Xpress Excel.Xpress

Dear Excel Enthusiasts

We receive a lot questions and problems to solve on Excel privately.

Please note that your comments, questions and enquires here on the Community platforms - Excel_Xpress & Excel.Xpress will receive express attention than private messages except for sensitive documents that cannot be shared with the public.

Let's have a super interactive time together so that many can learn from the interactions.

Thank you!
@

There are basically 2 types of References in Excel. Relative and Absolute References. To expressly switch between Relative and Absolute, use F4 key.