Microsoft Excel - Excel from Zero to Hero (2020)

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

Course Description


Hello!

This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business.


This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.

We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables.


What makes me qualified to teach you?

My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:

***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana

***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine

***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne


What is this Excel course about?

In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.

This course will cover Beginners, Intermediate and Advanced levels of Excel, including:

  • Overview of Excel, What is it for and how to use it

  • Entering, editing, formatting data in Excel

  • Formulas and main functions in Excel; Sum, Average, Min, Max...etc.

  • Charts and visualisation

  • The powerful tool of PivotTables

  • Creating and Managing PivotTables

  • And much more! New lectures will be added and updated when possible.


Learn from someone who is currently working in the industry, who knows the most current teaching techniques.

By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.

Go ahead and click the enroll button, and I'll see you in lesson 1!


I wish you an enjoyable journey with us.

Shukran! Mozn

Who this course is for:

  • Anyone interested in learning Microsoft Excel
  • Anyone need to save time and create automatic and dynamic reports

Course content

6 sections • 36 lectures • 2h 54m total length
  • Excel Toolbars and shortcut menues
    06:49
  • Workbooks and Worksheets
    04:59
  • How to look for Help on Excel - Using Excel Help
    03:46
  • Chapter Quiz
    3 questions

Expected Outcomes

  1. Learn the Microsoft Excel from the beginning Explore and learn the important functions in Microsoft Excel Learn how to analyse data using Excel Learn about PivotTable and use it for analysis Learn how to perform basic calculations Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();
  2. Explore and learn the important functions in Microsoft Excel Learn how to analyse data using Excel Learn about PivotTable and use it for analysis Learn how to perform basic calculations Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();
  3. Learn how to analyse data using Excel Learn about PivotTable and use it for analysis Learn how to perform basic calculations Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();
  4. Learn about PivotTable and use it for analysis Learn how to perform basic calculations Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();
  5. Learn how to perform basic calculations Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();
  6. Learn Excel by doing using practical examples Requirements This course starts from zero, there is NO pre-requirements Description Hello! This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide. We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables. What makes me qualified to teach you? My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020: ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne What is this Excel course about? In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field. This course will cover Beginners, Intermediate and Advanced levels of Excel, including: Overview of Excel, What is it for and how to use it Entering, editing, formatting data in Excel Formulas and main functions in Excel; Sum, Average, Min, Max...etc. Charts and visualisation The powerful tool of PivotTables Creating and Managing PivotTables And much more! New lectures will be added and updated when possible. Learn from someone who is currently working in the industry, who knows the most current teaching techniques. By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment. Go ahead and click the enroll button, and I'll see you in lesson 1! I wish you an enjoyable journey with us. Shukran! Mozn Who this course is for: Anyone interested in learning Microsoft Excel Anyone need to save time and create automatic and dynamic reports Show more Show less Course content 6 sections • 36 lectures • 2h 54m total length Expand all sections Getting Started with Excel 4 lectures • 20min What is Excel used for? Preview 04:27 Excel Toolbars and shortcut menues 06:49 Workbooks and Worksheets 04:59 How to look for Help on Excel - Using Excel Help 03:46 Chapter Quiz 3 questions Entering Data 2 lectures • 12min Data entry, Editing and AutoFill 05:53 Entering Dates and Time Preview 06:10 Formulas and Functions 4 lectures • 24min Working with Simple formulas 08:40 Using the SUM() function 06:39 Using the MIN() and MAX() functions 03:18 Using the AVERAGE() finction 05:06 Charts 3 lectures • 24min How to Create Charts in Excel 08:31 Chart Types 11:53 Exploring Excel Ideas 03:43 PivotTables in Excel 5 lectures • 26min Introduction 00:50 Create your first PivotTable 11:15 Configure your PivotTable 06:00 Create a PivotTable from external data source 02:16 Manage PivotTables Preview 05:47 Summarizing PivotTable Data 18 lectures • 1hr 8min Subtotals and Grand Totals 04:08 Operations of the Data field summary Preview 04:01 Adding more than one data field 03:06 Managing Dates in PivotTables 03:36 Creating Calculated Fields 04:11 Drilling down the data 04:11 Sorting the data 02:27 Filtering the data 02:55 Filter by rules 04:04 Filtering with search 01:53 Filtering using Slicers 04:48 Formatting the slicers 03:46 More on filtering your data 06:11 Clearing and re-applying filters 02:01 Filtering the PivotTable with a Timeline 04:04 Changing the style of the PivotTable 04:44 Changing the Layout of the PivotTable 04:31 Formatting the numbers in the PivotTable 03:48 Instructor Mozn Akhourshiedah Engineer, trainer, Entrepreneur 4.4 Instructor Rating 255 Reviews 7,114 Students 5 Courses My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. My first Udemy course is Starter's Arabic language course , join me in this highly effective course now! More about Mozn: Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1. 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:'67817e94e9df40dd',m:'5a9a6ce8781c00b4f5001da18d693138e6e06820-1627846371-1800-AVVs51JU51vGN/22Pbf/tQ+8lmDgYsNYGViDVxmdeArbMY2GZcQPOuKIJeB9o0x5IhglsW9/Hiyg1gWSONIEWnO8AaUS8N7pqcEXfUKHepEESBno7oTaYBbSMdLzUST0XkecIr/GXa+KgeNkWZP+gljDGZjC/aqsjx2UljSykMej',s:[0x6bed3d345b,0x35537ff179],}})();