September 2016 - Page 13 of 13 - AdvantEdge Training & Consulting

Excel

Excel

## Scientific notation in Excel

Excel automatically converts numbers with 15 or more digits into scientific notation. In fact, when it simplifies the number it loses the rounded digits. They aren’t recoverable.As long as you don’t use numbers larger than a quadrillion, this isn’t a problem, but if you are using very long serial numbers or you really are calculating the distance to the sun in millimeters (roughly 149 quadrillion), then the full number format is better. Turning off Scientific notation in Excel Before typing your large number into the cell, change the cell format to Number from the drop down in the Number group of the Home tab. By default, Excel cells are General, which rounds numbers with more than 15 decimal places to scientific format. Number format doesn’t round it unless you tell it to.Change the format of the cell before typing your number. Rounded digits are unrecoverable. Turning on Scientific notation in Excel If you want scientific notation, then right click on the cell containing your number and choose Format Cells. Then, choose Scientific on the left and your desired number of decimal places.    For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Excel

## Excel Countdown formula

How many days until the end of the year? How many days until the big meeting? Use this simple Excel countdown formula to find out.The DATEVALUE formula converts a date into a number in Microsoft Excel date-time code. This allows you to do simple math with days and time and create an Excel countdown formula.=DATEVALUE(“31-March-2012″)-TODAY()&” days until final numbers are due”The red section of the code does the math needed, and the blue section of the code adds “Days until Final numbers are due” to the cell. I included this to force Excel to use a number instead of printing the results in Date Time Format.If you don’t want a simple number instead, remove the blue section of the code. Then change the number format under the Home tab to “Number”.There are a few other applications for this beyond a simple Excel countdown formula too.     For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Excel

Excel

## Excel Video: Sorting by Multiple Columns

If you have a large spreadsheet of information, you may often want to sort the information by more than one column. For example, what if you want to sort by date, but then sort by name within those dates?

Excel

## Print Gridlines in Excel

Gridlines are the very lightly colored lines that surround each cell in a Microsoft Excel spreadsheet. Be default, they won’t print. Printing them is fairly easy though. To make Excel gridlines print Open your spreadsheet and click on the Page Layout tab. In the Sheet Options group, check the box for Print under Gridlines. To stop Excel gridlines from printing Open your spreadsheet and click on the Page Layout tab. Uncheck the box for Print under Gridlines in the Sheet Options group.Note, gridlines will only print in around cells with content. If you want to print blank cells with gridlines, select the area you want to print then click on Print Area in Page Setup and choose Set Print Area.   For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Excel

## Disappearing Excel Gridlines

My Microsoft Excel Gridlines are no longer visible in the program. How do I get them back?There are 4 possible reasons that gridlines are no longer visible in Microsoft Excel. Reason for hidden Gridlines 1: They are turned off. Click on the View tab, then check the box for Gridlines in the Show group. Reason for hidden Gridlines 2: They are colored over. If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Select the cells that are missing the gridlines, or hit Control + A to select the entire workbook. Then, under the Home tab in the Font group change the color of the cells by clicking on the can of spilling paint and choosing no fill. Reason for hidden gridlines 3: The borders are colored white. Select the effected cells, or select everything with Control + A, then right click on the cells and choose Format Cells. Under the border tab, change the Color to Automatic. Reason for hidden gridlines 4: The gridlines have been colored white Click on the File tab. Then choose Options and Advanced. Scroll down to the Display options for this Worksheet section, and change the Gridline color to Black. Click OK.  For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Excel

## Excel: Setting Page Breaks for Printing

Do you have a long spreadsheet that you need to print? Do you want to control which rows and columns are printed on which pages? You can use the page break settings to ensure it prints correctly.

Excel

Excel

## Filter Excel Tables from Table Headings

When your data has been entered into Excel, you can use the built-in Filter tool on the Data Tab to narrow down what you are viewing based on criteria you set:On the Data tab, click the Filter button. (It’s a toggle button meaning: “one click on, one click off”) Click the arrow next to the column heading. You can pick the criteria to filter by, and narrow those results even further using the category filters, i.e., the date choices shown in the example.  Upgrade your Excel skills with training from AETC

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us