Excel: Core Data Analysis, and Workbook Customization

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

Course Description

You use Excel. You want to use it faster.

Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course.


By the end of this course, you will learn over 70 ways to:

↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks

Learn TIME SAVING Analysis Tools, and FORMULAS

Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks

↳ CONDITIONAL FORMATTING Your Data for Faster Analysis.

Create TABLES, and CHARTS Quickly. Learn About SPARKLINES, and How to Create a SECONDARY AXIS.

See How Easy it is to CREATE PIVOTTABLES

↳ PRINTING Done Right.

Learn to Create Simple MACROS

... MUCH, MUCH MORE


ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User.


Who this course is for:

  • This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016
  • This course is not for anyone who needs to know the basics of Excel, step-by-step.

Expected Outcomes

  1. Exercise Files Included! QUICKLY Navigate Through Your Excel Workbooks SAVE TIME with Keyboard Shortcuts TRACK the Changes Users Make to Your Spreadsheets CREATE a Data Entry Form Fast with Excel's Built-In Form Tool CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  2. QUICKLY Navigate Through Your Excel Workbooks SAVE TIME with Keyboard Shortcuts TRACK the Changes Users Make to Your Spreadsheets CREATE a Data Entry Form Fast with Excel's Built-In Form Tool CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  3. SAVE TIME with Keyboard Shortcuts TRACK the Changes Users Make to Your Spreadsheets CREATE a Data Entry Form Fast with Excel's Built-In Form Tool CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  4. TRACK the Changes Users Make to Your Spreadsheets CREATE a Data Entry Form Fast with Excel's Built-In Form Tool CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  5. CREATE a Data Entry Form Fast with Excel's Built-In Form Tool CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  6. CREATE Functional Tables with a Couple of Keystrokes SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67816142ceaa079e',m:'ea262f6115a9a2f53438085d7ed719cd26fe7dfe-1627845167-1800-Ab++YOYPOWwW2xML4GNglCISnESGxMcnNggeIBfNd2gIAeJKsOmOp4RFEF6Ir5wUgTZ0gAPwaxvkA7JEVe4Ls+fyZjIdX4linA+J8PTcY82eqWXBurdhH1+GSA2SKJrwuCaXcFk/VOQ817YVpWGMWqk=',s:[0xb76dd5097f,0xcbc45b7959],}})();
  7. SORT Data with Your Own Custom Sort Lists QUICKLY Format Your Charts CREATE PivotTables & PivotCharts SET UP Printing the Way You Want PROTECT Your Excel Workbooks CREATE Simple Time-Saving Macros ... and much more! Show more Show less Requirements You should already be familiar with basic navigation in Excel. You should be familiar with concepts like entering data, and how to create charts. Description You use Excel. You want to use it faster. Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course. By the end of this course, you will learn over 70 ways to: ↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks ↳ Learn TIME SAVING Analysis Tools, and FORMULAS ↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks ↳ CONDITIONAL FORMATTING Your Data for Faster Analysis. ↳ Create TABLES , and CHARTS Quickly. Learn About SPARKLINES , and How to Create a SECONDARY AXIS . ↳ See How Easy it is to CREATE PIVOTTABLES ↳ PRINTING Done Right. ↳ Learn to Create Simple MACROS ... MUCH, MUCH MORE ENROLL Right Now, and Join the Over 3,700 Others Who Decided to Become a Better Excel User. Who this course is for: This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016 This course is not for anyone who needs to know the basics of Excel, step-by-step. Show more Show less Course content 14 sections • 87 lectures • 4h 40m total length Expand all sections Latest Excel Time Savers Quick Tip 1 lecture • 1min Quick Keys: Selecting Columns & Rows Preview 00:04 Welcome to Excel: Core Data Analysis, and Workbook Customization 2 lectures • 2min So many questions Preview 01:54 The Exercise Files 00:17 Excel Navigation, Workbook Environment, & Worksheet Skills 23 lectures • 1hr 16min Customizing the Ribbon Preview 09:31 Customizing the Quick Access Toolbar Preview 06:36 Selecting Cells & Ranges 05:50 Moving & Copying Cells 02:22 Copying Multiple Items to Office Clipboard 01:58 Quickly Navigate to Worksheets 01:26 Named Ranges for Navigation 04:53 Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns 06:12 Quickly Insert the Same Data into Multiple Cells 1 page Make Sure Your Headings Stay Put with Freeze Panes 04:04 Splitting Data Into Multiple Columns 02:57 Track, Accept, and Reject Changes Made to Your Workbooks 04:07 Grouping Worksheets to Quickly Add Data 02:32 Copying and Renaming a Worksheet 02:02 Changing a Worksheet Tab Color to Help You Organize Your Workbook 01:33 Entering the Current Date and Time 02:47 Useful Keyboard Shortcuts: Function Keys 2 pages Useful Keyboard Shortcuts: CTRL + 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips 02:54 AutoCorrect: It's More Than Just For Misspelled Words 03:45 Creating Forms Using the Form Command Preview 03:34 The Camera Tool: Take a Picture of the Data You Need to Track 04:43 Changing the Shapes of Comments - Make Your Notes Stand Out. 02:33 Useful Tips on Excel Formulas & Functions 12 lectures • 52min 3D Formulas: Calculate Across Multiple Worksheets 04:24 Absolute Reference: Why You Absolutely Need to Know It Preview 04:11 Named Ranges in Formulas 07:44 SumIf: Sum Your Data Only If It Meets a Condition 04:09 SumIfs: Sum Your Data If It Meets Multiple Conditions 03:04 DSum: Sum Your Data with a Database Dashboard 06:50 VLookup: Learn the Lookup Everyone Is Talking About 08:26 IfError 02:30 Left, Right, Mid: Use Information From Just Certain Parts of Strings 02:52 Find: Quickly Locate Characters 04:37 Rank: Find the Ranked Values of Your Data 02:18 Showing and Printing Formulas 00:50 Using Data Validation for Data Entry in Excel 4 lectures • 11min Creating Drop-Down Lists Preview 02:36 Dependent Drop-Down Lists 03:43 Character Limits for Cells 01:31 Creating Custom Input Messages and Error Alerts 03:32 Special, Custom, and Conditional Formatting in Excel 9 lectures • 27min How Are You Enjoying the Course? 1 page Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes 03:20 Custom Number Formatting: Explained 07:42 Custom Number Formatting: Examples 03:52 Using Custom Formatting to Hide Portions of Your Worksheet 1 page Conditional Formatting 07:28 Conditional Formatting with Quick Analysis 01:22 Conditional Formatting to Just Show Icons or Bars 01:16 Find & Replace with Formatting 02:04 Excel Tables & Lists 5 lectures • 21min Creating Tables 07:23 Slicers: The User-Friendly Way to Filter Your Tables 04:29 Sorting by Custom Lists 03:14 Transposing Data 01:33 Quickly Create Subtotals for Your Lists 04:35 Excel Charts 6 lectures • 15min Keyboard Shortcut & Quick Analysis 01:48 Quick Formatting 02:35 Exploding Pie Charts 01:30 Sparklines: Single Cell Charts 03:56 Combination Charts – Secondary Axis 01:45 Copy a Chart to Word or PowerPoint 03:06 Excel PivotTables & PivotCharts 5 lectures • 21min PivotTables & PivotCharts Overview 03:23 Creating PivotTables 06:37 Creating PivotCharts 01:58 Slicers 05:58 Timelines: Dashboard Filters for Your Date Field 03:24 Printing Excel Data 6 lectures • 13min Print Titles: Repeat Headings on Each Page 01:59 Setting a Print Area 02:07 Fitting Everything On One Page 02:00 Page Breaks 02:38 Hiding Errors 02:09 Watermarks 02:32 4 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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 + '"]');