logo

Excel tips 2013 year overview

E-Book, Excel 2007 NL tips

A full year of helpful tips & tricks from Easy Learning and Easy Template. For a limited time, the most popular Excel tips from 2013 are available in a yearly overview.

NOTE:
This download is only available for a limited time until 30-06-2016!

Happy with this free download? Share it with your friends and colleagues.

Protect Excel from changes

Topics:

Basic Worksheet Operations

  • Copying and moving worksheets
  • Hiding columns
  • Transposing data

Protecting Excel

  • General protection
  • Protecting a worksheet in Excel
  • Protecting a workbook in Excel

View Options

  • Custom views
  • Display subtotals in a list

Cell Formatting

  • Progress bar cell formatting

Work Faster in Excel

  • Introduction to working faster in Excel
  • Set default number of worksheets
  • Set input direction in Excel

Formulas in Excel – Part 1

  • Basic formulas in Excel
  • Operators in Excel
  • Add two cells
  • Add more than two cells
  • Subtract two cells
  • Divide cells
  • Multiply cells
  • Multiple calculations in one formula
  • Calculations across worksheets
  • SUM: Add ranges
  • AVERAGE: Calculate average of range
  • MAX: Find highest value
  • MIN: Find lowest value

Formulas in Excel – Part 2

  • SUMIF: Add with condition
  • COUNTIF: Count with condition
  • ROUND: Round numbers
  • Fixed value from another worksheet
  • Create a dropdown list in Excel
  • VLOOKUP function in Excel
  • VLOOKUP with absolute reference
  • Display date and time
  • Display day from a date

Download the E-Book Excel 2007 NL

Download Page