Microsoft Office Excel 2010: Intermediate

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

Course Description

The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010.

Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks.

Who this course is for:

  • Candidates planning to upgrade to Microsoft Office Excel 2010
  • Candidates responsible to manage and maintain Excel workbooks at their workplaces
  • Accounting and finance professionals
  • University students
  • Use special number formats Outline and consolidate data Define cell and range names Sort and filter data in tables Save workbooks as webpages Learn advanced chart formatting Perform worksheet audit Insert comments in cells and workbooks Use built-in templates Learn about PivotTables and PivotCharts Show more Show less Requirements The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel. In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well. The students should also complete the previous level course before registering for this course. Description The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010. Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks. Who this course is for: Candidates planning to upgrade to Microsoft Office Excel 2010 Candidates responsible to manage and maintain Excel workbooks at their workplaces Accounting and finance professionals University students Show more Show less Course content 11 sections • 245 lectures • 4h 11m total length Expand all sections Introduction 3 lectures • 1min Course Introduction Preview 00:52 Instructor Introduction Preview 00:22 Instructor Introduction A Preview 00:10 Unit 01 - Using Multiple Worksheets and Workbooks 22 lectures • 23min Using Multiple Worksheets and Workbooks Preview 00:20 Topic A: Using Multiple Workbooks Preview 00:05 Switch Between Workbooks Preview 00:23 Demo - A-1: Switching Between Workbooks Preview 01:10 The Move or Copy Dialog Box Preview 01:19 Demo - A-2: Copying a Worksheet to Another Workbook Preview 01:28 Topic B: Linking Worksheets with 3-D Formulas Preview 00:09 Inserting a 3-D Reference Preview 00:59 Demo - B-1: Creating 3-D Formulas Preview 01:49 Adding a Watch Window Preview 00:42 Demo - B-2: Adding a Watch Window Preview 01:44 Topic C: Linking Workbooks 00:05 Demo - C-1: Examining External Links in a Worksheet 01:52 Syntax for External Links 00:52 Creating External Links 00:25 Demo - C-2: Creating External Links in a Worksheet 01:22 Redirecting Links 01:32 Demo - C-3: Editing Links 02:51 Topic D: Managing Workbooks 00:07 Creating a Workspace 00:53 Demo - D-1: Creating a Workspace 03:07 Unit 01 Review 00:15 Review - Question 5 questions Unit 02 - Advanced Formatting 40 lectures • 49min Advanced Formatting 00:21 Topic A: Using Special Number Formats 00:07 The Format Cells, Number Tab 00:54 Demo - A-1: Applying Special Formats 02:01 Hiding Zero Values 00:33 Demo - A-2: Controlling the Display of Zero Values 01:05 Customizing Number Formats 00:55 Custom Number Formats 00:40 Demo - A-3: Creating Custom Formats 03:26 Topic B: Using Functions to Format Text 00:08 Text Functions 01:27 Demo - B-1: Using PROPER, UPPER, and LOWER 03:27 The SUBSTITUTE Function 01:08 Demo - B-2: Using SUBSTITUTE 02:32 Topic C: Working with Styles 00:10 The Cell Styles Gallery 01:03 Creating Styles 00:43 Demo - C-1: Creating and Applying Styles 03:50 Modifying Styles 00:51 Demo - C-2: Modifying Styles 01:25 Topic D: Working with Themes 00:07 Theme Colors 01:27 Demo - D-1: Changing to a Different Theme 04:17 Creating New Theme Colors 00:48 Topic E: Other Advanced Formatting 00:11 Merging Cells 00:42 Wrap Text in a Cell 00:41 Changing Orientation of Text 00:49 Demo - E-1: Merging Cells 00:59 Demo - E-2: Changing the Orientation of Text in a Cell 00:46 Demo - E-3: Splitting Cells 01:20 Transposing Data 00:49 Demo - E-4: Transposing Data During a Paste 01:23 Use Paste Special to Add Values 00:40 Demo - E-5: Using Paste Special to Add Values 02:10 Adding Backgrounds 00:31 Demo - E-6: Adding and Deleting Backgrounds 02:22 Adding a Watermark 00:47 Demo - E-7: Adding a Watermark 01:12 Unit 02 Review 00:22 Review - Question 5 questions Unit 03 - Outlining and Subtotals 15 lectures • 20min Outlining and Subtotals 00:18 Topic A: Outlining and Consolidating Data 00:05 The Expanded Outline Form 00:47 The Collapsed Outline Form 00:38 Demo - A-1: Creating an Outline 02:49 Create a Custom View 00:41 Switch Among Custom Views 00:22 Demo - A-2: Creating Custom Views 01:42 The Consolidate Dialog Box 01:25 Demo - A-3: Using the Consolidate Command 04:19 Topic B: Creating Subtotals 00:04 The Subtotal Dialog Box 01:25 Demo - B-1: Creating Subtotals in a List 03:01 Demo - B-2: Using Multiple Subtotal Functions 01:57 Unit 03 Review 00:17 Review - Question 5 questions Unit 04 - Cell and Range Names 16 lectures • 21min Cell and Range Names 00:19 Topic A: Creating and Using Names 00:05 Defining Names 00:50 Demo - A-1: Naming and Selecting Ranges 01:21 Using Names in Formulas 00:51 Demo - A-2: Using Names in Formulas 01:49 Using Create from Selection 01:07 Demo - A-3: Using the Create from Selection Command 02:12 Applying Names 01:07 Demo - A-4: Applying Names to Existing Formulas 04:14 Topic B: Managing Names 00:05 The Name Manager Dialog Box 00:43 Demo - B-1: Modifying and Deleting Named Ranges 02:15 Creating a 3-D Name 01:26 Demo - B-2: Defining and Applying 3-D Names 02:26 Unit 04 Review 00:15 Review - Question 5 questions Unit 05 - Tables 27 lectures • 27min Tables 00:23 Topic A: Sorting and Filtering Data 00:05 Structure of Organized Data 01:24 Sorting Data Based on a Cell 00:37 Sorting by Multiple Columns 00:45 Demo - A-2: Sorting Data 01:29 Filtering Data 00:44 Sort and Filter by Color 01:05 Demo - A-3: Filtering Data by Using AutoFilter 02:23 Topic B: Advanced Filtering 00:09 Custom AutoFilter Dialog Box 00:56 Demo - B-1: Using Custom AutoFilter Criteria 01:50 Creating a Criteria Range 00:51 Demo - B-2: Using the Advanced Filter Dialog Box 02:45 Copying the Filtered Data 01:14 Topic C: Working with Tables 00:04 Creating a Table 01:02 Table Tools | Design Tab 01:00 Adding to a Table 00:35 Demo - C-1: Creating a Table 00:51 Demo - C-2: Formatting a Table 01:13 Demo - C-3: Adding and Deleting Rows and Columns 01:35 Structured References 01:07 Demo - C-4: Using Structured References 01:17 Table Names 00:28 The [@] Argument 01:02 Unit 05 Review 00:24 Review - Question 5 questions Unit 06 - Web and Sharing Features 18 lectures • 14min Web and Sharing Features 00:20 Topic A: Saving Workbooks as Web Pages 00:05 Customizing the Quick Access Toolbar 00:27 Saving a Workbook as a Web Page 00:38 Demo - A-2: Saving a Workbook as a Web Page 01:42 Publishing a Web Page 00:30 The Publish as Web Page Dialog Box 00:54 Topic B: Using Hyperlinks 00:05 Inserting a Hyperlink 00:39 Demo - B-1: Inserting a Hyperlink 02:21 Modify a Hyperlink 00:47 Demo - B-2: Modifying and Deleting a Hyperlink 02:02 Topic C: Sharing Workbooks 00:05 File Save & Send Page Options 00:14 Demo - C-1: Examining Workbook Sharing Options 00:48 Save & Send Options 01:29 Sharing Workbooks by Email 00:23 Unit 06 Review 00:20 Review - Question 5 questions Unit 07 - Advanced Charting 26 lectures • 24min Advanced Charting 00:20 Topic A: Chart Formatting Options 00:05 Format Axis: Axis Options 00:52 Demo - A-1: Adjusting the Scale of a Chart 01:14 Labeling a Data Point 00:21 Demo - A-2: Formatting a Data Point 02:07 Topic B: Combination Charts 00:04 Combination Chart: Changing Chart Type 00:23 Combination Chart: Adding a Secondary Axis 00:22 Demo - B-1: Creating a Combination Chart 01:20 Adding a Trendline 00:22 Demo - B-2: Creating a Trendline 00:43 Inserting Sparklines 00:48 Sparklines in a Worksheet 00:24 Demo - B-3: Inserting Sparklines 01:39 Downloading a Chart Template 01:44 Topic C: Graphical Elements 00:07 Adding Shapes to Charts 00:20 Demo - C-1: Adding Graphical Elements 02:31 Formatting Graphical Elements 00:25 Demo - C-2: Formatting a Graphical Element 01:15 Inserting a Picture from a File 00:26 Demo - C-3: Adding a Picture to a Worksheet 00:56 The Adjust Group 02:09 Demo - C-4: Modifying a Picture 02:30 Unit 07 Review 00:20 Review - Question 5 questions Unit 08 - Documenting and Auditing 31 lectures • 27min Documenting and Auditing 00:27 Topic A: Auditing Features 00:05 Dependent and Precedent Cells 00:29 Demo - A-1: Tracing Precedent and Dependent Cells 02:17 Tracing Errors in a Worksheet 00:16 Demo - A-2: Tracing Errors 01:22 Topic B: Comments in Cells and Workbooks 00:06 Viewing Comments 00:25 Demo - B-1: Viewing Comments in a Worksheet 01:02 Adding Cell Comments 00:13 Demo - B-2: Adding a Comment to a Cell 01:57 The Document Panel 00:35 Topic C: Protection 00:06 Password-Protect a Worksheet 00:25 Demo - C-1: Password-Protecting a Worksheet 01:42 Protect Parts of a Worksheet 00:46 Demo - C-2: Unlocking Cells and Protecting Part of a Worksheet 01:05 Protect the Workbook Structure 01:09 Demo - C-3: Protecting the Workbook Structure 02:42 Using Digital Signatures 00:38 Topic D: Workgroup Collaboration 00:10 Sharing a Workbook 00:31 Demo - D-1: Sharing a Workbook 00:47 Share Workbook: Advanced Tab 00:41 Tracking Changes 00:32 Accepting and Rejecting Changes 00:35 Demo - D-3: Tracking Changes in a Workbook 02:01 Using the Document Inspector 01:05 Marking a Workbook as Final 00:33 Demo - D-5: Marking a Workbook as Final 01:41 Unit 08 Review 00:25 Review - Question 5 questions Unit 09 - Templates and Settings 17 lectures • 17min Templates and Settings 00:21 Topic A: Application Settings 00:06 The Excel Options Dialog Box 00:57 Demo - A-1: Changing Application Settings 03:52 The Customize Ribbon Page 00:43 Demo - A-2: Customizing the Ribbon 02:05 Topic B: Built-in Templates 00:07 Available Templates 01:00 Using the Sales Invoice Template 00:22 Demo - B-1: Using a Downloaded Template 02:17 Topic C: Creating and Managing Templates 00:06 Creating a Template 00:38 Demo - C-1: Creating a Template 01:36 Modifying a Template 00:21 Demo - C-2: Modifying a Template 01:36 Using an Alternate Template Location 00:27 Unit 09 Review 00:21 Review - Question 5 questions 1 more section Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. 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:'6781ee6c5a46066a',m:'24617bed935b95a59d2ff2afc83c5f34de4663e8-1627850951-1800-AZ4MHX3nHTpBzyAs+3WEc69lDAD/s2kqcOy09rEGkSrk33cMulRqGwmEBi8fwNrDP88QrJqMezkAYaOyUL2zK0XTkh83MU0j15PYHBnBegIWawtEpQUHt0OM/o5gwiAZbN2TQvsC8SD6DDQx/oCdFhoT1tPThsSVFDbPucyKp3gfEmgWIZADE5HDgD/WHMXc8g==',s:[0x6a5b586e19,0xb17826bfb1],}})();
  • Outline and consolidate data Define cell and range names Sort and filter data in tables Save workbooks as webpages Learn advanced chart formatting Perform worksheet audit Insert comments in cells and workbooks Use built-in templates Learn about PivotTables and PivotCharts Show more Show less Requirements The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel. In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well. The students should also complete the previous level course before registering for this course. Description The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010. Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks. Who this course is for: Candidates planning to upgrade to Microsoft Office Excel 2010 Candidates responsible to manage and maintain Excel workbooks at their workplaces Accounting and finance professionals University students Show more Show less Course content 11 sections • 245 lectures • 4h 11m total length Expand all sections Introduction 3 lectures • 1min Course Introduction Preview 00:52 Instructor Introduction Preview 00:22 Instructor Introduction A Preview 00:10 Unit 01 - Using Multiple Worksheets and Workbooks 22 lectures • 23min Using Multiple Worksheets and Workbooks Preview 00:20 Topic A: Using Multiple Workbooks Preview 00:05 Switch Between Workbooks Preview 00:23 Demo - A-1: Switching Between Workbooks Preview 01:10 The Move or Copy Dialog Box Preview 01:19 Demo - A-2: Copying a Worksheet to Another Workbook Preview 01:28 Topic B: Linking Worksheets with 3-D Formulas Preview 00:09 Inserting a 3-D Reference Preview 00:59 Demo - B-1: Creating 3-D Formulas Preview 01:49 Adding a Watch Window Preview 00:42 Demo - B-2: Adding a Watch Window Preview 01:44 Topic C: Linking Workbooks 00:05 Demo - C-1: Examining External Links in a Worksheet 01:52 Syntax for External Links 00:52 Creating External Links 00:25 Demo - C-2: Creating External Links in a Worksheet 01:22 Redirecting Links 01:32 Demo - C-3: Editing Links 02:51 Topic D: Managing Workbooks 00:07 Creating a Workspace 00:53 Demo - D-1: Creating a Workspace 03:07 Unit 01 Review 00:15 Review - Question 5 questions Unit 02 - Advanced Formatting 40 lectures • 49min Advanced Formatting 00:21 Topic A: Using Special Number Formats 00:07 The Format Cells, Number Tab 00:54 Demo - A-1: Applying Special Formats 02:01 Hiding Zero Values 00:33 Demo - A-2: Controlling the Display of Zero Values 01:05 Customizing Number Formats 00:55 Custom Number Formats 00:40 Demo - A-3: Creating Custom Formats 03:26 Topic B: Using Functions to Format Text 00:08 Text Functions 01:27 Demo - B-1: Using PROPER, UPPER, and LOWER 03:27 The SUBSTITUTE Function 01:08 Demo - B-2: Using SUBSTITUTE 02:32 Topic C: Working with Styles 00:10 The Cell Styles Gallery 01:03 Creating Styles 00:43 Demo - C-1: Creating and Applying Styles 03:50 Modifying Styles 00:51 Demo - C-2: Modifying Styles 01:25 Topic D: Working with Themes 00:07 Theme Colors 01:27 Demo - D-1: Changing to a Different Theme 04:17 Creating New Theme Colors 00:48 Topic E: Other Advanced Formatting 00:11 Merging Cells 00:42 Wrap Text in a Cell 00:41 Changing Orientation of Text 00:49 Demo - E-1: Merging Cells 00:59 Demo - E-2: Changing the Orientation of Text in a Cell 00:46 Demo - E-3: Splitting Cells 01:20 Transposing Data 00:49 Demo - E-4: Transposing Data During a Paste 01:23 Use Paste Special to Add Values 00:40 Demo - E-5: Using Paste Special to Add Values 02:10 Adding Backgrounds 00:31 Demo - E-6: Adding and Deleting Backgrounds 02:22 Adding a Watermark 00:47 Demo - E-7: Adding a Watermark 01:12 Unit 02 Review 00:22 Review - Question 5 questions Unit 03 - Outlining and Subtotals 15 lectures • 20min Outlining and Subtotals 00:18 Topic A: Outlining and Consolidating Data 00:05 The Expanded Outline Form 00:47 The Collapsed Outline Form 00:38 Demo - A-1: Creating an Outline 02:49 Create a Custom View 00:41 Switch Among Custom Views 00:22 Demo - A-2: Creating Custom Views 01:42 The Consolidate Dialog Box 01:25 Demo - A-3: Using the Consolidate Command 04:19 Topic B: Creating Subtotals 00:04 The Subtotal Dialog Box 01:25 Demo - B-1: Creating Subtotals in a List 03:01 Demo - B-2: Using Multiple Subtotal Functions 01:57 Unit 03 Review 00:17 Review - Question 5 questions Unit 04 - Cell and Range Names 16 lectures • 21min Cell and Range Names 00:19 Topic A: Creating and Using Names 00:05 Defining Names 00:50 Demo - A-1: Naming and Selecting Ranges 01:21 Using Names in Formulas 00:51 Demo - A-2: Using Names in Formulas 01:49 Using Create from Selection 01:07 Demo - A-3: Using the Create from Selection Command 02:12 Applying Names 01:07 Demo - A-4: Applying Names to Existing Formulas 04:14 Topic B: Managing Names 00:05 The Name Manager Dialog Box 00:43 Demo - B-1: Modifying and Deleting Named Ranges 02:15 Creating a 3-D Name 01:26 Demo - B-2: Defining and Applying 3-D Names 02:26 Unit 04 Review 00:15 Review - Question 5 questions Unit 05 - Tables 27 lectures • 27min Tables 00:23 Topic A: Sorting and Filtering Data 00:05 Structure of Organized Data 01:24 Sorting Data Based on a Cell 00:37 Sorting by Multiple Columns 00:45 Demo - A-2: Sorting Data 01:29 Filtering Data 00:44 Sort and Filter by Color 01:05 Demo - A-3: Filtering Data by Using AutoFilter 02:23 Topic B: Advanced Filtering 00:09 Custom AutoFilter Dialog Box 00:56 Demo - B-1: Using Custom AutoFilter Criteria 01:50 Creating a Criteria Range 00:51 Demo - B-2: Using the Advanced Filter Dialog Box 02:45 Copying the Filtered Data 01:14 Topic C: Working with Tables 00:04 Creating a Table 01:02 Table Tools | Design Tab 01:00 Adding to a Table 00:35 Demo - C-1: Creating a Table 00:51 Demo - C-2: Formatting a Table 01:13 Demo - C-3: Adding and Deleting Rows and Columns 01:35 Structured References 01:07 Demo - C-4: Using Structured References 01:17 Table Names 00:28 The [@] Argument 01:02 Unit 05 Review 00:24 Review - Question 5 questions Unit 06 - Web and Sharing Features 18 lectures • 14min Web and Sharing Features 00:20 Topic A: Saving Workbooks as Web Pages 00:05 Customizing the Quick Access Toolbar 00:27 Saving a Workbook as a Web Page 00:38 Demo - A-2: Saving a Workbook as a Web Page 01:42 Publishing a Web Page 00:30 The Publish as Web Page Dialog Box 00:54 Topic B: Using Hyperlinks 00:05 Inserting a Hyperlink 00:39 Demo - B-1: Inserting a Hyperlink 02:21 Modify a Hyperlink 00:47 Demo - B-2: Modifying and Deleting a Hyperlink 02:02 Topic C: Sharing Workbooks 00:05 File Save & Send Page Options 00:14 Demo - C-1: Examining Workbook Sharing Options 00:48 Save & Send Options 01:29 Sharing Workbooks by Email 00:23 Unit 06 Review 00:20 Review - Question 5 questions Unit 07 - Advanced Charting 26 lectures • 24min Advanced Charting 00:20 Topic A: Chart Formatting Options 00:05 Format Axis: Axis Options 00:52 Demo - A-1: Adjusting the Scale of a Chart 01:14 Labeling a Data Point 00:21 Demo - A-2: Formatting a Data Point 02:07 Topic B: Combination Charts 00:04 Combination Chart: Changing Chart Type 00:23 Combination Chart: Adding a Secondary Axis 00:22 Demo - B-1: Creating a Combination Chart 01:20 Adding a Trendline 00:22 Demo - B-2: Creating a Trendline 00:43 Inserting Sparklines 00:48 Sparklines in a Worksheet 00:24 Demo - B-3: Inserting Sparklines 01:39 Downloading a Chart Template 01:44 Topic C: Graphical Elements 00:07 Adding Shapes to Charts 00:20 Demo - C-1: Adding Graphical Elements 02:31 Formatting Graphical Elements 00:25 Demo - C-2: Formatting a Graphical Element 01:15 Inserting a Picture from a File 00:26 Demo - C-3: Adding a Picture to a Worksheet 00:56 The Adjust Group 02:09 Demo - C-4: Modifying a Picture 02:30 Unit 07 Review 00:20 Review - Question 5 questions Unit 08 - Documenting and Auditing 31 lectures • 27min Documenting and Auditing 00:27 Topic A: Auditing Features 00:05 Dependent and Precedent Cells 00:29 Demo - A-1: Tracing Precedent and Dependent Cells 02:17 Tracing Errors in a Worksheet 00:16 Demo - A-2: Tracing Errors 01:22 Topic B: Comments in Cells and Workbooks 00:06 Viewing Comments 00:25 Demo - B-1: Viewing Comments in a Worksheet 01:02 Adding Cell Comments 00:13 Demo - B-2: Adding a Comment to a Cell 01:57 The Document Panel 00:35 Topic C: Protection 00:06 Password-Protect a Worksheet 00:25 Demo - C-1: Password-Protecting a Worksheet 01:42 Protect Parts of a Worksheet 00:46 Demo - C-2: Unlocking Cells and Protecting Part of a Worksheet 01:05 Protect the Workbook Structure 01:09 Demo - C-3: Protecting the Workbook Structure 02:42 Using Digital Signatures 00:38 Topic D: Workgroup Collaboration 00:10 Sharing a Workbook 00:31 Demo - D-1: Sharing a Workbook 00:47 Share Workbook: Advanced Tab 00:41 Tracking Changes 00:32 Accepting and Rejecting Changes 00:35 Demo - D-3: Tracking Changes in a Workbook 02:01 Using the Document Inspector 01:05 Marking a Workbook as Final 00:33 Demo - D-5: Marking a Workbook as Final 01:41 Unit 08 Review 00:25 Review - Question 5 questions Unit 09 - Templates and Settings 17 lectures • 17min Templates and Settings 00:21 Topic A: Application Settings 00:06 The Excel Options Dialog Box 00:57 Demo - A-1: Changing Application Settings 03:52 The Customize Ribbon Page 00:43 Demo - A-2: Customizing the Ribbon 02:05 Topic B: Built-in Templates 00:07 Available Templates 01:00 Using the Sales Invoice Template 00:22 Demo - B-1: Using a Downloaded Template 02:17 Topic C: Creating and Managing Templates 00:06 Creating a Template 00:38 Demo - C-1: Creating a Template 01:36 Modifying a Template 00:21 Demo - C-2: Modifying a Template 01:36 Using an Alternate Template Location 00:27 Unit 09 Review 00:21 Review - Question 5 questions 1 more section Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. 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:'6781ee6c5a46066a',m:'24617bed935b95a59d2ff2afc83c5f34de4663e8-1627850951-1800-AZ4MHX3nHTpBzyAs+3WEc69lDAD/s2kqcOy09rEGkSrk33cMulRqGwmEBi8fwNrDP88QrJqMezkAYaOyUL2zK0XTkh83MU0j15PYHBnBegIWawtEpQUHt0OM/o5gwiAZbN2TQvsC8SD6DDQx/oCdFhoT1tPThsSVFDbPucyKp3gfEmgWIZADE5HDgD/WHMXc8g==',s:[0x6a5b586e19,0xb17826bfb1],}})();
  • Define cell and range names Sort and filter data in tables Save workbooks as webpages Learn advanced chart formatting Perform worksheet audit Insert comments in cells and workbooks Use built-in templates Learn about PivotTables and PivotCharts Show more Show less Requirements The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel. In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well. The students should also complete the previous level course before registering for this course. Description The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010. Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks. Who this course is for: Candidates planning to upgrade to Microsoft Office Excel 2010 Candidates responsible to manage and maintain Excel workbooks at their workplaces Accounting and finance professionals University students Show more Show less Course content 11 sections • 245 lectures • 4h 11m total length Expand all sections Introduction 3 lectures • 1min Course Introduction Preview 00:52 Instructor Introduction Preview 00:22 Instructor Introduction A Preview 00:10 Unit 01 - Using Multiple Worksheets and Workbooks 22 lectures • 23min Using Multiple Worksheets and Workbooks Preview 00:20 Topic A: Using Multiple Workbooks Preview 00:05 Switch Between Workbooks Preview 00:23 Demo - A-1: Switching Between Workbooks Preview 01:10 The Move or Copy Dialog Box Preview 01:19 Demo - A-2: Copying a Worksheet to Another Workbook Preview 01:28 Topic B: Linking Worksheets with 3-D Formulas Preview 00:09 Inserting a 3-D Reference Preview 00:59 Demo - B-1: Creating 3-D Formulas Preview 01:49 Adding a Watch Window Preview 00:42 Demo - B-2: Adding a Watch Window Preview 01:44 Topic C: Linking Workbooks 00:05 Demo - C-1: Examining External Links in a Worksheet 01:52 Syntax for External Links 00:52 Creating External Links 00:25 Demo - C-2: Creating External Links in a Worksheet 01:22 Redirecting Links 01:32 Demo - C-3: Editing Links 02:51 Topic D: Managing Workbooks 00:07 Creating a Workspace 00:53 Demo - D-1: Creating a Workspace 03:07 Unit 01 Review 00:15 Review - Question 5 questions Unit 02 - Advanced Formatting 40 lectures • 49min Advanced Formatting 00:21 Topic A: Using Special Number Formats 00:07 The Format Cells, Number Tab 00:54 Demo - A-1: Applying Special Formats 02:01 Hiding Zero Values 00:33 Demo - A-2: Controlling the Display of Zero Values 01:05 Customizing Number Formats 00:55 Custom Number Formats 00:40 Demo - A-3: Creating Custom Formats 03:26 Topic B: Using Functions to Format Text 00:08 Text Functions 01:27 Demo - B-1: Using PROPER, UPPER, and LOWER 03:27 The SUBSTITUTE Function 01:08 Demo - B-2: Using SUBSTITUTE 02:32 Topic C: Working with Styles 00:10 The Cell Styles Gallery 01:03 Creating Styles 00:43 Demo - C-1: Creating and Applying Styles 03:50 Modifying Styles 00:51 Demo - C-2: Modifying Styles 01:25 Topic D: Working with Themes 00:07 Theme Colors 01:27 Demo - D-1: Changing to a Different Theme 04:17 Creating New Theme Colors 00:48 Topic E: Other Advanced Formatting 00:11 Merging Cells 00:42 Wrap Text in a Cell 00:41 Changing Orientation of Text 00:49 Demo - E-1: Merging Cells 00:59 Demo - E-2: Changing the Orientation of Text in a Cell 00:46 Demo - E-3: Splitting Cells 01:20 Transposing Data 00:49 Demo - E-4: Transposing Data During a Paste 01:23 Use Paste Special to Add Values 00:40 Demo - E-5: Using Paste Special to Add Values 02:10 Adding Backgrounds 00:31 Demo - E-6: Adding and Deleting Backgrounds 02:22 Adding a Watermark 00:47 Demo - E-7: Adding a Watermark 01:12 Unit 02 Review 00:22 Review - Question 5 questions Unit 03 - Outlining and Subtotals 15 lectures • 20min Outlining and Subtotals 00:18 Topic A: Outlining and Consolidating Data 00:05 The Expanded Outline Form 00:47 The Collapsed Outline Form 00:38 Demo - A-1: Creating an Outline 02:49 Create a Custom View 00:41 Switch Among Custom Views 00:22 Demo - A-2: Creating Custom Views 01:42 The Consolidate Dialog Box 01:25 Demo - A-3: Using the Consolidate Command 04:19 Topic B: Creating Subtotals 00:04 The Subtotal Dialog Box 01:25 Demo - B-1: Creating Subtotals in a List 03:01 Demo - B-2: Using Multiple Subtotal Functions 01:57 Unit 03 Review 00:17 Review - Question 5 questions Unit 04 - Cell and Range Names 16 lectures • 21min Cell and Range Names 00:19 Topic A: Creating and Using Names 00:05 Defining Names 00:50 Demo - A-1: Naming and Selecting Ranges 01:21 Using Names in Formulas 00:51 Demo - A-2: Using Names in Formulas 01:49 Using Create from Selection 01:07 Demo - A-3: Using the Create from Selection Command 02:12 Applying Names 01:07 Demo - A-4: Applying Names to Existing Formulas 04:14 Topic B: Managing Names 00:05 The Name Manager Dialog Box 00:43 Demo - B-1: Modifying and Deleting Named Ranges 02:15 Creating a 3-D Name 01:26 Demo - B-2: Defining and Applying 3-D Names 02:26 Unit 04 Review 00:15 Review - Question 5 questions Unit 05 - Tables 27 lectures • 27min Tables 00:23 Topic A: Sorting and Filtering Data 00:05 Structure of Organized Data 01:24 Sorting Data Based on a Cell 00:37 Sorting by Multiple Columns 00:45 Demo - A-2: Sorting Data 01:29 Filtering Data 00:44 Sort and Filter by Color 01:05 Demo - A-3: Filtering Data by Using AutoFilter 02:23 Topic B: Advanced Filtering 00:09 Custom AutoFilter Dialog Box 00:56 Demo - B-1: Using Custom AutoFilter Criteria 01:50 Creating a Criteria Range 00:51 Demo - B-2: Using the Advanced Filter Dialog Box 02:45 Copying the Filtered Data 01:14 Topic C: Working with Tables 00:04 Creating a Table 01:02 Table Tools | Design Tab 01:00 Adding to a Table 00:35 Demo - C-1: Creating a Table 00:51 Demo - C-2: Formatting a Table 01:13 Demo - C-3: Adding and Deleting Rows and Columns 01:35 Structured References 01:07 Demo - C-4: Using Structured References 01:17 Table Names 00:28 The [@] Argument 01:02 Unit 05 Review 00:24 Review - Question 5 questions Unit 06 - Web and Sharing Features 18 lectures • 14min Web and Sharing Features 00:20 Topic A: Saving Workbooks as Web Pages 00:05 Customizing the Quick Access Toolbar 00:27 Saving a Workbook as a Web Page 00:38 Demo - A-2: Saving a Workbook as a Web Page 01:42 Publishing a Web Page 00:30 The Publish as Web Page Dialog Box 00:54 Topic B: Using Hyperlinks 00:05 Inserting a Hyperlink 00:39 Demo - B-1: Inserting a Hyperlink 02:21 Modify a Hyperlink 00:47 Demo - B-2: Modifying and Deleting a Hyperlink 02:02 Topic C: Sharing Workbooks 00:05 File Save & Send Page Options 00:14 Demo - C-1: Examining Workbook Sharing Options 00:48 Save & Send Options 01:29 Sharing Workbooks by Email 00:23 Unit 06 Review 00:20 Review - Question 5 questions Unit 07 - Advanced Charting 26 lectures • 24min Advanced Charting 00:20 Topic A: Chart Formatting Options 00:05 Format Axis: Axis Options 00:52 Demo - A-1: Adjusting the Scale of a Chart 01:14 Labeling a Data Point 00:21 Demo - A-2: Formatting a Data Point 02:07 Topic B: Combination Charts 00:04 Combination Chart: Changing Chart Type 00:23 Combination Chart: Adding a Secondary Axis 00:22 Demo - B-1: Creating a Combination Chart 01:20 Adding a Trendline 00:22 Demo - B-2: Creating a Trendline 00:43 Inserting Sparklines 00:48 Sparklines in a Worksheet 00:24 Demo - B-3: Inserting Sparklines 01:39 Downloading a Chart Template 01:44 Topic C: Graphical Elements 00:07 Adding Shapes to Charts 00:20 Demo - C-1: Adding Graphical Elements 02:31 Formatting Graphical Elements 00:25 Demo - C-2: Formatting a Graphical Element 01:15 Inserting a Picture from a File 00:26 Demo - C-3: Adding a Picture to a Worksheet 00:56 The Adjust Group 02:09 Demo - C-4: Modifying a Picture 02:30 Unit 07 Review 00:20 Review - Question 5 questions Unit 08 - Documenting and Auditing 31 lectures • 27min Documenting and Auditing 00:27 Topic A: Auditing Features 00:05 Dependent and Precedent Cells 00:29 Demo - A-1: Tracing Precedent and Dependent Cells 02:17 Tracing Errors in a Worksheet 00:16 Demo - A-2: Tracing Errors 01:22 Topic B: Comments in Cells and Workbooks 00:06 Viewing Comments 00:25 Demo - B-1: Viewing Comments in a Worksheet 01:02 Adding Cell Comments 00:13 Demo - B-2: Adding a Comment to a Cell 01:57 The Document Panel 00:35 Topic C: Protection 00:06 Password-Protect a Worksheet 00:25 Demo - C-1: Password-Protecting a Worksheet 01:42 Protect Parts of a Worksheet 00:46 Demo - C-2: Unlocking Cells and Protecting Part of a Worksheet 01:05 Protect the Workbook Structure 01:09 Demo - C-3: Protecting the Workbook Structure 02:42 Using Digital Signatures 00:38 Topic D: Workgroup Collaboration 00:10 Sharing a Workbook 00:31 Demo - D-1: Sharing a Workbook 00:47 Share Workbook: Advanced Tab 00:41 Tracking Changes 00:32 Accepting and Rejecting Changes 00:35 Demo - D-3: Tracking Changes in a Workbook 02:01 Using the Document Inspector 01:05 Marking a Workbook as Final 00:33 Demo - D-5: Marking a Workbook as Final 01:41 Unit 08 Review 00:25 Review - Question 5 questions Unit 09 - Templates and Settings 17 lectures • 17min Templates and Settings 00:21 Topic A: Application Settings 00:06 The Excel Options Dialog Box 00:57 Demo - A-1: Changing Application Settings 03:52 The Customize Ribbon Page 00:43 Demo - A-2: Customizing the Ribbon 02:05 Topic B: Built-in Templates 00:07 Available Templates 01:00 Using the Sales Invoice Template 00:22 Demo - B-1: Using a Downloaded Template 02:17 Topic C: Creating and Managing Templates 00:06 Creating a Template 00:38 Demo - C-1: Creating a Template 01:36 Modifying a Template 00:21 Demo - C-2: Modifying a Template 01:36 Using an Alternate Template Location 00:27 Unit 09 Review 00:21 Review - Question 5 questions 1 more section Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. 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:'6781ee6c5a46066a',m:'24617bed935b95a59d2ff2afc83c5f34de4663e8-1627850951-1800-AZ4MHX3nHTpBzyAs+3WEc69lDAD/s2kqcOy09rEGkSrk33cMulRqGwmEBi8fwNrDP88QrJqMezkAYaOyUL2zK0XTkh83MU0j15PYHBnBegIWawtEpQUHt0OM/o5gwiAZbN2TQvsC8SD6DDQx/oCdFhoT1tPThsSVFDbPucyKp3gfEmgWIZADE5HDgD/WHMXc8g==',s:[0x6a5b586e19,0xb17826bfb1],}})();
  • Sort and filter data in tables Save workbooks as webpages Learn advanced chart formatting Perform worksheet audit Insert comments in cells and workbooks Use built-in templates Learn about PivotTables and PivotCharts Show more Show less Requirements The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel. In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well. The students should also complete the previous level course before registering for this course. Description The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010. Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks. Who this course is for: Candidates planning to upgrade to Microsoft Office Excel 2010 Candidates responsible to manage and maintain Excel workbooks at their workplaces Accounting and finance professionals University students Show more Show less Course content 11 sections • 245 lectures • 4h 11m total length Expand all sections Introduction 3 lectures • 1min Course Introduction Preview 00:52 Instructor Introduction Preview 00:22 Instructor Introduction A Preview 00:10 Unit 01 - Using Multiple Worksheets and Workbooks 22 lectures • 23min Using Multiple Worksheets and Workbooks Preview 00:20 Topic A: Using Multiple Workbooks Preview 00:05 Switch Between Workbooks Preview 00:23 Demo - A-1: Switching Between Workbooks Preview 01:10 The Move or Copy Dialog Box Preview 01:19 Demo - A-2: Copying a Worksheet to Another Workbook Preview 01:28 Topic B: Linking Worksheets with 3-D Formulas Preview 00:09 Inserting a 3-D Reference Preview 00:59 Demo - B-1: Creating 3-D Formulas Preview 01:49 Adding a Watch Window Preview 00:42 Demo - B-2: Adding a Watch Window Preview 01:44 Topic C: Linking Workbooks 00:05 Demo - C-1: Examining External Links in a Worksheet 01:52 Syntax for External Links 00:52 Creating External Links 00:25 Demo - C-2: Creating External Links in a Worksheet 01:22 Redirecting Links 01:32 Demo - C-3: Editing Links 02:51 Topic D: Managing Workbooks 00:07 Creating a Workspace 00:53 Demo - D-1: Creating a Workspace 03:07 Unit 01 Review 00:15 Review - Question 5 questions Unit 02 - Advanced Formatting 40 lectures • 49min Advanced Formatting 00:21 Topic A: Using Special Number Formats 00:07 The Format Cells, Number Tab 00:54 Demo - A-1: Applying Special Formats 02:01 Hiding Zero Values 00:33 Demo - A-2: Controlling the Display of Zero Values 01:05 Customizing Number Formats 00:55 Custom Number Formats 00:40 Demo - A-3: Creating Custom Formats 03:26 Topic B: Using Functions to Format Text 00:08 Text Functions 01:27 Demo - B-1: Using PROPER, UPPER, and LOWER 03:27 The SUBSTITUTE Function 01:08 Demo - B-2: Using SUBSTITUTE 02:32 Topic C: Working with Styles 00:10 The Cell Styles Gallery 01:03 Creating Styles 00:43 Demo - C-1: Creating and Applying Styles 03:50 Modifying Styles 00:51 Demo - C-2: Modifying Styles 01:25 Topic D: Working with Themes 00:07 Theme Colors 01:27 Demo - D-1: Changing to a Different Theme 04:17 Creating New Theme Colors 00:48 Topic E: Other Advanced Formatting 00:11 Merging Cells 00:42 Wrap Text in a Cell 00:41 Changing Orientation of Text 00:49 Demo - E-1: Merging Cells 00:59 Demo - E-2: Changing the Orientation of Text in a Cell 00:46 Demo - E-3: Splitting Cells 01:20 Transposing Data 00:49 Demo - E-4: Transposing Data During a Paste 01:23 Use Paste Special to Add Values 00:40 Demo - E-5: Using Paste Special to Add Values 02:10 Adding Backgrounds 00:31 Demo - E-6: Adding and Deleting Backgrounds 02:22 Adding a Watermark 00:47 Demo - E-7: Adding a Watermark 01:12 Unit 02 Review 00:22 Review - Question 5 questions Unit 03 - Outlining and Subtotals 15 lectures • 20min Outlining and Subtotals 00:18 Topic A: Outlining and Consolidating Data 00:05 The Expanded Outline Form 00:47 The Collapsed Outline Form 00:38 Demo - A-1: Creating an Outline 02:49 Create a Custom View 00:41 Switch Among Custom Views 00:22 Demo - A-2: Creating Custom Views 01:42 The Consolidate Dialog Box 01:25 Demo - A-3: Using the Consolidate Command 04:19 Topic B: Creating Subtotals 00:04 The Subtotal Dialog Box 01:25 Demo - B-1: Creating Subtotals in a List 03:01 Demo - B-2: Using Multiple Subtotal Functions 01:57 Unit 03 Review 00:17 Review - Question 5 questions Unit 04 - Cell and Range Names 16 lectures • 21min Cell and Range Names 00:19 Topic A: Creating and Using Names 00:05 Defining Names 00:50 Demo - A-1: Naming and Selecting Ranges 01:21 Using Names in Formulas 00:51 Demo - A-2: Using Names in Formulas 01:49 Using Create from Selection 01:07 Demo - A-3: Using the Create from Selection Command 02:12 Applying Names 01:07 Demo - A-4: Applying Names to Existing Formulas 04:14 Topic B: Managing Names 00:05 The Name Manager Dialog Box 00:43 Demo - B-1: Modifying and Deleting Named Ranges 02:15 Creating a 3-D Name 01:26 Demo - B-2: Defining and Applying 3-D Names 02:26 Unit 04 Review 00:15 Review - Question 5 questions Unit 05 - Tables 27 lectures • 27min Tables 00:23 Topic A: Sorting and Filtering Data 00:05 Structure of Organized Data 01:24 Sorting Data Based on a Cell 00:37 Sorting by Multiple Columns 00:45 Demo - A-2: Sorting Data 01:29 Filtering Data 00:44 Sort and Filter by Color 01:05 Demo - A-3: Filtering Data by Using AutoFilter 02:23 Topic B: Advanced Filtering 00:09 Custom AutoFilter Dialog Box 00:56 Demo - B-1: Using Custom AutoFilter Criteria 01:50 Creating a Criteria Range 00:51 Demo - B-2: Using the Advanced Filter Dialog Box 02:45 Copying the Filtered Data 01:14 Topic C: Working with Tables 00:04 Creating a Table 01:02 Table Tools | Design Tab 01:00 Adding to a Table 00:35 Demo - C-1: Creating a Table 00:51 Demo - C-2: Formatting a Table 01:13 Demo - C-3: Adding and Deleting Rows and Columns 01:35 Structured References 01:07 Demo - C-4: Using Structured References 01:17 Table Names 00:28 The [@] Argument 01:02 Unit 05 Review 00:24 Review - Question 5 questions Unit 06 - Web and Sharing Features 18 lectures • 14min Web and Sharing Features 00:20 Topic A: Saving Workbooks as Web Pages 00:05 Customizing the Quick Access Toolbar 00:27 Saving a Workbook as a Web Page 00:38 Demo - A-2: Saving a Workbook as a Web Page 01:42 Publishing a Web Page 00:30 The Publish as Web Page Dialog Box 00:54 Topic B: Using Hyperlinks 00:05 Inserting a Hyperlink 00:39 Demo - B-1: Inserting a Hyperlink 02:21 Modify a Hyperlink 00:47 Demo - B-2: Modifying and Deleting a Hyperlink 02:02 Topic C: Sharing Workbooks 00:05 File Save & Send Page Options 00:14 Demo - C-1: Examining Workbook Sharing Options 00:48 Save & Send Options 01:29 Sharing Workbooks by Email 00:23 Unit 06 Review 00:20 Review - Question 5 questions Unit 07 - Advanced Charting 26 lectures • 24min Advanced Charting 00:20 Topic A: Chart Formatting Options 00:05 Format Axis: Axis Options 00:52 Demo - A-1: Adjusting the Scale of a Chart 01:14 Labeling a Data Point 00:21 Demo - A-2: Formatting a Data Point 02:07 Topic B: Combination Charts 00:04 Combination Chart: Changing Chart Type 00:23 Combination Chart: Adding a Secondary Axis 00:22 Demo - B-1: Creating a Combination Chart 01:20 Adding a Trendline 00:22 Demo - B-2: Creating a Trendline 00:43 Inserting Sparklines 00:48 Sparklines in a Worksheet 00:24 Demo - B-3: Inserting Sparklines 01:39 Downloading a Chart Template 01:44 Topic C: Graphical Elements 00:07 Adding Shapes to Charts 00:20 Demo - C-1: Adding Graphical Elements 02:31 Formatting Graphical Elements 00:25 Demo - C-2: Formatting a Graphical Element 01:15 Inserting a Picture from a File 00:26 Demo - C-3: Adding a Picture to a Worksheet 00:56 The Adjust Group 02:09 Demo - C-4: Modifying a Picture 02:30 Unit 07 Review 00:20 Review - Question 5 questions Unit 08 - Documenting and Auditing 31 lectures • 27min Documenting and Auditing 00:27 Topic A: Auditing Features 00:05 Dependent and Precedent Cells 00:29 Demo - A-1: Tracing Precedent and Dependent Cells 02:17 Tracing Errors in a Worksheet 00:16 Demo - A-2: Tracing Errors 01:22 Topic B: Comments in Cells and Workbooks 00:06 Viewing Comments 00:25 Demo - B-1: Viewing Comments in a Worksheet 01:02 Adding Cell Comments 00:13 Demo - B-2: Adding a Comment to a Cell 01:57 The Document Panel 00:35 Topic C: Protection 00:06 Password-Protect a Worksheet 00:25 Demo - C-1: Password-Protecting a Worksheet 01:42 Protect Parts of a Worksheet 00:46 Demo - C-2: Unlocking Cells and Protecting Part of a Worksheet 01:05 Protect the Workbook Structure 01:09 Demo - C-3: Protecting the Workbook Structure 02:42 Using Digital Signatures 00:38 Topic D: Workgroup Collaboration 00:10 Sharing a Workbook 00:31 Demo - D-1: Sharing a Workbook 00:47 Share Workbook: Advanced Tab 00:41 Tracking Changes 00:32 Accepting and Rejecting Changes 00:35 Demo - D-3: Tracking Changes in a Workbook 02:01 Using the Document Inspector 01:05 Marking a Workbook as Final 00:33 Demo - D-5: Marking a Workbook as Final 01:41 Unit 08 Review 00:25 Review - Question 5 questions Unit 09 - Templates and Settings 17 lectures • 17min Templates and Settings 00:21 Topic A: Application Settings 00:06 The Excel Options Dialog Box 00:57 Demo - A-1: Changing Application Settings 03:52 The Customize Ribbon Page 00:43 Demo - A-2: Customizing the Ribbon 02:05 Topic B: Built-in Templates 00:07 Available Templates 01:00 Using the Sales Invoice Template 00:22 Demo - B-1: Using a Downloaded Template 02:17 Topic C: Creating and Managing Templates 00:06 Creating a Template 00:38 Demo - C-1: Creating a Template 01:36 Modifying a Template 00:21 Demo - C-2: Modifying a Template 01:36 Using an Alternate Template Location 00:27 Unit 09 Review 00:21 Review - Question 5 questions 1 more section Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. 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:'6781ee6c5a46066a',m:'24617bed935b95a59d2ff2afc83c5f34de4663e8-1627850951-1800-AZ4MHX3nHTpBzyAs+3WEc69lDAD/s2kqcOy09rEGkSrk33cMulRqGwmEBi8fwNrDP88QrJqMezkAYaOyUL2zK0XTkh83MU0j15PYHBnBegIWawtEpQUHt0OM/o5gwiAZbN2TQvsC8SD6DDQx/oCdFhoT1tPThsSVFDbPucyKp3gfEmgWIZADE5HDgD/WHMXc8g==',s:[0x6a5b586e19,0xb17826bfb1],}})();
  • Save workbooks as webpages Learn advanced chart formatting Perform worksheet audit Insert comments in cells and workbooks Use built-in templates Learn about PivotTables and PivotCharts Show more Show less Requirements The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel. In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well. The students should also complete the previous level course before registering for this course. Description The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010. Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks. Who this course is for: Candidates planning to upgrade to Microsoft Office Excel 2010 Candidates responsible to manage and maintain Excel workbooks at their workplaces Accounting and finance professionals University students Show more Show less Course content 11 sections • 245 lectures • 4h 11m total length Expand all sections Introduction 3 lectures • 1min Course Introduction Preview 00:52 Instructor Introduction Preview 00:22 Instructor Introduction A Preview 00:10 Unit 01 - Using Multiple Worksheets and Workbooks 22 lectures • 23min Using Multiple Worksheets and Workbooks Preview 00:20 Topic A: Using Multiple Workbooks Preview 00:05 Switch Between Workbooks Preview 00:23 Demo - A-1: Switching Between Workbooks Preview 01:10 The Move or Copy Dialog Box Preview 01:1