Ultimate Excel 2016 Bundle (3-Courses: Intro, Interm & Adv)

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

Course Description

Over 200 videos are included in this bundle!

Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes:

  • Excel 2016 Introduction
  • Excel 2016 Intermediate
  • Excel 2016 Advanced

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today.

In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Who this course is for:

  • Anyone who is interested in learning Excel. No previous Excel experience is required.
  • Create Workbooks and Use Templates Work with Formulas Format worksheet Data Work with Named ranges Use Logical and Lookup functions Filter Data Work with Graphs Using IF Statements Using Worksheet Protection Work with PivotTables Use Macros Collaborate in Excel Show more Show less Requirements This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced. Description Over 200 videos are included in this bundle! Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes: Excel 2016 Introduction Excel 2016 Intermediate Excel 2016 Advanced Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Who this course is for: Anyone who is interested in learning Excel. No previous Excel experience is required. Show more Show less Course content 3 sections • 206 lectures • 10h 4m total length Expand all sections Excel 2016 Introduction 67 lectures • 3hr 45min Introduction Preview 01:03 What is Excel? 02:01 Opening Excel 04:25 Navigating the Excel User Interface Preview 07:48 Using the Excel Ribbon 02:55 Understanding Excel Worksheet Components 03:55 Using the Backstage View 02:32 Creating a New Workbook 03:01 Creating Workbooks Using Templates 03:24 Saving an Excel Workbook 05:20 Using Convert and Checking Compatibility 02:19 Navigating a Worksheet by Mouse or Keyboard 04:52 Understanding Excel Data Types 02:50 Working with Cell and Range Addressing 02:20 Using Various Data Selection Techniques 05:14 Working with Common Excel Commands 07:25 Using the Autofill Handle 02:37 What are Formulas and Functions? 02:02 Understanding the Components of a Formula 05:39 Understanding Calculation Hierarchy and the Order of Operations 02:26 Creating Basic Formulas Preview 08:09 Working with Basic Functions and AutoSum 03:59 Using Cell References 03:37 Using the Quick Analysis Tool 01:15 Modifying Columns and Rows 06:08 Hiding and Unhiding Columns and Rows 03:06 Formatting and Aligning Data 05:47 Merging Data 03:52 Wrapping Text and Adjusting Orientation 01:45 Formatting Numbers 03:10 Using Borders and Shading 02:37 Using the Format Painter 01:21 Removing Formatting Quickly 01:24 Understanding Cell Styles 01:38 Applying Cell Styles 04:23 Applying Themes 03:13 Inserting and Formatting Images 02:46 Inserting and Formatting Shapes 04:27 Inserting and Formatting SmartArt 03:47 Inserting Screenshots 02:17 Inserting Hyperlinks 02:37 Inserting Symbols and Equations 03:13 Inserting WordArt and Text Boxes 03:50 Inserting Other Excel Objects 03:53 Arranging Objects 03:47 Using Find and Replace 03:43 Finding and Replacing Formatting 01:19 Using Go To and Go To Special 02:23 Using the Spell Checker 02:34 Using the Thesaurus and Translation Features 03:04 Printing and Previewing Excel Files 02:57 Creating Custom Margins and Scaling 04:53 Adding Headers and Footers 03:40 Formatting a Page with the Page Layout Tab 02:34 Printing Titles and Specific Worksheet Areas 04:31 Exporting to PDF and XPS 01:36 Renaming and Coloring Worksheet Tabs 02:34 Adding, Deleting, and Navigating Worksheets 03:29 Moving and Copying Worksheets 03:44 Hiding and Unhiding Worksheets 02:11 Viewing Workbooks 02:44 Using Zoom Tools 02:13 Configuring Sheet Options 02:16 Using the Freeze Panes and Split Commands 04:49 Working with Window Commands 03:41 Adjusting Workbook Properties Preview 02:42 Course Recap 01:42 Excel 2016 Intermediate 75 lectures • 4hr 1min Introduction Preview 01:24 Customizing the Ribbon 06:09 Customizing the Quick Access Toolbar 03:46 Customizing the General and Formula Options 02:28 Customizing the AutoCorrect Options 03:31 Customizing the Save Defaults 02:25 Customizing Advanced Excel Options 02:49 Linking Workbooks and Worksheets 04:55 Linking Worksheets with 3D References 02:54 Understanding the Consolidate Feature 04:44 What are Range Names? 02:43 Creating Range Names Using the Name Box and Define Name 06:46 Creating Range Names Using Create from Selection 02:39 Working with the Most Common Logical Functions 02:31 Evaluating Data with the AND Function 03:15 Evaluating Data with the OR Function 03:07 Understanding IF Functions 04:19 Nesting AND and OR Inside an IF Function 05:57 What are Lookup Functions? 01:41 Using VLOOKUP 07:39 Using HLOOKUP Preview 02:22 Understanding the Differences Between Sorting and Filtering 01:43 Sorting Lists 03:49 Filtering Lists 03:18 Creating Tables and Understanding the Benefits 02:28 Understanding the Elements of a Table Preview 02:38 Formatting a Table 02:36 Sorting Tables 02:05 Filtering Tables 02:38 Filtering with Slicers 02:49 Calculating with Tables 03:42 Removing Erroneous Table Data 02:08 Exporting, Refreshing, and Converting Tables 02:06 What is Conditional Formatting? 01:18 Conditional Formatting: Highlight Cells and Top Bottom Rules 04:23 Conditional Formatting: Data Bars, Icon Sets, and Color Scales 03:55 Using Custom Fonts and Colors 02:15 Using Custom Conditional Formatting 02:46 Modifying or Removing Conditional Formatting 02:04 What are Subtotals and Grouping? 01:06 Creating Subtotals 03:00 Grouping and Ungrouping Data 02:02 What are Charts? 03:42 Creating Charts 04:02 Understanding Chart Elements 02:57 Modifying Chart Elements 07:24 Changing and Moving Charts 03:42 Filtering a Chart 02:25 Formatting Charts 06:44 Adjusting Numbering 03:19 Creating Dual Axis Charts 02:14 Forecasting with Trendlines 04:30 Creating a Chart Template 01:10 Displaying Trends with Sparklines 04:18 What is a PivotTable? 03:57 Creating a PivotTable 02:56 Working with the PivotTable Fields Pane 06:44 Basic Data Organization and Analysis with PivotTables 03:42 Formatting PivotTables 05:31 Creating a PivotChart 03:33 Modifying and Formatting a PivotChart 03:13 Adding Slicers and Timeline Slicers 03:28 Formatting Slicers 03:01 What is Flash Fill? 01:12 Using Flash Fill and Autofill 02:41 Filling Various Series 04:20 What are Date and Time Functions? 01:31 Using TODAY, NOW, and DAY Functions 02:04 Using NETWORKDAYS and YEARFRAC Functions 02:23 What are Text Functions? Preview 00:57 Using CONCATENATE 02:35 Using Text to Columns 02:26 Using LEFT, RIGHT, and MID Functions 01:59 Using UPPER, LOWER, and PROPER Functions 01:39 Course Recap 01:32 Excel 2016 Advanced 64 lectures • 2hr 19min Introduction Preview 01:04 Summarizing Data with SUMIF 04:27 Summarizing Data with AVERAGEIF 02:35 Summarizing Data with COUNTIF 01:52 Using VLOOKUP with TRUE 03:40 Using HLOOKUP with TRUE 01:22 Using the INDEX Function 03:09 Using the MATCH Function 02:14 Combining INDEX and MATCH 04:09 Comparing Two Lists with VLOOKUP Preview 01:42 Comparing Two Lists with VLOOKUP and ISNA 03:47 Creating a Nested IF Function 02:53 Using the IFERROR Function 02:15 Using the LEN Function 02:07 Using the TRIM Function 01:03 Using the SUBSTITUTE Function 02:22 Showing Formulas 01:01 Tracing Precedents and Dependents 02:33 Adding a Watch Window Preview 02:16 Error Checking 01:55 Using the Scenario Manager 03:20 Using Goal Seek 01:43 Analyzing with Data Tables 02:28 Understanding Protection 01:53 Encrypting Files with Passwords 02:35 Allowing Specific Worksheet Changes 01:27 Adding Protection to Selected Cells 02:48 Additional Protection Features 01:45 Using the PivotTable and PivotChart Wizard 02:02 Adding a Calculated Field 01:33 Adding a Calculated Item 01:43 Applying Conditional Formatting to a PivotTable 02:35 Using Filters in a PivotTable 01:42 Creating Filter Pages for a PivotTable 01:16 Enabling the PowerPivot Add-In 03:59 What are Macros? 02:37 Displaying the Developer Tab 02:41 Creating a Basic Formatting Macro 02:58 Running a Macro 01:32 Assigning a Macro to a Button 02:07 Creating Complex Macros 02:29 Viewing and Editing the VBA Code 02:37 Adding a Macro to the Quick Access Toolbar 01:49 What are Form Controls? 01:44 Adding Spin Buttons and Check Boxes 02:04 Adding a Combo Box 01:42 What is Data Validation? 01:26 Restricting Data Entry to Whole Numbers 01:33 Restricting Data Entry to a List 01:07 Restricting Data Entry to a Date 01:15 Restricting Data Entry to Specific Text Lengths 01:23 Composing Input Messages 01:36 Composing Error Alerts 02:00 Finding Invalid Data 01:56 Editing and Deleting Data Validation Rules 00:57 Working with Comments 03:04 Printing Comments and Errors 01:45 Sharing a Workbook 03:21 Tracking Changes in a Workbook 02:35 Working with Versions 01:59 Sharing Files via Email 01:51 Importing a Text File 02:44 Exporting Data to a Text File 01:16 Course Recap 01:14 Instructor Intellezy Trainers Computer Training Specialists 4.4 Instructor Rating 46,753 Reviews 164,595 Students 246 Courses Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them. 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:'6781e6f13dcace4b',m:'ced9a9f1a7749b6ca4fc46a5b94e160b311e1393-1627850644-1800-AeKlIZ5x7bM9R1+MZ736CpWCm5y+Zn2w2XP9p/yC/MWzzBHMohZhKo6iSzY19R/2dTdHhgL2nYd4rHFcDAg4vojf03BizjjERndPANDsCHGdNMpv227bZGoqLaSx3DrNOgaJfQcQFCP25DUSQwLfhkSK+iUTLgt9eGVSFHbH8olSN50dkK4fANvCXwiZWIgjng==',s:[0xa30c068767,0x8e00010db3],}})();
  • Work with Formulas Format worksheet Data Work with Named ranges Use Logical and Lookup functions Filter Data Work with Graphs Using IF Statements Using Worksheet Protection Work with PivotTables Use Macros Collaborate in Excel Show more Show less Requirements This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced. Description Over 200 videos are included in this bundle! Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes: Excel 2016 Introduction Excel 2016 Intermediate Excel 2016 Advanced Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Who this course is for: Anyone who is interested in learning Excel. No previous Excel experience is required. Show more Show less Course content 3 sections • 206 lectures • 10h 4m total length Expand all sections Excel 2016 Introduction 67 lectures • 3hr 45min Introduction Preview 01:03 What is Excel? 02:01 Opening Excel 04:25 Navigating the Excel User Interface Preview 07:48 Using the Excel Ribbon 02:55 Understanding Excel Worksheet Components 03:55 Using the Backstage View 02:32 Creating a New Workbook 03:01 Creating Workbooks Using Templates 03:24 Saving an Excel Workbook 05:20 Using Convert and Checking Compatibility 02:19 Navigating a Worksheet by Mouse or Keyboard 04:52 Understanding Excel Data Types 02:50 Working with Cell and Range Addressing 02:20 Using Various Data Selection Techniques 05:14 Working with Common Excel Commands 07:25 Using the Autofill Handle 02:37 What are Formulas and Functions? 02:02 Understanding the Components of a Formula 05:39 Understanding Calculation Hierarchy and the Order of Operations 02:26 Creating Basic Formulas Preview 08:09 Working with Basic Functions and AutoSum 03:59 Using Cell References 03:37 Using the Quick Analysis Tool 01:15 Modifying Columns and Rows 06:08 Hiding and Unhiding Columns and Rows 03:06 Formatting and Aligning Data 05:47 Merging Data 03:52 Wrapping Text and Adjusting Orientation 01:45 Formatting Numbers 03:10 Using Borders and Shading 02:37 Using the Format Painter 01:21 Removing Formatting Quickly 01:24 Understanding Cell Styles 01:38 Applying Cell Styles 04:23 Applying Themes 03:13 Inserting and Formatting Images 02:46 Inserting and Formatting Shapes 04:27 Inserting and Formatting SmartArt 03:47 Inserting Screenshots 02:17 Inserting Hyperlinks 02:37 Inserting Symbols and Equations 03:13 Inserting WordArt and Text Boxes 03:50 Inserting Other Excel Objects 03:53 Arranging Objects 03:47 Using Find and Replace 03:43 Finding and Replacing Formatting 01:19 Using Go To and Go To Special 02:23 Using the Spell Checker 02:34 Using the Thesaurus and Translation Features 03:04 Printing and Previewing Excel Files 02:57 Creating Custom Margins and Scaling 04:53 Adding Headers and Footers 03:40 Formatting a Page with the Page Layout Tab 02:34 Printing Titles and Specific Worksheet Areas 04:31 Exporting to PDF and XPS 01:36 Renaming and Coloring Worksheet Tabs 02:34 Adding, Deleting, and Navigating Worksheets 03:29 Moving and Copying Worksheets 03:44 Hiding and Unhiding Worksheets 02:11 Viewing Workbooks 02:44 Using Zoom Tools 02:13 Configuring Sheet Options 02:16 Using the Freeze Panes and Split Commands 04:49 Working with Window Commands 03:41 Adjusting Workbook Properties Preview 02:42 Course Recap 01:42 Excel 2016 Intermediate 75 lectures • 4hr 1min Introduction Preview 01:24 Customizing the Ribbon 06:09 Customizing the Quick Access Toolbar 03:46 Customizing the General and Formula Options 02:28 Customizing the AutoCorrect Options 03:31 Customizing the Save Defaults 02:25 Customizing Advanced Excel Options 02:49 Linking Workbooks and Worksheets 04:55 Linking Worksheets with 3D References 02:54 Understanding the Consolidate Feature 04:44 What are Range Names? 02:43 Creating Range Names Using the Name Box and Define Name 06:46 Creating Range Names Using Create from Selection 02:39 Working with the Most Common Logical Functions 02:31 Evaluating Data with the AND Function 03:15 Evaluating Data with the OR Function 03:07 Understanding IF Functions 04:19 Nesting AND and OR Inside an IF Function 05:57 What are Lookup Functions? 01:41 Using VLOOKUP 07:39 Using HLOOKUP Preview 02:22 Understanding the Differences Between Sorting and Filtering 01:43 Sorting Lists 03:49 Filtering Lists 03:18 Creating Tables and Understanding the Benefits 02:28 Understanding the Elements of a Table Preview 02:38 Formatting a Table 02:36 Sorting Tables 02:05 Filtering Tables 02:38 Filtering with Slicers 02:49 Calculating with Tables 03:42 Removing Erroneous Table Data 02:08 Exporting, Refreshing, and Converting Tables 02:06 What is Conditional Formatting? 01:18 Conditional Formatting: Highlight Cells and Top Bottom Rules 04:23 Conditional Formatting: Data Bars, Icon Sets, and Color Scales 03:55 Using Custom Fonts and Colors 02:15 Using Custom Conditional Formatting 02:46 Modifying or Removing Conditional Formatting 02:04 What are Subtotals and Grouping? 01:06 Creating Subtotals 03:00 Grouping and Ungrouping Data 02:02 What are Charts? 03:42 Creating Charts 04:02 Understanding Chart Elements 02:57 Modifying Chart Elements 07:24 Changing and Moving Charts 03:42 Filtering a Chart 02:25 Formatting Charts 06:44 Adjusting Numbering 03:19 Creating Dual Axis Charts 02:14 Forecasting with Trendlines 04:30 Creating a Chart Template 01:10 Displaying Trends with Sparklines 04:18 What is a PivotTable? 03:57 Creating a PivotTable 02:56 Working with the PivotTable Fields Pane 06:44 Basic Data Organization and Analysis with PivotTables 03:42 Formatting PivotTables 05:31 Creating a PivotChart 03:33 Modifying and Formatting a PivotChart 03:13 Adding Slicers and Timeline Slicers 03:28 Formatting Slicers 03:01 What is Flash Fill? 01:12 Using Flash Fill and Autofill 02:41 Filling Various Series 04:20 What are Date and Time Functions? 01:31 Using TODAY, NOW, and DAY Functions 02:04 Using NETWORKDAYS and YEARFRAC Functions 02:23 What are Text Functions? Preview 00:57 Using CONCATENATE 02:35 Using Text to Columns 02:26 Using LEFT, RIGHT, and MID Functions 01:59 Using UPPER, LOWER, and PROPER Functions 01:39 Course Recap 01:32 Excel 2016 Advanced 64 lectures • 2hr 19min Introduction Preview 01:04 Summarizing Data with SUMIF 04:27 Summarizing Data with AVERAGEIF 02:35 Summarizing Data with COUNTIF 01:52 Using VLOOKUP with TRUE 03:40 Using HLOOKUP with TRUE 01:22 Using the INDEX Function 03:09 Using the MATCH Function 02:14 Combining INDEX and MATCH 04:09 Comparing Two Lists with VLOOKUP Preview 01:42 Comparing Two Lists with VLOOKUP and ISNA 03:47 Creating a Nested IF Function 02:53 Using the IFERROR Function 02:15 Using the LEN Function 02:07 Using the TRIM Function 01:03 Using the SUBSTITUTE Function 02:22 Showing Formulas 01:01 Tracing Precedents and Dependents 02:33 Adding a Watch Window Preview 02:16 Error Checking 01:55 Using the Scenario Manager 03:20 Using Goal Seek 01:43 Analyzing with Data Tables 02:28 Understanding Protection 01:53 Encrypting Files with Passwords 02:35 Allowing Specific Worksheet Changes 01:27 Adding Protection to Selected Cells 02:48 Additional Protection Features 01:45 Using the PivotTable and PivotChart Wizard 02:02 Adding a Calculated Field 01:33 Adding a Calculated Item 01:43 Applying Conditional Formatting to a PivotTable 02:35 Using Filters in a PivotTable 01:42 Creating Filter Pages for a PivotTable 01:16 Enabling the PowerPivot Add-In 03:59 What are Macros? 02:37 Displaying the Developer Tab 02:41 Creating a Basic Formatting Macro 02:58 Running a Macro 01:32 Assigning a Macro to a Button 02:07 Creating Complex Macros 02:29 Viewing and Editing the VBA Code 02:37 Adding a Macro to the Quick Access Toolbar 01:49 What are Form Controls? 01:44 Adding Spin Buttons and Check Boxes 02:04 Adding a Combo Box 01:42 What is Data Validation? 01:26 Restricting Data Entry to Whole Numbers 01:33 Restricting Data Entry to a List 01:07 Restricting Data Entry to a Date 01:15 Restricting Data Entry to Specific Text Lengths 01:23 Composing Input Messages 01:36 Composing Error Alerts 02:00 Finding Invalid Data 01:56 Editing and Deleting Data Validation Rules 00:57 Working with Comments 03:04 Printing Comments and Errors 01:45 Sharing a Workbook 03:21 Tracking Changes in a Workbook 02:35 Working with Versions 01:59 Sharing Files via Email 01:51 Importing a Text File 02:44 Exporting Data to a Text File 01:16 Course Recap 01:14 Instructor Intellezy Trainers Computer Training Specialists 4.4 Instructor Rating 46,753 Reviews 164,595 Students 246 Courses Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them. 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:'6781e6f13dcace4b',m:'ced9a9f1a7749b6ca4fc46a5b94e160b311e1393-1627850644-1800-AeKlIZ5x7bM9R1+MZ736CpWCm5y+Zn2w2XP9p/yC/MWzzBHMohZhKo6iSzY19R/2dTdHhgL2nYd4rHFcDAg4vojf03BizjjERndPANDsCHGdNMpv227bZGoqLaSx3DrNOgaJfQcQFCP25DUSQwLfhkSK+iUTLgt9eGVSFHbH8olSN50dkK4fANvCXwiZWIgjng==',s:[0xa30c068767,0x8e00010db3],}})();
  • Format worksheet Data Work with Named ranges Use Logical and Lookup functions Filter Data Work with Graphs Using IF Statements Using Worksheet Protection Work with PivotTables Use Macros Collaborate in Excel Show more Show less Requirements This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced. Description Over 200 videos are included in this bundle! Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes: Excel 2016 Introduction Excel 2016 Intermediate Excel 2016 Advanced Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Who this course is for: Anyone who is interested in learning Excel. No previous Excel experience is required. Show more Show less Course content 3 sections • 206 lectures • 10h 4m total length Expand all sections Excel 2016 Introduction 67 lectures • 3hr 45min Introduction Preview 01:03 What is Excel? 02:01 Opening Excel 04:25 Navigating the Excel User Interface Preview 07:48 Using the Excel Ribbon 02:55 Understanding Excel Worksheet Components 03:55 Using the Backstage View 02:32 Creating a New Workbook 03:01 Creating Workbooks Using Templates 03:24 Saving an Excel Workbook 05:20 Using Convert and Checking Compatibility 02:19 Navigating a Worksheet by Mouse or Keyboard 04:52 Understanding Excel Data Types 02:50 Working with Cell and Range Addressing 02:20 Using Various Data Selection Techniques 05:14 Working with Common Excel Commands 07:25 Using the Autofill Handle 02:37 What are Formulas and Functions? 02:02 Understanding the Components of a Formula 05:39 Understanding Calculation Hierarchy and the Order of Operations 02:26 Creating Basic Formulas Preview 08:09 Working with Basic Functions and AutoSum 03:59 Using Cell References 03:37 Using the Quick Analysis Tool 01:15 Modifying Columns and Rows 06:08 Hiding and Unhiding Columns and Rows 03:06 Formatting and Aligning Data 05:47 Merging Data 03:52 Wrapping Text and Adjusting Orientation 01:45 Formatting Numbers 03:10 Using Borders and Shading 02:37 Using the Format Painter 01:21 Removing Formatting Quickly 01:24 Understanding Cell Styles 01:38 Applying Cell Styles 04:23 Applying Themes 03:13 Inserting and Formatting Images 02:46 Inserting and Formatting Shapes 04:27 Inserting and Formatting SmartArt 03:47 Inserting Screenshots 02:17 Inserting Hyperlinks 02:37 Inserting Symbols and Equations 03:13 Inserting WordArt and Text Boxes 03:50 Inserting Other Excel Objects 03:53 Arranging Objects 03:47 Using Find and Replace 03:43 Finding and Replacing Formatting 01:19 Using Go To and Go To Special 02:23 Using the Spell Checker 02:34 Using the Thesaurus and Translation Features 03:04 Printing and Previewing Excel Files 02:57 Creating Custom Margins and Scaling 04:53 Adding Headers and Footers 03:40 Formatting a Page with the Page Layout Tab 02:34 Printing Titles and Specific Worksheet Areas 04:31 Exporting to PDF and XPS 01:36 Renaming and Coloring Worksheet Tabs 02:34 Adding, Deleting, and Navigating Worksheets 03:29 Moving and Copying Worksheets 03:44 Hiding and Unhiding Worksheets 02:11 Viewing Workbooks 02:44 Using Zoom Tools 02:13 Configuring Sheet Options 02:16 Using the Freeze Panes and Split Commands 04:49 Working with Window Commands 03:41 Adjusting Workbook Properties Preview 02:42 Course Recap 01:42 Excel 2016 Intermediate 75 lectures • 4hr 1min Introduction Preview 01:24 Customizing the Ribbon 06:09 Customizing the Quick Access Toolbar 03:46 Customizing the General and Formula Options 02:28 Customizing the AutoCorrect Options 03:31 Customizing the Save Defaults 02:25 Customizing Advanced Excel Options 02:49 Linking Workbooks and Worksheets 04:55 Linking Worksheets with 3D References 02:54 Understanding the Consolidate Feature 04:44 What are Range Names? 02:43 Creating Range Names Using the Name Box and Define Name 06:46 Creating Range Names Using Create from Selection 02:39 Working with the Most Common Logical Functions 02:31 Evaluating Data with the AND Function 03:15 Evaluating Data with the OR Function 03:07 Understanding IF Functions 04:19 Nesting AND and OR Inside an IF Function 05:57 What are Lookup Functions? 01:41 Using VLOOKUP 07:39 Using HLOOKUP Preview 02:22 Understanding the Differences Between Sorting and Filtering 01:43 Sorting Lists 03:49 Filtering Lists 03:18 Creating Tables and Understanding the Benefits 02:28 Understanding the Elements of a Table Preview 02:38 Formatting a Table 02:36 Sorting Tables 02:05 Filtering Tables 02:38 Filtering with Slicers 02:49 Calculating with Tables 03:42 Removing Erroneous Table Data 02:08 Exporting, Refreshing, and Converting Tables 02:06 What is Conditional Formatting? 01:18 Conditional Formatting: Highlight Cells and Top Bottom Rules 04:23 Conditional Formatting: Data Bars, Icon Sets, and Color Scales 03:55 Using Custom Fonts and Colors 02:15 Using Custom Conditional Formatting 02:46 Modifying or Removing Conditional Formatting 02:04 What are Subtotals and Grouping? 01:06 Creating Subtotals 03:00 Grouping and Ungrouping Data 02:02 What are Charts? 03:42 Creating Charts 04:02 Understanding Chart Elements 02:57 Modifying Chart Elements 07:24 Changing and Moving Charts 03:42 Filtering a Chart 02:25 Formatting Charts 06:44 Adjusting Numbering 03:19 Creating Dual Axis Charts 02:14 Forecasting with Trendlines 04:30 Creating a Chart Template 01:10 Displaying Trends with Sparklines 04:18 What is a PivotTable? 03:57 Creating a PivotTable 02:56 Working with the PivotTable Fields Pane 06:44 Basic Data Organization and Analysis with PivotTables 03:42 Formatting PivotTables 05:31 Creating a PivotChart 03:33 Modifying and Formatting a PivotChart 03:13 Adding Slicers and Timeline Slicers 03:28 Formatting Slicers 03:01 What is Flash Fill? 01:12 Using Flash Fill and Autofill 02:41 Filling Various Series 04:20 What are Date and Time Functions? 01:31 Using TODAY, NOW, and DAY Functions 02:04 Using NETWORKDAYS and YEARFRAC Functions 02:23 What are Text Functions? Preview 00:57 Using CONCATENATE 02:35 Using Text to Columns 02:26 Using LEFT, RIGHT, and MID Functions 01:59 Using UPPER, LOWER, and PROPER Functions 01:39 Course Recap 01:32 Excel 2016 Advanced 64 lectures • 2hr 19min Introduction Preview 01:04 Summarizing Data with SUMIF 04:27 Summarizing Data with AVERAGEIF 02:35 Summarizing Data with COUNTIF 01:52 Using VLOOKUP with TRUE 03:40 Using HLOOKUP with TRUE 01:22 Using the INDEX Function 03:09 Using the MATCH Function 02:14 Combining INDEX and MATCH 04:09 Comparing Two Lists with VLOOKUP Preview 01:42 Comparing Two Lists with VLOOKUP and ISNA 03:47 Creating a Nested IF Function 02:53 Using the IFERROR Function 02:15 Using the LEN Function 02:07 Using the TRIM Function 01:03 Using the SUBSTITUTE Function 02:22 Showing Formulas 01:01 Tracing Precedents and Dependents 02:33 Adding a Watch Window Preview 02:16 Error Checking 01:55 Using the Scenario Manager 03:20 Using Goal Seek 01:43 Analyzing with Data Tables 02:28 Understanding Protection 01:53 Encrypting Files with Passwords 02:35 Allowing Specific Worksheet Changes 01:27 Adding Protection to Selected Cells 02:48 Additional Protection Features 01:45 Using the PivotTable and PivotChart Wizard 02:02 Adding a Calculated Field 01:33 Adding a Calculated Item 01:43 Applying Conditional Formatting to a PivotTable 02:35 Using Filters in a PivotTable 01:42 Creating Filter Pages for a PivotTable 01:16 Enabling the PowerPivot Add-In 03:59 What are Macros? 02:37 Displaying the Developer Tab 02:41 Creating a Basic Formatting Macro 02:58 Running a Macro 01:32 Assigning a Macro to a Button 02:07 Creating Complex Macros 02:29 Viewing and Editing the VBA Code 02:37 Adding a Macro to the Quick Access Toolbar 01:49 What are Form Controls? 01:44 Adding Spin Buttons and Check Boxes 02:04 Adding a Combo Box 01:42 What is Data Validation? 01:26 Restricting Data Entry to Whole Numbers 01:33 Restricting Data Entry to a List 01:07 Restricting Data Entry to a Date 01:15 Restricting Data Entry to Specific Text Lengths 01:23 Composing Input Messages 01:36 Composing Error Alerts 02:00 Finding Invalid Data 01:56 Editing and Deleting Data Validation Rules 00:57 Working with Comments 03:04 Printing Comments and Errors 01:45 Sharing a Workbook 03:21 Tracking Changes in a Workbook 02:35 Working with Versions 01:59 Sharing Files via Email 01:51 Importing a Text File 02:44 Exporting Data to a Text File 01:16 Course Recap 01:14 Instructor Intellezy Trainers Computer Training Specialists 4.4 Instructor Rating 46,753 Reviews 164,595 Students 246 Courses Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them. 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:'6781e6f13dcace4b',m:'ced9a9f1a7749b6ca4fc46a5b94e160b311e1393-1627850644-1800-AeKlIZ5x7bM9R1+MZ736CpWCm5y+Zn2w2XP9p/yC/MWzzBHMohZhKo6iSzY19R/2dTdHhgL2nYd4rHFcDAg4vojf03BizjjERndPANDsCHGdNMpv227bZGoqLaSx3DrNOgaJfQcQFCP25DUSQwLfhkSK+iUTLgt9eGVSFHbH8olSN50dkK4fANvCXwiZWIgjng==',s:[0xa30c068767,0x8e00010db3],}})();
  • Work with Named ranges Use Logical and Lookup functions Filter Data Work with Graphs Using IF Statements Using Worksheet Protection Work with PivotTables Use Macros Collaborate in Excel Show more Show less Requirements This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced. Description Over 200 videos are included in this bundle! Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes: Excel 2016 Introduction Excel 2016 Intermediate Excel 2016 Advanced Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Who this course is for: Anyone who is interested in learning Excel. No previous Excel experience is required. Show more Show less Course content 3 sections • 206 lectures • 10h 4m total length Expand all sections Excel 2016 Introduction 67 lectures • 3hr 45min Introduction Preview 01:03 What is Excel? 02:01 Opening Excel 04:25 Navigating the Excel User Interface Preview 07:48 Using the Excel Ribbon 02:55 Understanding Excel Worksheet Components 03:55 Using the Backstage View 02:32 Creating a New Workbook 03:01 Creating Workbooks Using Templates 03:24 Saving an Excel Workbook 05:20 Using Convert and Checking Compatibility 02:19 Navigating a Worksheet by Mouse or Keyboard 04:52 Understanding Excel Data Types 02:50 Working with Cell and Range Addressing 02:20 Using Various Data Selection Techniques 05:14 Working with Common Excel Commands 07:25 Using the Autofill Handle 02:37 What are Formulas and Functions? 02:02 Understanding the Components of a Formula 05:39 Understanding Calculation Hierarchy and the Order of Operations 02:26 Creating Basic Formulas Preview 08:09 Working with Basic Functions and AutoSum 03:59 Using Cell References 03:37 Using the Quick Analysis Tool 01:15 Modifying Columns and Rows 06:08 Hiding and Unhiding Columns and Rows 03:06 Formatting and Aligning Data 05:47 Merging Data 03:52 Wrapping Text and Adjusting Orientation 01:45 Formatting Numbers 03:10 Using Borders and Shading 02:37 Using the Format Painter 01:21 Removing Formatting Quickly 01:24 Understanding Cell Styles 01:38 Applying Cell Styles 04:23 Applying Themes 03:13 Inserting and Formatting Images 02:46 Inserting and Formatting Shapes 04:27 Inserting and Formatting SmartArt 03:47 Inserting Screenshots 02:17 Inserting Hyperlinks 02:37 Inserting Symbols and Equations 03:13 Inserting WordArt and Text Boxes 03:50 Inserting Other Excel Objects 03:53 Arranging Objects 03:47 Using Find and Replace 03:43 Finding and Replacing Formatting 01:19 Using Go To and Go To Special 02:23 Using the Spell Checker 02:34 Using the Thesaurus and Translation Features 03:04 Printing and Previewing Excel Files 02:57 Creating Custom Margins and Scaling 04:53 Adding Headers and Footers 03:40 Formatting a Page with the Page Layout Tab 02:34 Printing Titles and Specific Worksheet Areas 04:31 Exporting to PDF and XPS 01:36 Renaming and Coloring Worksheet Tabs 02:34 Adding, Deleting, and Navigating Worksheets 03:29 Moving and Copying Worksheets 03:44 Hiding and Unhiding Worksheets 02:11 Viewing Workbooks 02:44 Using Zoom Tools 02:13 Configuring Sheet Options 02:16 Using the Freeze Panes and Split Commands 04:49 Working with Window Commands 03:41 Adjusting Workbook Properties Preview 02:42 Course Recap 01:42 Excel 2016 Intermediate 75 lectures • 4hr 1min Introduction Preview 01:24 Customizing the Ribbon 06:09 Customizing the Quick Access Toolbar 03:46 Customizing the General and Formula Options 02:28 Customizing the AutoCorrect Options 03:31 Customizing the Save Defaults 02:25 Customizing Advanced Excel Options 02:49 Linking Workbooks and Worksheets 04:55 Linking Worksheets with 3D References 02:54 Understanding the Consolidate Feature 04:44 What are Range Names? 02:43 Creating Range Names Using the Name Box and Define Name 06:46 Creating Range Names Using Create from Selection 02:39 Working with the Most Common Logical Functions 02:31 Evaluating Data with the AND Function 03:15 Evaluating Data with the OR Function 03:07 Understanding IF Functions 04:19 Nesting AND and OR Inside an IF Function 05:57 What are Lookup Functions? 01:41 Using VLOOKUP 07:39 Using HLOOKUP Preview 02:22 Understanding the Differences Between Sorting and Filtering 01:43 Sorting Lists 03:49 Filtering Lists 03:18 Creating Tables and Understanding the Benefits 02:28 Understanding the Elements of a Table Preview 02:38 Formatting a Table 02:36 Sorting Tables 02:05 Filtering Tables 02:38 Filtering with Slicers 02:49 Calculating with Tables 03:42 Removing Erroneous Table Data 02:08 Exporting, Refreshing, and Converting Tables 02:06 What is Conditional Formatting? 01:18 Conditional Formatting: Highlight Cells and Top Bottom Rules 04:23 Conditional Formatting: Data Bars, Icon Sets, and Color Scales 03:55 Using Custom Fonts and Colors 02:15 Using Custom Conditional Formatting 02:46 Modifying or Removing Conditional Formatting 02:04 What are Subtotals and Grouping? 01:06 Creating Subtotals 03:00 Grouping and Ungrouping Data 02:02 What are Charts? 03:42 Creating Charts 04:02 Understanding Chart Elements 02:57 Modifying Chart Elements 07:24 Changing and Moving Charts 03:42 Filtering a Chart 02:25 Formatting Charts 06:44 Adjusting Numbering 03:19 Creating Dual Axis Charts 02:14 Forecasting with Trendlines 04:30 Creating a Chart Template 01:10 Displaying Trends with Sparklines 04:18 What is a PivotTable? 03:57 Creating a PivotTable 02:56 Working with the PivotTable Fields Pane 06:44 Basic Data Organization and Analysis with PivotTables 03:42 Formatting PivotTables 05:31 Creating a PivotChart 03:33 Modifying and Formatting a PivotChart 03:13 Adding Slicers and Timeline Slicers 03:28 Formatting Slicers 03:01 What is Flash Fill? 01:12 Using Flash Fill and Autofill 02:41 Filling Various Series 04:20 What are Date and Time Functions? 01:31 Using TODAY, NOW, and DAY Functions 02:04 Using NETWORKDAYS and YEARFRAC Functions 02:23 What are Text Functions? Preview 00:57 Using CONCATENATE 02:35 Using Text to Columns 02:26 Using LEFT, RIGHT, and MID Functions 01:59 Using UPPER, LOWER, and PROPER Functions 01:39 Course Recap 01:32 Excel 2016 Advanced 64 lectures • 2hr 19min Introduction Preview 01:04 Summarizing Data with SUMIF 04:27 Summarizing Data with AVERAGEIF 02:35 Summarizing Data with COUNTIF 01:52 Using VLOOKUP with TRUE 03:40 Using HLOOKUP with TRUE 01:22 Using the INDEX Function 03:09 Using the MATCH Function 02:14 Combining INDEX and MATCH 04:09 Comparing Two Lists with VLOOKUP Preview 01:42 Comparing Two Lists with VLOOKUP and ISNA 03:47 Creating a Nested IF Function 02:53 Using the IFERROR Function 02:15 Using the LEN Function 02:07 Using the TRIM Function 01:03 Using the SUBSTITUTE Function 02:22 Showing Formulas 01:01 Tracing Precedents and Dependents 02:33 Adding a Watch Window Preview 02:16 Error Checking 01:55 Using the Scenario Manager 03:20 Using Goal Seek 01:43 Analyzing with Data Tables 02:28 Understanding Protection 01:53 Encrypting Files with Passwords 02:35 Allowing Specific Worksheet Changes 01:27 Adding Protection to Selected Cells 02:48 Additional Protection Features 01:45 Using the PivotTable and PivotChart Wizard 02:02 Adding a Calculated Field 01:33 Adding a Calculated Item 01:43 Applying Conditional Formatting to a PivotTable 02:35 Using Filters in a PivotTable 01:42 Creating Filter Pages for a PivotTable 01:16 Enabling the PowerPivot Add-In 03:59 What are Macros? 02:37 Displaying the Developer Tab 02:41 Creating a Basic Formatting Macro 02:58 Running a Macro 01:32 Assigning a Macro to a Button 02:07 Creating Complex Macros 02:29 Viewing and Editing the VBA Code 02:37 Adding a Macro to the Quick Access Toolbar 01:49 What are Form Controls? 01:44 Adding Spin Buttons and Check Boxes 02:04 Adding a Combo Box 01:42 What is Data Validation? 01:26 Restricting Data Entry to Whole Numbers 01:33 Restricting Data Entry to a List 01:07 Restricting Data Entry to a Date 01:15 Restricting Data Entry to Specific Text Lengths 01:23 Composing Input Messages 01:36 Composing Error Alerts 02:00 Finding Invalid Data 01:56 Editing and Deleting Data Validation Rules 00:57 Working with Comments 03:04 Printing Comments and Errors 01:45 Sharing a Workbook 03:21 Tracking Changes in a Workbook 02:35 Working with Versions 01:59 Sharing Files via Email 01:51 Importing a Text File 02:44 Exporting Data to a Text File 01:16 Course Recap 01:14 Instructor Intellezy Trainers Computer Training Specialists 4.4 Instructor Rating 46,753 Reviews 164,595 Students 246 Courses Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them. 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:'6781e6f13dcace4b',m:'ced9a9f1a7749b6ca4fc46a5b94e160b311e1393-1627850644-1800-AeKlIZ5x7bM9R1+MZ736CpWCm5y+Zn2w2XP9p/yC/MWzzBHMohZhKo6iSzY19R/2dTdHhgL2nYd4rHFcDAg4vojf03BizjjERndPANDsCHGdNMpv227bZGoqLaSx3DrNOgaJfQcQFCP25DUSQwLfhkSK+iUTLgt9eGVSFHbH8olSN50dkK4fANvCXwiZWIgjng==',s:[0xa30c068767,0x8e00010db3],}})();
  • Use Logical and Lookup functions Filter Data Work with Graphs Using IF Statements Using Worksheet Protection Work with PivotTables Use Macros Collaborate in Excel Show more Show less Requirements This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced. Description Over 200 videos are included in this bundle! Save 20% by purchasing 3 Excel 2016 courses, which