Mastering Excel Quiz
Mastering Excel Power Query Pdf

TOP REVIEWS FROM MASTERING DATA ANALYSIS IN EXCEL. By JE Oct 30, 2015. The course deserves a 5-star rating because: (1) content is relevant, (2) the professor is concise and possesses great teaching skills, and (3) the learning modules are applicable to daily problems. By MC Feb 27, 2016. Highly useful and practical course. It can be a bit. V694200109 Mastering Excel® Functions and Formulas 05 How to Write Formulas With Relative and Absolute Cell References The heartbeat of Microsoft Excel® is the formula. A formula calculates values based upon parameters. By default, Excel® will recalculate formulas as soon as you complete them and press ENTER. And since nobody ever said Excel was easy, we’ve collected our favorite strategies for improved performance. 1.) Navigate Excel like a pro. Sure, a mouse and a trackpad are standard fixtures on most modern desks. But if you want to really supercharge your use of Microsoft Excel, learn keyboard shortcuts. There are two kinds of people: Those who are masters at Excel, and those who wish they were When you master Excel, you have one of the most practical and valuable skillsets in modern business.

Microsoft Excel is very popular and best application for managing, organizing and arranging crucial data.

This application is used in countless ways and this is the reason numbers of features are packed inside this Microsoft’s popular application.

This doesn’t matter whether you are a casual user or an Excel expert, it is important to know everything in it so that you can easily use this complex application.

Here in this article, we are describing – easy tips n tricks that will make you master Microsoft Excel:

Included Excel Tips and Tricks:

Click once to Select All	Open Multiple Excel Files at Once
Create a New Shortcut Menu	Add More Than One New Row or Column
Apply Diagonal Borders	Turn Columns into Rows
Hide Individual Cells	Freeze Row and Column Headings
Quickly Move and Copy Data in Cells	Delete Blank Cells Fast
Use Flash Fill to Save Time	Add Comments to your Formulas
Quickly Add Up Figures	Rotate Heading Text
Add Decimal Points Automatically	Add Your Own Graphics to Charts
Save Charts As Templates	Add the Calculator (or else) to Quick Access
Apply Some Conditional Formatting	You can Draw Equations
Fast Navigation with Ctrl + Arrow Button	Input Values Starting with 0
Rename Sheet Using Double Click	Compose Text with &
Transform the Case of Text	Speed up Entering Complicated Terms with AutoCorrect
Generate a Unique Value in a Column	Input Restriction with Data Validation Function
Bring Selection into View	Learn Excel’s Best Shortcut Keys

Mastering Excel Quiz

Tips and Tricks to Master Microsoft Excel

1. Click once to Select All

Many of us know that we can select the entire excel sheet by using the Ctrl + A shortcut but I guess few of us know that simply clicking once on the corner button will select the entire data in less than a second.

2. Open Multiple Excel Files at Once

While working on multiple excel files, you need to open files one by one, this is quite difficult to handle but here we will describe a handy way to open them all with one click.

All you need to do is to select the files you like to open and press Enter key, all selected files will open altogether.

3. Create a New Shortcut Menu

Using shortcuts makes the work easy. In Excel we are having three shortcuts in the top menu – Save, Undo Typing and Repeat Typing.

But if you want to utilize more shortcuts like Copy and Cut, you can set them up:

Here know how:

Go to File > Options > Quick Access Toolbar > Add Cut and Copy from the left column to the right and save it.

Now you can see two more shortcuts added to the top menu and make the work easy for you.

This is really very helpful to organize the Excel crucial data easily and become an Excel expert.

Know More MS Excel TRICKS.

4. Add More Than One New Row or Column

Well, I think most of the Excel user must know that by selecting a row or column we can add a new one via Insertdrop-down under Home.

However, here is an easy way to do so.

Drag and select rows or columns > right click the highlighted rows or columns > select Insert from the drop down menu.

Now new rows will be inserted above the row or to the left of the column you first selected.

Mastering Excel Power Query Pdf

NEXT…

5. Apply Diagonal Borders

If you got a table that requires both row and columns headers in the same cell then make use of the diagonal borders.

Click More Borders at the bottom of the borders drop-down menu (on the Home tab of the ribbon) and diagonal buttons are by the box corners.

Click it and save.

This makes the work easily understandable and presentable in your excel sheet.

Additional Reading:

6. Turn Columns into Rows

If you have data in columns that should be in rows or the other way then here we have tips to do so without losing anything.

Just, copy the original block of the cell > right click on the destination cell > click Paste Special > Transpose.

7. Hide Individual Cells

Excel has a master trick of hiding cells. This is one of the best Excel tips and tricks

All you need to do is to select the cell that you want to hide and right click >select Format Cells and then set the format as Custom under the Number tab and Enter;;; (three semicolons) as the format.

Now the cell content disappears but they are still present there and can be used in formulas.

This is really amazing Excel tips and tricks

8) Freeze Row and Column Headings

This is the simple but useful trick to becoming an Excel expert.

Freeze the row and column headings so they are always viewable when you scroll around.

To do so, LOOK

Place the cursor in the top-left cell where the actual data starts and go to VIEW menu and simply select Freeze Panes and Freeze Panes.

Now the heading is viewable where ever you scroll.

9. Quickly Move and Copy Data in Cells

If you want to move one column of data in a spreadsheet then the easy and fast way is to select it and move the pointer to the border after it turns to a crossed arrow icon then drag to move the column freely.

But if you want to copy the data, .then press the Ctrl button before dragging to move the new column will copy all the selected data.

10. Delete Blank Cells Fast

Some of the default data will be blank for various reasons.

So if you need to delete these to maintain accuracy, particularly while calculating the average value.

The easy way is to filter out entire blank cells and delete them with one click.

Choose the column you wan