Jan's Working with Numbers

    Format

Project Objectives

• Use Page Layout view
• Format text - font, font color, font size
• Merge and center cells; unmerge
• Copy formatting - Format Painter, AutoFill, Paste Special
• Format part of text in cell
• Apply a theme
• Format a selection as a table with a table style
• Clear all formatting
• Apply a different theme
• Modify a table - size, options
• Sort and filter in a table; custom filter
• Print a selection
• Convert table to range
• Open an existing workbook
• Create and apply a cell style
• Merge cell styles from another workbook.
• Wrap text in a cell
• Customize the ribbon
• Format a chart - chart type, data series, fill, labels, titles, legend
• Move and copy cells and sheets
• Use Paste Special, Paste Link
• Insert cell, row, column, sheet
• Edit multiple sheets at the same time
• Print in Landscape orientation
• Print entire workbook
• Know the meaning of error values