Microsoft Excel for Mac: Beginners Excel 2019 Course

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

**This course includes practice exercises and LIFETIME access**

Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT.


Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac.

Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user.

If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you.

This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software.


In this course we show you how:

  • To create, open and save new workbooks in Excel Mac.

  • The basics of how Excel for Mac works including relative references and order of operations.

  • To set up your workbooks and print the right thing in Excel.

  • To use freeze panes and split screens.

  • To move data around in Excel for Mac.

  • Basic formulas and functions work in Excel for Mac.

  • To format your spreadsheets correctly.

  • To create some amazing looking charts and graphs.

  • To sort and filter your data in Excel

***Exercise and demo files included***


This course includes:

  1. 5+ hours of video tutorials

  2. 57 individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…

"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."

- Yunesh Garusinghe

"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."

- Cavin Macwan

"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"

- Coreen Teoh


Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Who this course is for:

  • Those new to using Microsoft Excel.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel.
  • Users of earlier versions of Excel looking to update their skills to 2019

Course content

14 sections • 64 lectures • 8h 25m total length
  • WATCH ME: Essential Information for a Successful Training Experience
    02:11
  • Course exercise files
    00:23
  • Course demo files
    00:23
  • Overview of the Excel window
    15:38
  • Expected Outcomes

    1. Discover Excel for Mac is different from Excel for PC. How create, save, and open a workbook. Complete data entry, cell formatting, and working with multiple worksheets. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    2. How create, save, and open a workbook. Complete data entry, cell formatting, and working with multiple worksheets. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    3. Complete data entry, cell formatting, and working with multiple worksheets. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    4. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    5. Discover how to format dates and numbers. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    6. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    7. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    8. How to rename, insert, move, and reference an Excel 2019 worksheet. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files included*** This course includes: 5+ hours of video tutorials 57 individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Who this course is for: Those new to using Microsoft Excel. No previous knowledge of Excel required. This course is created for absolute beginners. If you want to refresh your memory and understanding of Excel. Users of earlier versions of Excel looking to update their skills to 2019 Show more Show less Course content 14 sections • 64 lectures • 8h 25m total length Expand all sections Introduction to Excel 9 lectures • 42min Introduction to Excel for Mac Preview 05:23 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course exercise files 00:23 Course demo files 00:23 The Difference between PC and Mac Excel Preview 07:12 Course Overview Preview 03:42 Overview of the Excel window 15:38 Mouse and Trackpad Features 03:34 Creating a New Workbook 03:17 Section Quiz 2 questions Excel 2019 for Mac Beginner: Creating Workbooks 6 lectures • 40min Entering Text and Numbers Preview 09:14 Creating Basic Formulas Preview 09:53 Relative vs Absolute References 08:06 Order of Operations 03:42 Working with Ranges 06:52 Practice Exercise 01 02:02 Section Quiz 2 questions Excel 2019 for Mac Beginner: Saving Workbooks 2 lectures • 8min Saving and Sharing Spreadsheets 06:41 Practice Exercise 02 00:53 Section Quiz 2 questions Excel 2019 for Mac Beginner: Navigating Large Workbooks 4 lectures • 10min Freeze Panes Option Preview 03:46 Split Screen Option 02:35 Arranging Windows Option 02:16 Practice Exercise 03 00:57 Section Quiz 2 questions Excel 2019 for Mac Beginner: Page Setup and Print Options 6 lectures • 26min Headers and Footers 06:20 Print Titles 03:12 Comments 06:05 Page Setup Options 05:09 Printing Workbooks 03:32 Practice Exercise 04 01:23 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells 3 lectures • 9min Adding and Deleting Rows, Columns and Cells 03:42 Changing Column and Row Widths 03:50 Practice Exercise 05 01:07 Section Quiz 1 question Excel 2019 for Mac Beginner: Moving Data 3 lectures • 15min Cut, Copy and Paste 07:38 Copying Formulas 06:01 Practice Exercise 06 01:14 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formulas and Functions 4 lectures • 39min Overview of Formulas 08:40 Creating Formulas using Functions - Part 1 13:25 Creating Formulas using Functions - Part 2 14:17 Practice Exercise 07 02:08 Section Quiz 2 questions Excel 2019 for Mac Beginner: Working with Sheets 3 lectures • 15min Sheet Tab Options 06:08 3 Dimensional Formulas 06:25 Practice Exercise 08 02:09 Section Quiz 2 questions Excel 2019 for Mac Beginner: Formatting Worksheets 10 lectures • 1hr 7min Formatting Cells - Part 1 08:12 Formatting Cells - Part 2 07:35 Number Formatting 07:13 Formatting as Table 09:46 Using Styles 08:15 Conditional Formatting 10:19 Using Format Painter 03:07 Protecting Sheets 06:05 Fill Handle and Custom Lists 04:43 Practice Exercise 09 02:09 Section Quiz 2 questions 4 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67818e4048ba076a',m:'6fa4f9b523dceb91e4b55e428e996f627896eaab-1627847010-1800-AbJDwAy6bFoEkih0N2I3bK9y7VmAJFjLt6lWrnwgi8EB9kNgun03OtIF3pXUmnrIWMWUujAQOmWzqHTSTY3kKaXDnQxNzxcUzlFDrmbOsYvsnDKucj5PG7bxh2e1HYBESI7k3g/eYXou2yupQDTOUAhTq/AYoZZkOtXkMaQpKDCR6ADmY9G2HKZIHqJWXn/+wg==',s:[0x037bff3fbb,0xc14f12f762],}})();
    9. Discover how to create charts and graphs. Learn practical methods to sort and filter your data. Requirements Microsoft Excel 2019 version Mac installed and ready to use on your computer. Description **This course includes practice exercises and LIFETIME access** Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT. Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software. In this course we show you how: To create, open and save new workbooks in Excel Mac. The basics of how Excel for Mac works including relative references and order of operations. To set up your workbooks and print the right thing in Excel. To use freeze panes and split screens. To move data around in Excel for Mac. Basic formulas and functions work in Excel for Mac. To format your spreadsheets correctly. To create some amazing looking charts and graphs. To sort and filter your data in Excel ***Exercise and demo files includ