Bite-Size Excel Tutorial Series target anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
-
Consolidate Multiple Sheets -Excel In A Capsule (Episode 1)
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
Consolidating Multiple Sheets into one single summary sheet is a common task in Excel. In this “Capsule” I show you 2 different Scenarios:
Scenario 1:
You have many sheets of the same layout (Same Column Headers & Same Row Headers) and same Size of Data but with different values in each Sheet.
Scenario 2:
You have many sheets with different layout (Different Column Headers & Different Row Headers) with different Size of Data and may be also different locations on the worksheet and of course with different values in each Sheet.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/7MW9pcRQI0d3zRimuKsGOY0X7Cnwgy3ciEyCjBces1i
You can also read the steps of this project with all screenshots from my blogsite See-How.ca by clicking on the link:
https://www.see-how.ca/consolidate-tens-of-sheets-in-one-step/
Your comments are important for this series to grow.
For the benefit to spread, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Hide and Protect Formulas - Excel In A Capsule (Episode 2)
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
We spend a long time creating and auditing our Formulas & Functions, which sometimes could be complicated and nested functions. When sharing the file with others we want to guarantee that no one could modify our calculations (whether intentionally or unintentionally). We can even prevent displaying those functions completely.
In this Capsule I show you first how to Find and View the functions (using 5 methods).
I then show you how to Hide & Protect your Formulas from being modified.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/H2fYLr4i0CLqwtFrrtTyvDl87ARk1StRdEHXgr6Isjl
You can also read the steps of this project with all screenshots from my blogsite See-How.ca
Your comments are important for this series to grow.
For the benefit to spread, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Copy Visible Cells Only - Excel In A Capsule (Episode 3)
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you How to copy a range that includes Filtered or Hidden Rows and when pasting you only paste the visible rows. Having done that, you ensure that your Formulas and Functions referring to visible cells work just fine.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/oFEh0mZXAQeukUfOK7sEhHXkpyv9xzoz5cwRYX34fXl
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Create Data Entry Form - Excel In A Capsule (Episode Four)
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
It's often overwhelming when entering Data in an Excel list with lots of Columns and rows , we need to keep scrolling right to left and back. To find a specific record we have to keep scrolling Up and down... Here comes the advantage of using a Data Form. It's user friendly, you see one record at a time. You use it to Navigate, Modify, Delete or even enter new records.
In this Capsule I show you how to create a Data Entry Form in less than 5 seconds... You think I'm exaggerating? watch the tutorial
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/RoxmE4Sax4UqZMh3YfaTCGCfTxo9FtBcwLXsXSX04sp
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
No More Merge & Center - Excel in a Capsule (Episode Five)
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
The Merge and Center command on the Home Tab, centers a Title but at the same time it comes with many problems as it destroys the structure of the worksheet.
What are these problems?
What's the alternate option to merge & Center?
This is what I explain in this Capsule.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/FL5uVyOXQL4sZxzkfM3Uofn8yJpT6E7r5pREIWOdGGL
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Functions Fail ? Not Anymore- Excel In A Capsule (Episode 6)
This is a Bite-Size Excel Tutorial Series (less than 4 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
Whether you are importing Data into Excel and You Fix it with Text Functions (like in our example) or If you Create regular Functions and refer to them in Other functions and so on, you end up by having kind of dependency between the different functions ... So if you delete the original functions, the subsequent ones will Fail...
This is what I explain in this Capsule.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/3LFxudwAOGR2IpbN7IUaIh3xy18X9K4VWYYNz1LXStZ
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Awesome Bullets on the Fly - Excel In A Capsule (Episode 7)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
We all use Bullets in Word and PowerPoint. However there is no similar option in Excel. In this Capsule I show you 5 different methods for inserting Bullets in Excel. Starting from a classic technique, then using Functions or Shortcuts to create the bullets as you type.
Finally Bullets shouldn't necessarily be rounded... Go beyond the classic bullets and create eye-catching ones.
This is what I explain in this Capsule.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/nzgKWxgEGEhHpXeqz5tGLwYaeIsMIzphOMqT3kM1g8A
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Banded Rows or Columns Conditional Format- Excel In A Capsule (Episode 8)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
We commonly need to format our lists with alternating colors for the Rows or Alternating colors for the columns. That improves the readability of our data. But how can we create banded Rows or Banded Columns in a List?
This is what I explain in this Capsule.
You can Download the Exercise File and follow along by clicking on the link:
https://www.see-how.ca/create-banded-rows-or-columns/
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Invert A list Horizontally and Vertical Using Function- Excel In A Capsule (Episode 9)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
We commonly need to Flip our Lists whether Vertically or Horizontally and in this tutorial I show you how to do that using simple functions.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/P5pTj1HHUR1dEdCZdhfKF4a1LQswPSiLtFMIiCVr7SB
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca. You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Your comments are important for this series to grow.
To Spread the Benefit to everyone, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
Dependent Validation…No Drop Lists - Excel In A Capsule (Episode 10)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
You may restrict what can be entered in a Cell and set rules for validating what users enter, If it matches your conditions then, it will be a valid accepted entry. Otherwise it will be rejected and an Input box will guide the user on what to provide.
You can Download the Exercise File and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/share/gUWP4qyb4aanbX1xy8zhQBUZ3jx4hbTlewT08v06FqY
You can read the Steps for the activities I show in my tutorials by going to my Blog site
www.See-How.ca.
You get lots of FREE benefits when you become a member (Totally Free). www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website
www.OfficeInstructor.ca
Your comments are important for this series to grow. To Spread the Benefit to everyone, Share it with your friends and colleagues. Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come -
Merge A Table To Itself In Power Query… Excel In A Capsule (Episode 11)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you how to merge the same table twice in Power Query, in order to extract related information from a different column and create a report.
You can Download the Exercise File and follow along by clicking on the link: https://www.amazon.ca/clouddrive/share/ByOEA2olmjMXJq0YmYp502e5TWzWU9Vs5yuLfklRa25
You can read the Steps for the activities I show in my tutorials by going to my Blog site
www.See-How.ca.
You get lots of FREE benefits when you become a member (Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Merge a Table to itself in Excel -
Lightning Fast Horizontal Line…Word In Capsule (Episode 12)
This is a Bite-Size Word Tutorial targeting anyone on the globe using MS Word, since I broke the barrier of language and I explain the topic fully in graphics.
Creating Line separators polishes your document and emphasizes important points.
In this tutorial I show you 3 different techniques for creating a Horizontal line. Each technique has different line styles.
You can read the Steps for the activities I show in my tutorials by going to my Blog site:
www.See-How.ca.
You get lots of FREE benefits when you become a member (Totally Free):
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released…
The Best Is Yet To Come.
Now let’s explore How To Create a Horizontal Line in MS Word. -
Translation Function… Excel In A Capsule (Episode 13)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you a Function that enables you to Translate From and To 60 different languages. Like any other Function, this function can be copied to adjacent cells. With a simple setup you can translate simultaneously to different languages. No other tool offers a simultaneous translation side by side.
It’s a Google Sheet Function. I wish to get it (sometime) into Excel.
You can read the Steps for the activities I show in my tutorials by going to my Blog site
www.See-How.ca.
You get lots of FREE benefits when you become a member (Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Translate with a Magical Function. -
STOP Overwriting Your Drop Lists … Excel In A Capsule (Episode 14)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you how to prevent changes to your Data Validation in Excel whether by Typing or even by Copying and Pasting… No one will be able to copy and Paste in the cells having Drop Lists But Pasting outside the Data Validation works as usual.
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca Or www.OfficeInstructor.com
You get lots of FREE benefits when you become a member (Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Prevent Any unwanted Changes to our Drop Lists -
Create A Signature...Reuse It with A Click - Word In a Capsule (Episode 15)
This is a Bite-Size Word Tutorial targeting anyone on the globe using MS Word, since I broke the barrier of language and I explain the topic fully in graphics.
It is very easy to insert a multiple line formatted Signature in Outlook or any other email application. But how can we do that in MS Word.
In this tutorial I show you how to save any block of information, or formatted text with graphics, tables or charts and save them in Word. Then, Re-use them over and over again with a single click. You can save anything and any amount of text you want. This functionality saves a lot of time and very useful when building a Resume and customizing different blocks to suit the position to which you apply.
You can read the Steps for the activities I show in my tutorials by going to my Blog site: www.See-How.ca
You get lots of FREE benefits when you become a member (Totally Free): www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Create Reusable Building Blocks in MS Word. -
Picture Inside Text… Impress Your Clients PowerPoint In A Capsule Episode 16
First impressions are the most lasting… Yes, create a stunning Title for your Presentations or Reports. Using different Font types is not enough and does not do the job. It’s easy in Photoshop to insert a picture inside Text… But, is this functionality available in PowerPoint?
In this tutorial, I show you how I put a Picture Inside the Text and take my text to a whole different horizon. To make it more impressive, I change my text to a 3 dimensional text. Always select a Picture that matches the text from the perspective of colors and details. Your beautiful text can then be copied to other applications.
This is a Bite-Size Word Tutorial targeting anyone on the globe using MS PPT, since I broke the barrier of language and I explain the topic fully in graphics.
You can read the Steps for the activities I show in my tutorials by going to my Blog site: www.See-How.ca
You get lots of FREE benefits when you become a member (Totally Free): www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Put any Picture INSIDE Your Text in PowerPoint. -
Rename Sheets On The Fly With A Drop List- Just Amazing!! Excel In A Capsule (Episode 17)
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you how to Rename worksheets by selecting an option from a Drop List. Extremely useful and super simple to create.
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca Or www.OfficeInstructor.com
You get lots of FREE benefits when you become a member (Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To switch Worksheet Name on The Fly with a Drop List. -
Smart Data Cleansing... Functions Or Power Query Excel In a Capsule (Episode 18)
In this tutorial I show you how to Clean an improper data set by using a bunch of functions then I start over again, by using Power Query.
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca Or www.OfficeInstructor.com
You get lots of FREE benefits when you become a member (and it’s Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore different methods to clean up data in Excel. -
Sorry ...It is Case Sensitive - Custom Data Validation In Excel
In this tutorial I show you how to allow Case Sensitive Data Entry in any range in Excel. You can set the range to accept ONLY UPPER case, LOWER case or Proper case.
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
You can read the Steps for the activities I show in my tutorials by going to my Blog site www.See-How.ca Or www.OfficeInstructor.com
You get lots of FREE benefits when you become a member (and it’s Totally Free).
www.OfficeInstructor.com
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore different methods to create Custom Data Validation for Text entry in Excel. -
Randomizing Items in Excel Drop Lists With Every Selection
How can I randomize the options in a data validation drop list, in a way that the sorting order changes with every use? This is what I teach you in this graphic tutorial. I will be using 2 different methods to do that.
This functionality is extremely useful when creating quizzes or surveys or when collecting clients feedback.
This is a Bite-Size Excel Tutorial Series targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics.
Your comments are important for this series to grow.
For the benefit to spread, Share it with your friends and colleagues.
Don’t forget to subscribe to be notified when new tutorials are released, the best is Yet to Come. -
The New STOCKHISTORY Function...Just Released
This is a First Look at the new Excel Function 'STOCKHISTORY" released few hours ago.
It returns an array of historical quote data for a symbol (Mutual Funds, Exchange Rate, Stock ) and a Date Range you specify.
Let's have a quick look at this beautiful function.