Posts

microsoft office excel word power-point
, , ,

What is Page Layout in Microsoft Office Excel

Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including the page orientation and margin…
microsoft office excel word power-point
, , ,

Tips for printing spreadsheets in Office Excel

So you've made an Excel workbook full of data. It's well organized, it's up to date, and you've formatted it exactly like you want, so you decide to print out a hard copy … and it looks like a mess.Excel worksheets don't always look great…
microsoft office excel word power-point
, ,

Complete List of Office Excel Functions

A function in Microsoft Office Excel is a predefined formula that performs calculations using specific values in a particular order. One of the key benefits of functions is that they can save you time since you do not have to write the formula…
microsoft office excel word power-point
, , ,

How To: Sort Data in a Range or Table in Microsoft Office Excel

Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons. Sorting data helps you quickly…
microsoft office excel word power-point
, , ,

How To: Remove a Filter in Data in Microsoft Office Excel

If you can’t find the data you’re looking for in a worksheet, it might be hidden by a filter. For example, if you have a column of dates in your worksheet, it might be filtered to show only certain months. You can remove a filter from a…
Microsoft Office - kamiltech
, , ,

How To: Filter Range of Data in Microsoft Office Excel

Built-in comparison operators such as “greater than” and “top 10” can show the data you want and hide the rest. That’s a big help with large worksheets or when you just want to focus on particular data ranges.Select the data you…
microsoft office excel word power-point
, , ,

How To: Filter Data in Microsoft Office Excel

When you put your data in a table, filtering controls are added to the table headers automatically.For quick filtering, do this:Click the arrow in the table header of the column you want to filter. In the list of text or numbers, uncheck…
Microsoft Office - kamiltech
, , ,

How To: Protect a Worksheet in Microsoft Office Excel

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet,…
Google Chrome
,

List of secret Google Chrome URLs & their Purpose

Google Chrome has a large list of internal URLs that you can access to know more about your web browser and tweak it. You can access the complete list by entering “chrome://chrome-urls” in your browser address bar. Ranging from downloads…
microsoft office excel word power-point
, , ,

How To: Add Pop-up Tool-tip to a Cell in Microsoft Excel

Want a neat trick you can use to make your worksheets more helpful to users? How about adding a pop-up window that displays documentation whenever the cell is selected? To add such a feature, follow these steps:Select the cell for which…