Showing all 40 results
-
Topic:
0 - Total Time: 0
-
Price:
$$0.00 - Application
- Class Topic
- Time
- Price
-
Absolute Reference is when you anchor a particular cell(s) in your formula. When you copy an absolute reference to another location, Excel does not change the absolute cell reference. However, the reference will change when it is a Relative Cell Reference.
-
View several Excel files at one time side by side
-
This autofill feature allows you enter a series of numbers or characters in a specified range, and have Excel complete the entry you started typing. You can have Excel automatically prefill cells with months, days of the week, quarters, dates, number sequencing and a custom list you create.
-
The Autofilter allows you to find, show or hide specific data faster within a database. You can filter data based on two or more criteria by using Excel’s advanced filtering features. Excel provides the Custom AutoFilter and Advanced Filter tools for specifying multiple filtering criteria. Filtering refers to displaying only the information that meets specific criteria.
-
Excel’s AutoSum feature automatically assists you in adding up column and/or rows of numbers using the SUM function.
-
The AVERAGE function calculates the arithmetic mean of a list of values. You can use the COUNT function to determine how many cells in a range contain numeric values. The MAX function returns the largest number in a list of values. The MIN function returns the smallest number from a list of values.
-
You can apply various formats, such as borders and alignment, to customize the appearance of one or more cells in a row or column. You can also adjust the cell height and width. Doing so affects an entire row or column—you cannot change the height or width of an individual cell.
-
Charts are graphic representations of data. You can create charts based on the data in a worksheet. A chart can be an object embedded in a worksheet or placed on a separate chart sheet tab in a workbook.
-
This function allows you to join data found within several different cells into one cell. For example, if the first and last name of an employee is found in two different cells, this function can join the names into one cell.
-
Conditional formatting allows you to quickly highlight important information in a spreadsheet based on your particular criteria. This feature allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. It can also help you represent data in graphical form based on defined values you specify. You can create data bars and icon sets to depict values or divide them into categories. In addition, you can use data bars and icon sets to compare column values to one another. You can also use color scales to format cells differently depending on their values. To boost the performance of the Conditional Formats, you can create your own formula within the Conditional Formatting Rule feature.
-
“Cut” will remove a selection of data and give you the possiblity to paste it elsewhere in your spreadsheet. It’s basically a move command. “Copy” will duplicate a selected range of data. “Paste” will place any selected data that is copied or cut into the current selected cell. There are multiple ways to execute these commands.
-
A data table is a range that displays the results of changing certain values in one or more formulas. The different values you want to enter in a formula are also included in the data table. A data table can have either a single variable or two variables.
-
Data validation rules control what type of data an end user can enter into selected cells. Such valid data can be of a specific text length, particular dates, or whole numbers. You can also create your own drop down list of choices. This feature helps maintain the integrity of the data populating your database.
-
Using the Remove Duplicates dialog box, you can remove duplicate records in your database based on values in one or more fields.
-
You can change the format of all the text in an active cell or only a selected portion of it. You can also select multiple cells and apply formatting to all of the cells at once. The selected cells can be continguous or non continguous.
-
There are a variety of ways to format the display of a date. Excel has some predefined date formats or you can create your own custom format.
-
You can use the Freeze Panes command to “freeze” (lock) rows and/or columns in place so that headings remain visible at the top of your report as you scroll down your spreadsheet.
-
A header and/or footer can be placed on each page and can provide important information about a worksheet, such as the current date, page number, author, workbook or worksheet name, company logo, or combinations of these and other options.
-
Use the IF logical function to test your data and calculate a value or display a word or phrase based on whether the logical test is true or false. You can use the IF function along with the AND and OR functions.
-
Use the IFERROR function to replace errors generated by non-functioning formulas and functions.
-
Review the settings in Excel’s backstage view, customize the ribbon and Quick Access Toolbar.
-
You can link multiple worksheets within a workbook and you can link multiple workbooks. You can do this by writing a formula in one workbook that refers to a cell, range, or name in another worksheet tab or workbook file. The benefit of this is if the data changes in one location, all linked cells will automatically update accordingly.
-
You can use macros to automate complex and repetitive tasks. A macro is a series of instructions that execute automatically with a single command. You can use the macros already available in Excel or create your own.
-
Numbers, including date and time data, can be displayed in many different formats. Dollar signs ($), percent signs (%), and decimal places are examples of number formatting. By using number formats, you can make your worksheets easier to understand and call attention to specific data.
-
You can organize and summarize data in a worksheet by creating an outline, which groups data by levels. Each level contains a section of the data that you can expand or collapse. You can also consolidate data from different worksheets to summarize the data.
-
The Page Layout tab and its options allow you to customize the layout of the spreadsheet for printing purposes. By using the Print Titles feature, you can ensure that your column headings print at the top of each page.
-
By using the Payment function, you can determine what the monthly payments will be on a loan for a specific interest rate.
-
A PivotTable is an interactive table that summarizes, organizes, and compares large amounts of data in a worksheet. You can rotate the rows and columns in a PivotTable to obtain different views of the same data. You can use a PivotTable to analyze data in an Excel workbook or data from an external database
-
You can use the Print titles section to define row or columns that should be repeated on every page of the printout. You can specify the order in which Excel prints sections of the worksheet, and select other print options for the current worksheet.
-
When you’re satisfied with your worksheet and you have prepared it for printing, it’s easy to print it. On the Print page, you can select the printer you want to use (if more than one printer is available), and apply other settings such as page orientation, margins, and scaling. You can also choose to print the active sheet, the entire workbook, or the current selection.
-
By protecting a worksheet, you can prevent unauthorized users from modifying it. You can protect an entire worksheet or protect only a part of it, permitting users to alter the other parts. You can also protect workbooks by using passwords and digital signatures.
-
Assign an arbitrary name to a cell or a group of cells that can be used to navigate within your workbook, in formulas or for printing purposes. Range Names are interchangable with Absolute Cell References.
-
Insert, delete, move, copy, hide, rename, recolor and navigate amongst the sheet tabs using your mouse click or keyboard shortcuts. For efficiency sake, you can also make edits to multiple sheets tabs at one time.
-
You can organize your worksheet data in a concise and logical format by sorting the data in ascending or descending order. You can also create custom sorts where you can sort based on cell color, font color, the months of the year or based on a custom list.
-
The Subtotal feature is a built in feature in Excel that allows you to summarize your data into like categories. Excel will automatically insert a new total row after each category. You will have the option to display a Grand Total row at the end of your database and collapse and expand the displaying of the details for each category. This function, depending on the arguments, can act like SUM, AVERAGE, COUNT or other functions.
-
You use the SUMIF function when you want to add values within a range of cells based on the evaluation of a “single” criteria.
-
You use the SUMIFS function when you want to add values within a range of cells based on the evaluation of “multiple” criterion.
-
Converting a traditional Excel list (range of cells) into an Excel Table, will enable managing and analyzing data easier. The data will be displayed in banded row format (every other row is highlighted with a background color). There are quite a few great time-saving bells and whistles with this feature.
-
You can separate information found in a cell into several cells, for example, if a column contains both first and last names, this feature will separate the names into two separate columns.
-
When you want to look up information in a large database, the VLOOKUP function searches for the lookup value (which resides in the first column of the lookup table) and returns the requested information. For example, you can search for an employee’s name or social security number based on his employee ID. This lesson will also include a mini tutorial regarding Range Names.
