Contents | Terminology, Open/Save/Delete/Rename, Navigating Excel, Inputting Data, Formatting, Sorting, Filtering, Basic Math Functions, Printing | Conditional Formatting, PivotTables, Charts, Subtotal and Group Data, Removed Duplicates, CONCATENATE, IF, COUNTIFS, SUMIFS, TEXT, Limit Inputs into Cells, Lock Cells, Hide Worksheet, Two-Variable Analysis Grid | How Formulas and Functions Work, Where To Find Functions, Best Practices, Copying Formulas, Combining Functions, Troubleshooting, and 50 Functions including SUM, AVERAGE, IF, TRIM, CONCATENATE, VLOOKUP, RANDBETWEEN, MIN, ROUND, and MAX | How Formulas and Functions Work, Where To Find Functions, Best Practices, Copying Formulas, Combining Functions, Troubleshooting, and 50 Functions including TRANSPOSE, INDEX, MATCH, TRUNC, LN, FACT, COMBIN, NETWORKDAYS, and How Excel Handles Dates | Tips and tricks for making it easier to work in Excel, including freeze panes, print titles, and more |
---|
Available Formats | Ebook, Paperback, and Case Laminate Hard Cover | Ebook, Paperback, and Case Laminate Hard Cover | Ebook, Paperback, and Case Laminate Hard Cover | Ebook, Paperback, and Case Laminate Hard Cover | Ebook and Paperback |
---|