Embedded Files
Microsoft Excel
Microsoft Excel
How to utilise Microsoft Excel for a variety of situations to analyse and present data.
Creating a spreadsheet
Creating a spreadsheet
Formatting data
Formatting data
Creating a new workbook
Creating a new workbook
Adding worksheets
Adding worksheets
Amending worksheets
Amending worksheets
Printing documents
Printing documents
Autofill information
Autofill information
Drop down lists
Drop down lists
Adding rows/columns
Adding rows/columns
Selecting data
Selecting data
Locking rows/columns
Locking rows/columns
Hiding rows/columns
Hiding rows/columns
Creating dates
Creating dates
Moving/copying cells
Moving/copying cells
Amending column/row size
Amending column/row size
Find and replace data
Find and replace data
Merging cells
Merging cells
Adding data validation
Adding data validation
Importing and exporting files
Importing and exporting files
Formatting number
Formatting number
Conditional formatting
Conditional formatting
Cell alignment
Cell alignment
Cell formatting
Cell formatting
Copying formatting
Copying formatting
Adding watermarks
Adding watermarks
Formula overview
Formula overview
Creating tables
Creating tables
Sorting tables
Sorting tables
Filtering data
Filtering data
Totalling data
Totalling data
Adding secondary axis
Adding secondary axis
Identifying trends
Identifying trends
Instant charts and analysis
Instant charts and analysis
Page updated
Report abuse