Excel Introduction for UoB Students
1
Introduction
2
Getting Access to Excel
2.1
Installing Microsoft Excel
2.2
Windows Virtual Desktop
2.3
Microsoft Excel in the cloud
3
Getting Started with Microsoft Excel
3.1
Finding our way in Excel
3.2
Using Microsoft as a calculator
3.3
Sorting data
3.4
Referencing across cells
3.5
Copy-pasting
4
Creating Charts in Microsoft Excel
4.1
Our first line chart
4.2
A bar chart
4.3
An area chart
4.4
A stacked area chart
4.5
An unstacked area chart with two series
4.6
A scatter plot
4.7
A pyramid chart
4.8
Polishing the chart
4.9
Combing chart types
5
Designing Tables in Microsoft Excel
5.1
Basic cell formatting
5.2
Merging and wrapping cells
5.3
The format painter
6
Error Messages & Warnings
6.1
Leaving out adjacent cells
6.2
Inconsistent formulas
6.3
###
6.4
#REF!
6.5
Circular formulas
7
Handling large datasets
7.1
Filtering tables
7.2
Pivot tables
7.3
Text to columns
8
Getting tables and charts into Word
8.1
Inserting a chart in Microsoft Word
8.2
Inserting a table in Microsoft Word
9
Further resources
Published with bookdown
Excel for UoB students
8
Getting tables and charts into Word
8.1
Inserting a chart in Microsoft Word
8.2
Inserting a table in Microsoft Word
