Excel Tutorial
What is Microsoft Excel?
Excel is a powerful tool for analysing and gaining insights from data.
How can I get started with Excel?
You can either navigate to Excel Online in your web browser or install Excel
on your desktop by purchasing Microsoft 365.
What does the Excel interface consist of?
The Excel interface consists of cells, columns, and rows. The intersection of a
column and row is called a cell.
How do I enter data in Excel?
To enter data, click on the desired cell and start typing. You can also
navigate between cells using the mouse or keyboard shortcuts.
How can I format cells in Excel?
You can format cells to improve readability. For example, you can add a
thousand separator or remove decimal places. You can also access the
'Format Cells' dialogue for full control over cell formatting.
How can I add notes to my data in Excel?
You can add notes by clicking on a cell and entering the desired information.
You can adjust column width or hide columns if necessary.
Can I rearrange columns in Excel?
Yes, Excel allows you to easily rearrange columns. Select the data and use
the shift key to move the column to a new position.
What is a pivot table?
A pivot table is a feature in Excel that allows you to analyze and summarize
data from a larger dataset by rearranging and manipulating it.
How do I access a pivot table in Excel?
To access a pivot table in Excel, click into the worksheet where the data is
located, then navigate to the 'Insert' tab and click on 'PivotTable'.
What can I do with a pivot table?
With a pivot table, you can calculate values, such as sums or averages,
based on the data in your dataset. You can also filter and rearrange the data
to visualize it in different ways.
How do I calculate different values in a pivot table?
To calculate different values in a pivot table, right click on a cell containing a
value and go to 'Summarize Values By'. From there, you can choose different
calculations such as sum, average, count, etc.
Can I filter data in a pivot table?
Yes, you can filter data in a pivot table. You can drag and drop a column into
the 'Filters' section of the pivot table and then select specific filters, such as
filtering data for a particular month or year.
What is Microsoft Excel?
Excel is a powerful tool for analysing and gaining insights from data.
How can I get started with Excel?
You can either navigate to Excel Online in your web browser or install Excel
on your desktop by purchasing Microsoft 365.
What does the Excel interface consist of?
The Excel interface consists of cells, columns, and rows. The intersection of a
column and row is called a cell.
How do I enter data in Excel?
To enter data, click on the desired cell and start typing. You can also
navigate between cells using the mouse or keyboard shortcuts.
How can I format cells in Excel?
You can format cells to improve readability. For example, you can add a
thousand separator or remove decimal places. You can also access the
'Format Cells' dialogue for full control over cell formatting.
How can I add notes to my data in Excel?
You can add notes by clicking on a cell and entering the desired information.
You can adjust column width or hide columns if necessary.
Can I rearrange columns in Excel?
Yes, Excel allows you to easily rearrange columns. Select the data and use
the shift key to move the column to a new position.
What is a pivot table?
A pivot table is a feature in Excel that allows you to analyze and summarize
data from a larger dataset by rearranging and manipulating it.
How do I access a pivot table in Excel?
To access a pivot table in Excel, click into the worksheet where the data is
located, then navigate to the 'Insert' tab and click on 'PivotTable'.
What can I do with a pivot table?
With a pivot table, you can calculate values, such as sums or averages,
based on the data in your dataset. You can also filter and rearrange the data
to visualize it in different ways.
How do I calculate different values in a pivot table?
To calculate different values in a pivot table, right click on a cell containing a
value and go to 'Summarize Values By'. From there, you can choose different
calculations such as sum, average, count, etc.
Can I filter data in a pivot table?
Yes, you can filter data in a pivot table. You can drag and drop a column into
the 'Filters' section of the pivot table and then select specific filters, such as
filtering data for a particular month or year.
