Spelling and Thesaurus

Spelling and Thesaurus, can't live without it...

For Spelling:

Thesaurus is a little easier...

Replacing Data

This is for those who don't want to type the same word for over 1,000,000 rows and I wouldn't call that "laziness"...

This is very similar to using "Find" function:

Finding Data

This is for those who do not like to look at the "whole" spreadsheet...over 1,000,000 rows of data...

 

Automatically Filling Data

This is for those don't want to type (aka. laziness)...

Manually Entering Data

This is the most easy one...

Don't say I haven't told you so.

Moving Columns & Rows

This function is very common when needing to re-arrange, eg. alphabetically...

First, here's how to move columns around...

 

Here's for the row...

 

Moving Tabs

Here's how to move the tabs around...

 

Easy right?

Moving Data to Another Cell

When we find out that we put the data in the wrong cell (duh!), instead of copy and paste there are better ways...

And Voila!

Saving under Different Name and Format

After saving a file, some might want to save again under a different name or a different format due to different reasons....

Save in a different name:

And saving in different file format:

Looking at Properties

There are times when you want to know other things besides the content in the spreadsheet, ie. who created the file and when was it created?

So here it is...

For the security conscious type...

Saving File

Here's how to save a file...

And the more straight forward one...

Creating a New File

How to create a brand new file...

 

And easy as pie...

Interface....the Ribbon

The most important part of the Interface is the Ribbon which is located at the top of the screen.

 

The Ribbon is separated into two Left Ribbon and Right Ribbon.

As you have probably guess, the entire Ribbon is to make spreadsheet more usable, where you can change the format, changing font size, add new rows and replacement certain data.

Introduction

Purpose of this blog is to let you learn Excel an easier way to learn Microsoft Excel. This course is not a replacement of reading an over three hundred pages book, spending hours watching YouTube or spending hundreds on a course. This blog is rather just to clarify some of the things that sometimes people find confusing in other methods of learning. I hope you will find this blog useful and have better understanding of how to use the program. Enjoy!

Anna

PS. If you have any that you would like to see on my blog, please post your comment below. Thanks!

PPS. I know this is just another website for Excel but I still feel very loved if you bookmark my blog. :)