Microsoft Excel 2010 Course Beginners/ Intermediate Training

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

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.

By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.

  • 126 lectures (9.5 hours of content) teaching you from the basic to the advanced of this powerful program Suitable for beginners to advanced users. ideal for users who learn faster when shown. Visual training method, offering users increased retention and accelerated learning. Breaks even the most complex applications down into simplistic steps. Description A Verifiable Certificate of Completion is presented to all students who undertake this course. In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application. In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010. By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment. Show more Show less Course content 16 sections • 126 lectures • 9h 16m total length Expand all sections Getting Started 8 lectures • 25min Working Files - Download These First 00:01 0101 Overview Of Excel 2010 Preview 06:16 0102 The New File Menu In Excel 2010 Preview 05:09 0103 Exploring The Excel Workbook Preview 02:25 0104 What Will I Be Able To Do At The End Of This Course Preview 03:53 0105 Customizing The Quick Access Toolbar Preview 02:52 0106 Working With The Ribbons Preview 03:46 0107 Using The Files Included With This Course 00:33 Working With An Excel Worksheet 5 lectures • 14min 0201 Creating A New Workbook Preview 01:36 0202 Saving A Workbook Preview 02:25 0203 Saving In Other Formats 03:04 0204 Open A Existing Workbook 01:45 0205 Navigating An Excel Workbook 05:17 Selecting and Entering Data 13 lectures • 59min 0301 Entering Text And Numbers Preview 03:00 0302 Entering Numbers As Text Preview 03:47 0303 Inputting Dates And Times Preview 04:03 0304 Editing The Contents Of A Cell Preview 02:08 0305 Using Copy And Paste Preview 06:47 0306 The FILL Handle 07:05 0307 Using Undo And Redo 03:03 0308 Shortcuts For Selecting Cells 05:12 0309 Inserting Cells , Columns And Rows 05:17 0310 Deleting Cells , Columns And Rows 03:21 0311 Changing Column Widths And Row Heights 04:06 0312 Hiding And Unhiding A Column Or Row 05:09 0313 Searching For Values In A Worksheet Preview 05:34 Developing A Workbook 6 lectures • 22min 0401 Formatting And Naming Of Worksheet Tabs 03:41 0402 Moving Worksheets Within And Between Workbooks 04:49 0403 Copying Worksheets Within Workbooks 03:17 0404 Inserting And Deleting Worksheets 03:33 0405 Viewing More Than One Workbook 04:34 0406 Hiding And Unhiding Worksheets 02:02 Printing and Page Setup 9 lectures • 32min 0501 Using The Print Area Command To Control What Excel Prints 04:03 0502 Setting Page Margins And Page Orientation 03:29 0503 Creating A Header And Footer 04:48 0504 Using Page Break View 02:55 0505 Setting Print Titles For Large Worksheets 03:01 0506 Printing Gridlines Column Row Headings And Other Related Options 02:48 0507 Enabling The New Page Layout View 03:30 0508 Running The Spell Checker 03:23 0509 Print Preview And Printing The Whole Or Part Of The Worksheet 04:03 Workbook Formatting 9 lectures • 36min 0601 Modifying Typeface , Font Size And Colors 06:12 0602 Merging Cells 02:45 0603 Applying Number Formats 04:04 0604 Aligning Cell Contents 02:02 0605 Changing The Text Direction In A Cell 03:38 0606 Adding Borders To Cells And Ranges 04:43 0607 Applying A Date Format To A Cell Or Range 05:15 0608 Use Of The Format Painter 04:29 0609 Clearing Cell Contents And : Or Formatting 02:50 Carrying Out Calculations 17 lectures • 1hr 25min 0701 Getting Started With Basic Math Formula Addition 05:23 0702 Getting Started With Basic Math Formula Subtraction 03:20 0703 Getting Started With Basic Math Formula Multiplication 02:45 0704 Getting Started With Basic Math Formula Division 04:22 0705 Getting Started With Basic Math Formula Operand 02:36 0706 Order Of Operations With BODMAS 03:14 0707 Introduction To Excel Formulas SUM 07:46 0708 Copying Formulas And Functions 06:55 0709 Displaying Formulae On A Worksheet 02:59 0710 Some Useful Functions For Counting 04:06 0711 Some Useful Functions For Averages 04:02 0712 Some Useful Functions For Highest And Lowest 03:15 0713 Absolute Referencing Requirements 05:37 0714 Formulas Across Worksheets 07:46 0715 Functions Across Worksheets 04:44 0716 3D Referencing 06:58 0717 Making Use Of Named Cells And Ranges 09:24 Advanced Formatting 4 lectures • 19min 0801 Enhancing Worksheets Using Themes 02:40 0802 Working With Comments 04:45 0803 Creating Your Own Auto Fill List 05:45 0804 Turning Your Data Into A Table For Formatting 05:32 Security 4 lectures • 17min 0901 Using Protection On A Worksheet 03:35 0902 Protecting Part Of A Worksheet To Facilitate Data Entry 03:59 0903 Controlling Access To Cell Ranges By Password And Or User Accounts 05:17 0904 Saving A Workbook With Password Protection 03:46 Using Templates 2 lectures • 10min 1001 Creating A Workbook From A Template 03:35 1002 Creating Your Own Custom Template 06:16 6 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'678101641d8d40d2',m:'0a2e2e4472e8ed8aa16366765ac8b31c975b98fd-1627841241-1800-AfF3Oik96cOCxyL7Wi8msc+apiklbnV39iXQMUW4LP2tOMhO+N90DjVKd+lXZgLyCvgEKsGCZoBfHGQYM+PdkSXIou6Rxe9s7kXvojZlP05dAMkDkTMaHeq1ObMJ3EY+A30oPGqixBZWwSeENPKEGtI=',s:[0xd1b94e706e,0xade27179e1],}})();
  • Suitable for beginners to advanced users. ideal for users who learn faster when shown. Visual training method, offering users increased retention and accelerated learning. Breaks even the most complex applications down into simplistic steps. Description A Verifiable Certificate of Completion is presented to all students who undertake this course. In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application. In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010. By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment. Show more Show less Course content 16 sections • 126 lectures • 9h 16m total length Expand all sections Getting Started 8 lectures • 25min Working Files - Download These First 00:01 0101 Overview Of Excel 2010 Preview 06:16 0102 The New File Menu In Excel 2010 Preview 05:09 0103 Exploring The Excel Workbook Preview 02:25 0104 What Will I Be Able To Do At The End Of This Course Preview 03:53 0105 Customizing The Quick Access Toolbar Preview 02:52 0106 Working With The Ribbons Preview 03:46 0107 Using The Files Included With This Course 00:33 Working With An Excel Worksheet 5 lectures • 14min 0201 Creating A New Workbook Preview 01:36 0202 Saving A Workbook Preview 02:25 0203 Saving In Other Formats 03:04 0204 Open A Existing Workbook 01:45 0205 Navigating An Excel Workbook 05:17 Selecting and Entering Data 13 lectures • 59min 0301 Entering Text And Numbers Preview 03:00 0302 Entering Numbers As Text Preview 03:47 0303 Inputting Dates And Times Preview 04:03 0304 Editing The Contents Of A Cell Preview 02:08 0305 Using Copy And Paste Preview 06:47 0306 The FILL Handle 07:05 0307 Using Undo And Redo 03:03 0308 Shortcuts For Selecting Cells 05:12 0309 Inserting Cells , Columns And Rows 05:17 0310 Deleting Cells , Columns And Rows 03:21 0311 Changing Column Widths And Row Heights 04:06 0312 Hiding And Unhiding A Column Or Row 05:09 0313 Searching For Values In A Worksheet Preview 05:34 Developing A Workbook 6 lectures • 22min 0401 Formatting And Naming Of Worksheet Tabs 03:41 0402 Moving Worksheets Within And Between Workbooks 04:49 0403 Copying Worksheets Within Workbooks 03:17 0404 Inserting And Deleting Worksheets 03:33 0405 Viewing More Than One Workbook 04:34 0406 Hiding And Unhiding Worksheets 02:02 Printing and Page Setup 9 lectures • 32min 0501 Using The Print Area Command To Control What Excel Prints 04:03 0502 Setting Page Margins And Page Orientation 03:29 0503 Creating A Header And Footer 04:48 0504 Using Page Break View 02:55 0505 Setting Print Titles For Large Worksheets 03:01 0506 Printing Gridlines Column Row Headings And Other Related Options 02:48 0507 Enabling The New Page Layout View 03:30 0508 Running The Spell Checker 03:23 0509 Print Preview And Printing The Whole Or Part Of The Worksheet 04:03 Workbook Formatting 9 lectures • 36min 0601 Modifying Typeface , Font Size And Colors 06:12 0602 Merging Cells 02:45 0603 Applying Number Formats 04:04 0604 Aligning Cell Contents 02:02 0605 Changing The Text Direction In A Cell 03:38 0606 Adding Borders To Cells And Ranges 04:43 0607 Applying A Date Format To A Cell Or Range 05:15 0608 Use Of The Format Painter 04:29 0609 Clearing Cell Contents And : Or Formatting 02:50 Carrying Out Calculations 17 lectures • 1hr 25min 0701 Getting Started With Basic Math Formula Addition 05:23 0702 Getting Started With Basic Math Formula Subtraction 03:20 0703 Getting Started With Basic Math Formula Multiplication 02:45 0704 Getting Started With Basic Math Formula Division 04:22 0705 Getting Started With Basic Math Formula Operand 02:36 0706 Order Of Operations With BODMAS 03:14 0707 Introduction To Excel Formulas SUM 07:46 0708 Copying Formulas And Functions 06:55 0709 Displaying Formulae On A Worksheet 02:59 0710 Some Useful Functions For Counting 04:06 0711 Some Useful Functions For Averages 04:02 0712 Some Useful Functions For Highest And Lowest 03:15 0713 Absolute Referencing Requirements 05:37 0714 Formulas Across Worksheets 07:46 0715 Functions Across Worksheets 04:44 0716 3D Referencing 06:58 0717 Making Use Of Named Cells And Ranges 09:24 Advanced Formatting 4 lectures • 19min 0801 Enhancing Worksheets Using Themes 02:40 0802 Working With Comments 04:45 0803 Creating Your Own Auto Fill List 05:45 0804 Turning Your Data Into A Table For Formatting 05:32 Security 4 lectures • 17min 0901 Using Protection On A Worksheet 03:35 0902 Protecting Part Of A Worksheet To Facilitate Data Entry 03:59 0903 Controlling Access To Cell Ranges By Password And Or User Accounts 05:17 0904 Saving A Workbook With Password Protection 03:46 Using Templates 2 lectures • 10min 1001 Creating A Workbook From A Template 03:35 1002 Creating Your Own Custom Template 06:16 6 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'678101641d8d40d2',m:'0a2e2e4472e8ed8aa16366765ac8b31c975b98fd-1627841241-1800-AfF3Oik96cOCxyL7Wi8msc+apiklbnV39iXQMUW4LP2tOMhO+N90DjVKd+lXZgLyCvgEKsGCZoBfHGQYM+PdkSXIou6Rxe9s7kXvojZlP05dAMkDkTMaHeq1ObMJ3EY+A30oPGqixBZWwSeENPKEGtI=',s:[0xd1b94e706e,0xade27179e1],}})();
  • Visual training method, offering users increased retention and accelerated learning. Breaks even the most complex applications down into simplistic steps. Description A Verifiable Certificate of Completion is presented to all students who undertake this course. In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application. In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010. By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment. Show more Show less Course content 16 sections • 126 lectures • 9h 16m total length Expand all sections Getting Started 8 lectures • 25min Working Files - Download These First 00:01 0101 Overview Of Excel 2010 Preview 06:16 0102 The New File Menu In Excel 2010 Preview 05:09 0103 Exploring The Excel Workbook Preview 02:25 0104 What Will I Be Able To Do At The End Of This Course Preview 03:53 0105 Customizing The Quick Access Toolbar Preview 02:52 0106 Working With The Ribbons Preview 03:46 0107 Using The Files Included With This Course 00:33 Working With An Excel Worksheet 5 lectures • 14min 0201 Creating A New Workbook Preview 01:36 0202 Saving A Workbook Preview 02:25 0203 Saving In Other Formats 03:04 0204 Open A Existing Workbook 01:45 0205 Navigating An Excel Workbook 05:17 Selecting and Entering Data 13 lectures • 59min 0301 Entering Text And Numbers Preview 03:00 0302 Entering Numbers As Text Preview 03:47 0303 Inputting Dates And Times Preview 04:03 0304 Editing The Contents Of A Cell Preview 02:08 0305 Using Copy And Paste Preview 06:47 0306 The FILL Handle 07:05 0307 Using Undo And Redo 03:03 0308 Shortcuts For Selecting Cells 05:12 0309 Inserting Cells , Columns And Rows 05:17 0310 Deleting Cells , Columns And Rows 03:21 0311 Changing Column Widths And Row Heights 04:06 0312 Hiding And Unhiding A Column Or Row 05:09 0313 Searching For Values In A Worksheet Preview 05:34 Developing A Workbook 6 lectures • 22min 0401 Formatting And Naming Of Worksheet Tabs 03:41 0402 Moving Worksheets Within And Between Workbooks 04:49 0403 Copying Worksheets Within Workbooks 03:17 0404 Inserting And Deleting Worksheets 03:33 0405 Viewing More Than One Workbook 04:34 0406 Hiding And Unhiding Worksheets 02:02 Printing and Page Setup 9 lectures • 32min 0501 Using The Print Area Command To Control What Excel Prints 04:03 0502 Setting Page Margins And Page Orientation 03:29 0503 Creating A Header And Footer 04:48 0504 Using Page Break View 02:55 0505 Setting Print Titles For Large Worksheets 03:01 0506 Printing Gridlines Column Row Headings And Other Related Options 02:48 0507 Enabling The New Page Layout View 03:30 0508 Running The Spell Checker 03:23 0509 Print Preview And Printing The Whole Or Part Of The Worksheet 04:03 Workbook Formatting 9 lectures • 36min 0601 Modifying Typeface , Font Size And Colors 06:12 0602 Merging Cells 02:45 0603 Applying Number Formats 04:04 0604 Aligning Cell Contents 02:02 0605 Changing The Text Direction In A Cell 03:38 0606 Adding Borders To Cells And Ranges 04:43 0607 Applying A Date Format To A Cell Or Range 05:15 0608 Use Of The Format Painter 04:29 0609 Clearing Cell Contents And : Or Formatting 02:50 Carrying Out Calculations 17 lectures • 1hr 25min 0701 Getting Started With Basic Math Formula Addition 05:23 0702 Getting Started With Basic Math Formula Subtraction 03:20 0703 Getting Started With Basic Math Formula Multiplication 02:45 0704 Getting Started With Basic Math Formula Division 04:22 0705 Getting Started With Basic Math Formula Operand 02:36 0706 Order Of Operations With BODMAS 03:14 0707 Introduction To Excel Formulas SUM 07:46 0708 Copying Formulas And Functions 06:55 0709 Displaying Formulae On A Worksheet 02:59 0710 Some Useful Functions For Counting 04:06 0711 Some Useful Functions For Averages 04:02 0712 Some Useful Functions For Highest And Lowest 03:15 0713 Absolute Referencing Requirements 05:37 0714 Formulas Across Worksheets 07:46 0715 Functions Across Worksheets 04:44 0716 3D Referencing 06:58 0717 Making Use Of Named Cells And Ranges 09:24 Advanced Formatting 4 lectures • 19min 0801 Enhancing Worksheets Using Themes 02:40 0802 Working With Comments 04:45 0803 Creating Your Own Auto Fill List 05:45 0804 Turning Your Data Into A Table For Formatting 05:32 Security 4 lectures • 17min 0901 Using Protection On A Worksheet 03:35 0902 Protecting Part Of A Worksheet To Facilitate Data Entry 03:59 0903 Controlling Access To Cell Ranges By Password And Or User Accounts 05:17 0904 Saving A Workbook With Password Protection 03:46 Using Templates 2 lectures • 10min 1001 Creating A Workbook From A Template 03:35 1002 Creating Your Own Custom Template 06:16 6 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'678101641d8d40d2',m:'0a2e2e4472e8ed8aa16366765ac8b31c975b98fd-1627841241-1800-AfF3Oik96cOCxyL7Wi8msc+apiklbnV39iXQMUW4LP2tOMhO+N90DjVKd+lXZgLyCvgEKsGCZoBfHGQYM+PdkSXIou6Rxe9s7kXvojZlP05dAMkDkTMaHeq1ObMJ3EY+A30oPGqixBZWwSeENPKEGtI=',s:[0xd1b94e706e,0xade27179e1],}})();
  • Breaks even the most complex applications down into simplistic steps. Description A Verifiable Certificate of Completion is presented to all students who undertake this course. In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application. In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010. By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment. Show more Show less Course content 16 sections • 126 lectures • 9h 16m total length Expand all sections Getting Started 8 lectures • 25min Working Files - Download These First 00:01 0101 Overview Of Excel 2010 Preview 06:16 0102 The New File Menu In Excel 2010 Preview 05:09 0103 Exploring The Excel Workbook Preview 02:25 0104 What Will I Be Able To Do At The End Of This Course Preview 03:53 0105 Customizing The Quick Access Toolbar Preview 02:52 0106 Working With The Ribbons Preview 03:46 0107 Using The Files Included With This Course 00:33 Working With An Excel Worksheet 5 lectures • 14min 0201 Creating A New Workbook Preview 01:36 0202 Saving A Workbook Preview 02:25 0203 Saving In Other Formats 03:04 0204 Open A Existing Workbook 01:45 0205 Navigating An Excel Workbook 05:17 Selecting and Entering Data 13 lectures • 59min 0301 Entering Text And Numbers Preview 03:00 0302 Entering Numbers As Text Preview 03:47 0303 Inputting Dates And Times Preview 04:03 0304 Editing The Contents Of A Cell Preview 02:08 0305 Using Copy And Paste Preview 06:47 0306 The FILL Handle 07:05 0307 Using Undo And Redo 03:03 0308 Shortcuts For Selecting Cells 05:12 0309 Inserting Cells , Columns And Rows 05:17 0310 Deleting Cells , Columns And Rows 03:21 0311 Changing Column Widths And Row Heights 04:06 0312 Hiding And Unhiding A Column Or Row 05:09 0313 Searching For Values In A Worksheet Preview 05:34 Developing A Workbook 6 lectures • 22min 0401 Formatting And Naming Of Worksheet Tabs 03:41 0402 Moving Worksheets Within And Between Workbooks 04:49 0403 Copying Worksheets Within Workbooks 03:17 0404 Inserting And Deleting Worksheets 03:33 0405 Viewing More Than One Workbook 04:34 0406 Hiding And Unhiding Worksheets 02:02 Printing and Page Setup 9 lectures • 32min 0501 Using The Print Area Command To Control What Excel Prints 04:03 0502 Setting Page Margins And Page Orientation 03:29 0503 Creating A Header And Footer 04:48 0504 Using Page Break View 02:55 0505 Setting Print Titles For Large Worksheets 03:01 0506 Printing Gridlines Column Row Headings And Other Related Options 02:48 0507 Enabling The New Page Layout View 03:30 0508 Running The Spell Checker 03:23 0509 Print Preview And Printing The Whole Or Part Of The Worksheet 04:03 Workbook Formatting 9 lectures • 36min 0601 Modifying Typeface , Font Size And Colors 06:12 0602 Merging Cells 02:45 0603 Applying Number Formats 04:04 0604 Aligning Cell Contents 02:02 0605 Changing The Text Direction In A Cell 03:38 0606 Adding Borders To Cells And Ranges 04:43 0607 Applying A Date Format To A Cell Or Range 05:15 0608 Use Of The Format Painter 04:29 0609 Clearing Cell Contents And : Or Formatting 02:50 Carrying Out Calculations 17 lectures • 1hr 25min 0701 Getting Started With Basic Math Formula Addition 05:23 0702 Getting Started With Basic Math Formula Subtraction 03:20 0703 Getting Started With Basic Math Formula Multiplication 02:45 0704 Getting Started With Basic Math Formula Division 04:22 0705 Getting Started With Basic Math Formula Operand 02:36 0706 Order Of Operations With BODMAS 03:14 0707 Introduction To Excel Formulas SUM 07:46 0708 Copying Formulas And Functions 06:55 0709 Displaying Formulae On A Worksheet 02:59 0710 Some Useful Functions For Counting 04:06 0711 Some Useful Functions For Averages 04:02 0712 Some Useful Functions For Highest And Lowest 03:15 0713 Absolute Referencing Requirements 05:37 0714 Formulas Across Worksheets 07:46 0715 Functions Across Worksheets 04:44 0716 3D Referencing 06:58 0717 Making Use Of Named Cells And Ranges 09:24 Advanced Formatting 4 lectures • 19min 0801 Enhancing Worksheets Using Themes 02:40 0802 Working With Comments 04:45 0803 Creating Your Own Auto Fill List 05:45 0804 Turning Your Data Into A Table For Formatting 05:32 Security 4 lectures • 17min 0901 Using Protection On A Worksheet 03:35 0902 Protecting Part Of A Worksheet To Facilitate Data Entry 03:59 0903 Controlling Access To Cell Ranges By Password And Or User Accounts 05:17 0904 Saving A Workbook With Password Protection 03:46 Using Templates 2 lectures • 10min 1001 Creating A Workbook From A Template 03:35 1002 Creating Your Own Custom Template 06:16 6 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'678101641d8d40d2',m:'0a2e2e4472e8ed8aa16366765ac8b31c975b98fd-1627841241-1800-AfF3Oik96cOCxyL7Wi8msc+apiklbnV39iXQMUW4LP2tOMhO+N90DjVKd+lXZgLyCvgEKsGCZoBfHGQYM+PdkSXIou6Rxe9s7kXvojZlP05dAMkDkTMaHeq1ObMJ3EY+A30oPGqixBZWwSeENPKEGtI=',s:[0xd1b94e706e,0xade27179e1],}})();