Microsoft Excel for Mac - Office 365 on Mac OS
- 2 hours on-demand video
- 1 article
- 8 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- Use Microsoft Excel 2016 for Mac with confidence in an Office environment.
learn how to use the most common Excel formulas and functions to carry out day to day spreadsheet tasks.
Produce excel spreadsheets to the highest standard
- Use formulas and functions to carry out tasks
- Give them the tools to be able to tackle more complex formulas
- No Prior spreadsheet experience is needed to take the class.
- Students should have Microsoft Excel installed on their computer so that they can follow along with the lectures.
Microsoft Excel is one of the most popular computer applications in offices over the last 20 years. For years people have struggled with compatibility issues between Microsoft and Apple Mac OS. This is slowly changing, Microsoft Office 365 has brought the two operating systems closer, its now easier than ever to collaborate with other users, its easier than ever to create a file on a Window PC and edit it on your favourite MacBook.
Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about it than you actually do. This course is designed from the bottom up, focusing on the most important elements of Microsoft Excel to give you the skills and confidence to perform everyday spreadsheet tasks in the average office.
Have you used Excel before and now have moved over to Apple Mac OS, we will look at the main differences in the two versions and also show some useful tips so that you can become a competent Microsoft Excel user
- This course is designed for anybody who has no spreadsheet experience but wishes to become a competent Microsoft Excel user.
- This course can be used as a refresher course for users who have used Microsoft Excel on a Windows PC but are now using an Apple Mac
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 ways we can interact with rows and columns.
We will look at selecting rows and columns, both adjacent and non adjacent.
We will look at inserting and deleting rows and columns and modify the Heights of rows and the widths of columns.
We will also look at freezing and unfreezing columns and rows and the reasons for doing so.
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 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 lie charts.
We will look at selecting the charts, moving and resizing a chart, we will also delete a chart.
Another aspect we will do is the option to change the type of chart we are using, i.e from column to bar chart.
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