Microsoft Office - kamiltech
, , ,

How To: Use HLOOKUP Function in Office Excel

HLOOKUP function in Excel is a sibling of VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called as Horizontal Lookup.HLOOKUP is a very useful function for creating horizontal lookups, but as most…
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 - kamiltech
, , ,

How To; Use VLOOKUP function in Office Excel

As September approaches, I can count on a series of spreadsheet questions. One popular Excel tutorial request is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product…
microsoft office excel word power-point
, , , ,

How To: Use Excel in 14 Simple Steps

Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I'd ever need to do manually can be done automatically. Need to merge two sheets with similar data? Excel can do it. Need to do simple…
microsoft office excel word power-point
, , ,

How To: Apply Conditional Formatting in Office Excel

By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance.This graphic shows temperature data with conditional formatting that uses a color scale to differentiate high, medium,…
Microsoft Office - kamiltech
, , ,

Conditional Formatting in Microsoft Office Excel : Complete Guide

Use a conditional format to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.Conditional formatting helps you visually answer specific questions about your data. You can apply conditional…
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…