30 Excel tips you need to know

Microsoft Excel was first released in 1985, and the spreadsheet program has remained popular through the years. Whether you are a Microsoft Excel beginner or an advanced user, you’ll benefit from the step-by-step tutorials presented in this ebook from TechRepublic Premium.

In the ebook:

  • How to add a drop down list to an Excel cell
  • How to add a condition to a drop down list in Excel
  • How to add color to a drop down list in Excel
  • How to split a column using an IF() function in Excel
  • How to easily print Excel sheets in black and white
  • How to use Excel styles efficiently
  • How to use the selected value in a combo to determine conditional formatting in Excel
  • How to display the top n records in an Excel Pivot-Table using built-in options
  • How to avoid a conditional formatting rule in Excel that doesn’t work as expected
  • How to expose expressions that return a defined error value in Microsoft Excel
  • How to highlight the top n values in a Microsoft Excel sheet
  • How to average unique values in Excel the easy way
  • How to combine Excel’s VLOOKUP() function with a combo box for enhanced searching
  • 3 quick and easy ways to summarize Excel data
  • How to use the new Excel Lookup function
  • How to change an Excel conditional format on the fly
  • How to password protect an Excel workbook
  • Entering leading zeroes in Excel
  • Use Excel to calculate the hours worked for any shift
  • Copy an Excel sheet from one workbook to another
  • Use a custom format in Excel to display easier to read millions
  • How to suppress 0 values in an Excel chart
  • How to find duplicates in Excel
  • How to use named ranges to quickly navigate an Excel workbook
  • How to use Excel’s border options by creating a simple floor plan
  • A quick way to delete blank rows in Excel
  • 3 ways to reconcile transactions using Excel 2016
  • How to apply Insights in Excel and what to look out for when you do
  • How to create an Excel drop down list from another tab
  • How to count individual cells within a row by their fill color in Excel
  • And much more!

Resource Details

or

* Sign up for a TechRepublic Premium subscription for $299.99/year, and download this content as well as any other content in our library. Cancel anytime. Details here.

Provided by:
TechRepublic Premium
Published:
September 17, 2020
Topic:
TechRepublic Premium
Format:
PDF
or

* Sign up for a TechRepublic Premium subscription for $299.99/year, and download this content as well as any other content in our library. Cancel anytime. Details here.