Microsoft Excel for Mac - Office 365 on Mac OS new 2024

In this Lecture we will look at opening Microsoft Excel for the first time.

In the first of our sections, we will look at the layout the Excel . We will take a tour of the Excel Program, highlighting all the main places of interest.

We will look at the most important parts of the program to make sure you can navigate it with ease.

In this section we will look at the different ways that we can create a spreadsheet, either from the default "blank" template, or from one of Microsoft pre prepared templates.

In this section we will look at the cells that make up an Excel Spreadsheet. We will look at the way we can manipulate cells.

We will look at the different types of information that we can enter into cells.

In this section we will look at the cells that make up an Excel Spreadsheet. We will look at the way we can manipulate cells.

We will look at selecting cells Columns and Rows.

In this section we will look at saving spreadsheets, we will look at the process of saving a spreadsheet in the default manor, and also saving spreadsheets in different file types.

We will also talk about the reasons for saving in different file types.

In this section we will look at searching spreadsheet files to find data and we will also look at replacing data with new content.

We will look at the ways that we can sort data in a spreadsheet. We will look at sorting lists and the different methods that we can use.

We will look at filtering data in a spreadsheet. We will look at the ways we can use filtering to get a better view of only the elements that you wish to see.

In this section we will look at cutting and copying content and pasting it into another area in the same spreadsheet or into a totally different spreadsheet.

In this section we will look at the way we can use different worksheets in the Microsoft Excel program. 

We will look at adding and deleting worksheets, Renaming worksheets. 

We will also have a look at moving and copying entire worksheets. 

We will also look at giving the worksheet tabs a colour, so that they can be quickly identified. 

in this section we will look at creating formulas using cell references and arithmetic operators (addition,subtraction, multiplication, division). 

We will look at the good practices that can be used in order to achieve the best results.

Choose the Correct option

In this section we will look at using the auto fill option in Excel, we will look at the situations that you will use it and the way it can be used. 

In this section we will look at some of the most common functions that can be used in spreadsheets. 

We will look at the SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and ROUND Functions. 

In this section we will look at the IF statement and the way it can be used to determine a true or false outcome. 

In this section we will look at the different types of formatting that we can apply to cells in our Microsoft Excel spreadsheet. 

We will look at formatting cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands. 

We will also look at formatting cells to display a date style, to display a currency symbol and to display numbers as percentages. 

In this section we will look at changing the cell content appearance like font sizes and font types. 

We will also look at applying formatting to cell contents like bold, italic, underline, double underline. 

We will apply different colours to cell content, cell background. 

We will look at copying the formatting from a cell and placing it on another cell so that we can keep formatting uniform. 

In this section we will cover charts, will look at creating a chart from spreadsheet data. We will create different types of charts like bar chart, column charts and pie charts. 

This section will cover adding, removing and editing a chart title. 

We will add data labels to a chart so that we can see exact values/numbers or percentages. 

We will look at changing the chart area background colour and also the colours that make up the "bars" in the charts and change the colour of text used within the chart. 

In this section we will look at the following: 

• Change worksheet margins: top, bottom, left, right.

• Change worksheet orientation: portrait, landscape. Change paper size.

• Adjust page setup to fit worksheet contents on a specified number of pages.

• Add, edit, delete text in headers, footers in a worksheet.

• Print Titles on each page

• Print Gridlines