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!