excel office 2019 Tags- TipsMake

Excel 2019 (Part 28): What-if Analysis

excel includes powerful tools for performing complex mathematical calculations, including what-if analysis.

Excel 2019 (Part 26): Introducing PivotTables

pivottables can help make your spreadsheets more manageable by summarizing data and allowing you to manipulate it in different ways.

Excel 2019 (Part 24): Comments and Co-authors

excel offers two powerful features that allow you to work with others on the same spreadsheet: commenting and co-authoring.

Excel 2019 (Part 23): Conditional Formatting

similar to charts, conditional formatting provides a way to visualize data and make spreadsheets easier to understand.

Excel 2019 (Part 22): Charts

it can be a bit overwhelming when an excel workbook contains a lot of data. charts allow you to visualize workbook data graphically, making it easier to understand comparisons and trends.

Excel 2019 (Part 20): Grouping and Subsummary

excel can organize data into groups, allowing you to easily show and hide different parts of a spreadsheet.

Excel 2019 (Part 19): Filtering Data

filters can be used to narrow down the data in a spreadsheet, allowing you to view only the information you need.

Excel 2019 (Part 18): Sorting Data

you can quickly reorganize your spreadsheet by sorting your data.

Excel 2019 (Part 17): Fixing Rows/Columns and Viewing Options

excel includes several tools that make it easy to view content from different parts of a workbook simultaneously, including the ability to freeze rows/columns and split the worksheet.

Excel 2019 (Part 15): Functions

excel includes many common functions that can be used to quickly find the sum, average, count, maximum, and minimum values for a range of cells.

Excel 2019 (Part 14): Relative and Absolute Cell References

there are two types of cell references: relative and absolute. relative and absolute references behave differently when copied and filled into other cells.

Excel 2019 (Part 13): Creating Complex Formulas

when there is more than one operation in a formula, the order of the operations tells excel which calculation should be performed first.