Ultimate Microsoft Excel 2016 Course - Beginner to Expert

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

Course Description

Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle

  • Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course

  • Includes 18 hours of high-quality training by your professional trainer

  • Practice along using exercise files

  • Watch and learn with demo project files

  • Progresses logically from beginning with an easy intro to advanced topics

  • Learn to Create Charts and Graphs

This bundle includes:

  • 2 complete courses

  • 18 hours of video tutorials

  • Over 100 individual video lectures

  • Exercise files to practice what you learned

  • Demo files used by the trainer

  • Printable course transcriptions to follow along and take notes

  • Certificate of completion

Contents and Overview for the 9-Hour Excel 2016 Beginner Course

This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.

It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.

You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Contents and Overview for the 9-Hour Excel 2016 Advanced Course

Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.

Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more.

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.

* Includes quizzes, exercise files, demo files and certificate of completion.

** Updated June 2017. Course transcripts now available.



Here’s what our students are saying…


"I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .”
- Tomáš Seiner

"The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!"
- Ontavus Thomas

"Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir"
-
Jessica Henry


Did you know?


Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!


Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.


Who this course is for:

  • Users of earlier versions of Excel looking to update their skills.
  • Those new to using Microsoft Excel 2016.
  • Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge.
  • If you want to refresh your memory and understanding of Excel.

Expected Outcomes

  1. Discover new and improved features in Excel 2016. How to effectively use Excel 2016 on a touchscreen device. How create, save, and open a workbook. Learn how to personalize your use of Excel using Excel Options. How to use and how to customize the Quick Access Toolbar. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  2. How to effectively use Excel 2016 on a touchscreen device. How create, save, and open a workbook. Learn how to personalize your use of Excel using Excel Options. How to use and how to customize the Quick Access Toolbar. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  3. How create, save, and open a workbook. Learn how to personalize your use of Excel using Excel Options. How to use and how to customize the Quick Access Toolbar. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  4. Learn how to personalize your use of Excel using Excel Options. How to use and how to customize the Quick Access Toolbar. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  5. How to use and how to customize the Quick Access Toolbar. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  6. Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48 Exercise 02 01:43 Section 8 - Quiz 5 questions Excel 2016: Backup and Recovery 1 lecture • 8min AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 07:35 Section 9 - Quiz 1 question Excel 2016: Fill and Series 2 lectures • 13min Working with Fill and Series 09:08 Flash Fill 04:04 Section 10 - Quiz 2 questions 38 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67815832cfa6bc3c',m:'5a7e9903f60b4700bf6bdcc522b4ede44b10ba2a-1627844796-1800-AZEL2Qd368ycQcn2XaYs1AB0QIvvsyPc5EKgfdwCPUEpZkTruIzu/eog4eI57N1v1hZ5szIJuhrkG6jYcx8CtMFPt7iUb/1ebkv0gmwYvx8Pg/ksiNYCzVXk0FQTuu3KHdJ5p/1D2oTkZH2g2Kt0qid1QNoPy7SD70XE5MOqAm0RHJbdnAp8uCfAgHiT6dCP0QY78u/WoyjW2mwJoCPdGeY=',s:[0xdddefb9e22,0x1527e45f43],}})();
  7. The basics of entering and editing data in a workbook. Discover how to format dates and numbers. Learn practical methods in which you can backup and recover your Excel spreadsheets. Effectively use autofill and flashfill so you are more productive. Discover the essentials of using fomulas and functions. How to rename, insert, move, and reference an Excel 2016 worksheet. Discover how to create charts and graphs Learn practical methods to sort and filter your data How to protect and secure your Excel data Working with dates and times Averages, percentiles, and LINEST functions Calculating depreciation Using financial functions to determine payments Sparklines and data bars How to import and export data to and from Excel Create and effectively use pivot tables How to use Excel for data analysis Discover practical methods for financial & statistical​ Functions Practice what you learned with included exercise files Show more Show less Requirements Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer. Description Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notes Certificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion. ** Updated June 2017. Course transcripts now available. Here’s what our students are saying… "I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .” - Tomáš Seiner "The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!" - Ontavus Thomas "Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir" - Jessica Henry Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more! Just search " Simon Sez IT " to see our full list of individual courses and incredible value multi-course bundles on Udemy. Who this course is for: Users of earlier versions of Excel looking to update their skills. Those new to using Microsoft Excel 2016. Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge. If you want to refresh your memory and understanding of Excel. Show more Show less Course content 48 sections • 134 lectures • 21h 45m total length Expand all sections Excel 2016: Introduction to Excel 2016 Beginner Course 6 lectures • 18min Introduction Preview 12:02 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:23 Course Demo Files 00:23 Exercise Files 02:28 Downloadable Course Transcripts 00:19 Section 1 - Quiz 1 question Excel 2016: What's New 1 lecture • 3min New and Improved Features in Excel 2016 Preview 02:55 Excel 2016: Using Touch 1 lecture • 6min Overview of Principles of Using Touchscreen Preview 05:36 Excel 2016: Getting Started 2 lectures • 25min Creating and Saving a Workbook Preview 15:16 Opening a Workbook 10:13 Excel 2016: Using Help 1 lecture • 6min Online Help and Contextual Help 06:27 Section 5 - Quiz 1 question Excel 2016: Excel Options 1 lecture • 11min Personalizing your use of Excel 10:50 Section 6 - Quiz 2 questions Excel 2016: The Ribbon and Toolbars 5 lectures • 36min Basics of using the Ribbon Preview 14:56 Quick Access Toolbar 05:45 Tell Me Feature 06:49 Mini Toolbars and Contextual Menus 03:47 Status Bar 05:02 Section 7 - Quiz 2 questions Excel 2016: Entering and Editing Data 5 lectures • 43min Basics of Entering and Editing Data in a Workbook 13:29 Exercise 01 01:50 Formatting Dates 12:36 Formatting Numbers 13:48