Formation Excel Intermediate

Excel keyboard shortcuts II : ALT key shortcuts

• Use the ALT key to access any button or command on the ribbon
• Use old ALT key shortcuts that worked in older versions of Excel
• Use ALT key shortcuts in dialog boxes
• Use other kinds of access keys, like F6

The IF function : what it is, and how to use it

• Use the IF function
• Use more than one IF function in a formula

Plan payments and savings in Excel

• Figure out the monthly payments to pay off a credit card debt
• Figure out monthly mortgage payments
• Find out how much to save each month for a dream vacation
• Find out long it will take to pay off a personal loan
• Figure out a down payment
• See how much your savings will add up to over time

Understand data at a glance with conditional formatting

• Make data stand out by applying conditional formatting to cells
• Decide which type of conditional formatting to apply
• Clear conditional formatting from cells
• Make your own conditional formatting rules

Sparklines: Use tiny charts to show data trends

• Add sparklines to spreadsheet cells
• Determine which kind of sparkline to use
• Change sparkline styles
• Clear sparklines from spreadsheet cells