The Ultimate Microsoft Excel 2010 Training Course - 14 Hours

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

Course Description

Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss.

With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010.

This bundle includes:

  • Beginner and advanced courses for mastering Excel 2010
  • 14 hours of video tutorials
  • Over 100 individual video lectures
  • Optional quizzes to test what you’ve learned
  • Certificate of Completion

Courses included with this bundle:

Learn Microsoft Excel 2010 for Beginners

Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas.

Learn Microsoft Excel 2010 - Advanced

Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate.

Where else can you find so many extra tools to help you gain advanced skills in Excel?

What people are saying:

★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder

★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” -Sam Malone

★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro

★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” -Pierre Nantais

★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” -Debbie Lee

Who this course is for:

  • Anyone new to Microsoft Excel or upgrading from an earlier version.
  • Those seeking advanced Excel training.
  • Learn how to organize your data with rows, columns, and multiple sheets. Master both simple and more complex formulas. Sort and filter your data. Four basic steps to consider when creating charts and graphs. How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • Master both simple and more complex formulas. Sort and filter your data. Four basic steps to consider when creating charts and graphs. How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • Sort and filter your data. Four basic steps to consider when creating charts and graphs. How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • Four basic steps to consider when creating charts and graphs. How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen Option 03:43 Printing 6 lectures • 27min Page Setup Options Preview 05:11 Headers and Footers 07:37 Print Titles 02:29 Comments 04:22 Fit to print on one page 05:11 Printing Workbooks 02:21 Working with Rows, Columns, and Cells 2 lectures • 10min Adding and Deleting Rows, Columns, and Cells 05:41 Changing Column and Row Widths 04:40 Moving Data 2 lectures • 11min Cut, Copy and Paste 06:22 Copying Formulas 04:13 Formulas and Functions 4 lectures • 26min Overview of Formulas 03:01 Create Formulas using Functions - Part 1 10:21 Create Formulas using Functions - Part 2 06:55 Absolute Values 05:44 Working with Worksheets 3 lectures • 19min Adding, Deleting and Renaming Sheets 06:25 Additional Sheet Tab Options 05:09 3-D Formulas 07:13 Formatting Worksheets 8 lectures • 1hr 11min Cell Formatting Preview 12:17 Number Formatting 10:00 Borders and Shading 09:32 Format as Table 06:56 Using Styles 09:14 Using Format Painter 04:40 Protecting Sheets 11:27 Fill Handle and Custom Lists 07:11 21 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:'67818d9fab2f2ca9',m:'76d567786b5816e29e1e726532cbeae14c50c797-1627846985-1800-Adll+inrjJafpxOfvXWK5Hzvv+a5eTxpJwE4HMzrTBZj6HJdjKA7PeZiSE9EN/CTrN4muH1UkIr5HeDsAKglUyfzi2sAH+7Fglyk3UaP9ZUxJHFxH055QnDV44x6a1Mhbjbcm16XL5f6VbgHgyzaQPtQY3930iTK0hO07WqvIGfPXoXyHucHiAq9JF0a0V/4cw==',s:[0xd46cbf11e3,0x8e8e2a4e24],}})();
  • Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Show more Show less Requirements Microsoft Excel 2010 Description Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss. With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010. This bundle includes: Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you’ve learned Certificate of Completion Courses included with this bundle: Learn Microsoft Excel 2010 for Beginners Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate. Where else can you find so many extra tools to help you gain advanced skills in Excel? What people are saying: ★★★★★ “This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.” -Paul Schrooder ★★★★★ “Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!” - Sam Malone ★★★★★ “I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!” –David Munro ★★★★★ “Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.” - Pierre Nantais ★★★★★ “Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.” - Debbie Lee Who this course is for: Anyone new to Microsoft Excel or upgrading from an earlier version. Those seeking advanced Excel training. Show more Show less Course content 31 sections • 104 lectures • 14h 11m total length Expand all sections Intro to Excel 2010 5 lectures • 21min Introduction and Overview of Excel Course Preview 00:57 READ ME: Essential Information for a Successful Training Experience 01:01 Overview of the Excel Window Preview 11:52 Working with the Mouse 04:05 Excel Options 02:44 Getting Started Creating a New Workbook 5 lectures • 24min Entering Text and Numbers Preview 05:39 Creating Basic Formulas 06:55 Relative References 01:54 Order of Operations 04:33 Working withe Ranges 05:03 Saving Workbooks 2 lectures • 9min Working with Save and Save As Commands 05:22 File Extensions 03:48 Navigating Workbooks 4 lectures • 17min Opening a File 04:37 Working with Larger Files 06:27 Freeze Panes Options 02:20 Split Screen