Learn Excel in 3 Hours Flat

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

Course Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

This class is perfect on-the-job training.

We will cover:

  1. Moving around in a spreadsheet
  2. Entering Data
  3. AutoFill Handle
  4. Formulas
  5. Functions
  6. Relative & Absolute Cell References
  7. Formatting
  8. Conditional Formatting
  9. Sparklines
  10. Charts
  11. Data Tables for filtering
  12. Pivot Tables
  13. Tracing Dependencies
  14. Printing tips

Who this course is for:

  • No previous knowledge or experience is necessary!
  • Effective, efficient on-the-job training for employees
  • Solid foundation for students in classes that use Excel
  • Perfect for beginners who want to start from scratch
  • Great for seasoned users looking to fill in gaps in their knowledge
  • Full of tips and tricks to shave time off your daily tasks
  • We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before

Course content

7 sections • 13 lectures • 2h 20m total length
  • How can I Learn Excel in 3 Hours Flat?
    1 page

Instructor

QuickBooks ProAdvisor with a Masters Degree in Teaching
  • 4.3 Instructor Rating
  • 677 Reviews
  • 7,055 Students
  • 10 Courses

Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did.

A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula.

She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions.

Alicia’s certifications include:

  • QuickBooks Certified User
  • Intuit ProAdvisor
  • Microsoft Certified Trainer
  • Apple Consultants Network
  • Apple Certified Support Professional, 10.5
  • Apple Certified Support Professional, 10.7
  • Apple Certified Support Professional, 10.10
  • Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook
  • Microsoft Office Specialist, Master Level


    Expected Outcomes

    1. By the end of this course, you will be able to create a spreadsheet from scratch, format it for at-a-glance understanding, and use advanced tools for data analysis. Enter data Create formulas and functions Use Absolute Cell Formatting to copy formulas anywhere Use AutoFill to replicate values and formulas Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    2. Enter data Create formulas and functions Use Absolute Cell Formatting to copy formulas anywhere Use AutoFill to replicate values and formulas Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    3. Create formulas and functions Use Absolute Cell Formatting to copy formulas anywhere Use AutoFill to replicate values and formulas Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    4. Use Absolute Cell Formatting to copy formulas anywhere Use AutoFill to replicate values and formulas Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    5. Use AutoFill to replicate values and formulas Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    6. Format appearance for quick understanding Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    7. Create Charts of several types Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    8. Use Data Tables to manage lists Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    9. Use Pivot Tables to analyze data Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();
    10. Take control of your Printing Requirements No prerequisite knowledge needed. This course is recorded in Excel 2013 on a PC The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar It doesn't matter what version of the PC or Mac operating system you're using. Practice files are included with the course so that you can follow along. Description Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. This class is perfect on-the-job training. We will cover: Moving around in a spreadsheet Entering Data AutoFill Handle Formulas Functions Relative & Absolute Cell References Formatting Conditional Formatting Sparklines Charts Data Tables for filtering Pivot Tables Tracing Dependencies Printing tips Who this course is for: No previous knowledge or experience is necessary! Effective, efficient on-the-job training for employees Solid foundation for students in classes that use Excel Perfect for beginners who want to start from scratch Great for seasoned users looking to fill in gaps in their knowledge Full of tips and tricks to shave time off your daily tasks We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before Show more Show less Course content 7 sections • 13 lectures • 2h 20m total length Expand all sections Introduction 1 lecture • 0min How can I Learn Excel in 3 Hours Flat? 1 page Entering Data 2 lectures • 12min Exploring the Interface Preview 04:16 Building Your First Spreadsheet Preview 07:21 Performing Calculations 2 lectures • 32min Formulas and Functions 19:14 Absolute Cell References 12:54 Formatting: Making It Look Good! 2 lectures • 29min Cell and Text Formatting 20:25 Conditional Formatting 08:30 Charts 2 lectures • 28min Sparklines 07:18 Charts 20:18 Data Analysis 3 lectures • 26min Data Tables 10:34 Pivot Tables 11:12 Tracing Dependencies 04:29 Printing 1 lecture • 13min Printing Your Handiwork 13:02 Instructor Alicia Katz Pollock QuickBooks ProAdvisor with a Masters Degree in Teaching 4.3 Instructor Rating 677 Reviews 7,055 Students 10 Courses Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did. A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula. She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions. Alicia’s certifications include: QuickBooks Certified User Intuit ProAdvisor Microsoft Certified Trainer Apple Consultants Network Apple Certified Support Professional, 10.5 Apple Certified Support Professional, 10.7 Apple Certified Support Professional, 10.10 Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook Microsoft Office Specialist, Master Level 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:'6781af02effd545d',m:'cd94de71a787f94c9622a6aa39f82f8fdd114085-1627848352-1800-AYtO4J/ArTFv+21ZsJExVTASXppInM1xci3Rap3gRGRXT1yJiz0JN3L2WXsSfNmS3hPPeZWGT4s2L+IwAXsMH+1efuMBV8W+rKOdgBNBiWmRiycEL9gqE21Q5QzW2YaLklpwzDLP2DO1CtCCyaeCpoBQWKvkTsUCaLiuVp1OtEnp',s:[0x01f63ebe90,0x3f03b12b42],}})();