EXCEL2019
페이지 정보
본문
Excel 2019 Beginner Tutorial
Excel 2019 Beginner Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/36ZPKzO
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
https://bit.ly/3GnV553
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Start 0:00
Introduction 0:03
Start Screen \u0026 Templates 0:59
Ribbon \u0026 Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup \u0026 Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting \u0026 Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving \u0026 Copying Data 1:09:15
Inserting Rows \u0026 Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
@ashleeandrews4568 : WHY WASNT YOU MY TEACHER IN SCHOOL IM JUST 24 mins in && CAN TELL YOU ARE A WONDERFUL TEACHER!!!! IM DEFINITELY GONNA WATCH THIS OVER && UNTIL IM COMFORTABLE THEN I WILL GO BACK && TAKE THE MS EXCEL 2019 GRADED PROJECT!!! I WANNA MAKE AN 100%
@nlading : Just keep in mind at approximately 1:16:00 when you are describing the find and replace for blank cells, if you replace blanks with zeros that will impact your cells with descriptive stats formulas (average, min, max, count, etc.). If you replace blanks with a dash or "blank" those cells will not be impacted.
@yuniol1116 : D1: Entering Text 30:18
D2: Deleting & Formatting 40:20
D3: Absolute Referencing 1:03:01
D4: AutoFill 1:16:57
D5: Excel Templates 1:32:40
D6: Printing 1:49:58
D7: To go over
@kellybell54 : This is an excellent tutorial. Not everyone is capable of teaching. It takes an innate talent to be able to teach effectively. The person narrating and instructing in this video and the other Excel tutorials is a natural born teacher. Excellent!
@kayl2141 : This video is EXCELLENT! I am a basic Excel user but I’m trying to become more advanced so this video is just what I needed. The way you explain everything is so clear and concise—I love your teaching style! Thanks!
Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!
In this mega, 3-hour long Excel 2019 tutorial for beginners, you'll start on your journey towards Excel mastery. This Excel tutorial packs in so much content, including, getting started with Excel formulas and functions, how dates and time work in Excel, how to print the pages you want to print in Excel, working with ranges in Excel, working with larger files in Excel, freeze panes in Excel, loads of information about formulas in Excel, and so much more. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets.
If you've never used Excel before, or the thought of a spreadsheet makes you nervous, then this Excel crash course packed full of Excel tips and tricks is the place to start.
✅ This Excel tutorial also includes follow-along exercises that you can download below! ➡️
https://www.simonsezit.com/excel-2019-course-exercise-files/
Note: This Excel course is also suitable for Excel 365, 2016, and 2013 users.
Tutorial Markers:
0:00:00 - Intro to Excel
0:01:09 - What's New In Excel 2019
0:09:01 - Course Overview
0:10:18 - Overview of the Excel window
0:18:44 - Mouse-Features
0:21:57 - Backstage View
0:24:35 - Entering Text and Numbers in Excel
0:29:06 - Creating Basic Formulas in Excel
0:35:56 - Relative References in Excel
0:38:57 - Order of Operations in Excel
0:43:45 - Working with Ranges in Excel
0:48:22 - Module 2 - Practice Exercise
0:49:56 - Working with the Save and Save As Commands
0:54:31 - File Extensions, Share, Export and Publish Files
0:58:36 - Module 3 - Practice Exercise
0:59:34 - Opening a File in Excel
1:05:06 - Working with Larger Files in Excel
1:10:41 - Freeze Panes in Excel
1:13:57 - Split Screen in Excel
1:21:03 - Module 4 Exercise
1:23:51 - Headers and Footers in Excel
1:31:15 - Print Titles
1:34:07 - Comments in Excel
1:39:31 - Page Setup Options in Excel
1:47:01 - Fit to Print on One Page in Excel
1:51:00 - Printing Workbooks in Excel
1:54:56 - Module 5 Exercise
1:56:49 - Adding and Deleting Columns and Cells
2:03:00 - Changing Column and Rows Widths
2:06:49 - Module 6 Exercise
2:07:58 - Copt, Cut and Paste
2:15:06 - Copying Formulas
2:20:18 - Module 7 Exercise
2:21:36 - Overview of Formulas
2:24:24 - Create Formulas Using Functions part1
2:34:28 - Create Formulas Using Functions part2
2:39:53 - Absolute Values
2:45:12 - Module 8 Exercise
2:46:30 - Adding Deleting and Renaming Sheets
2:50:38 - Additional Sheet Tab Options
2:55:58 - 3 Dimensional Formulas
3:01:29 - Module 9 Exercise
These tutorials were taken from the full-length Simon Sez IT class
https://bit.ly/3eVSKmb
Get the free MS Excel 2019 course exercise files and complete the exercises here ⏩ https://www.simonsezit.com/excel-2019-course-exercise-files/
Need training for Excel 2021/365? Check out our free 10-hour training course on YouTube ➡️
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first-month-free
Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
Check out our FREE 300+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Level up your Excel skills with free training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc \u0026 here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
\u0026 Pivot Table training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Watch additional popular Microsoft Office tutorials from Simon Sez IT:
✅ Excel 2021 tutorials for intermediate users playlist here:https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Ultimate Microsoft Office Course (12-Hour Course for Beginners):
✅ Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course)
✅ Advanced PowerPoint Hacks (1-Hour Webinar Tutorial)
✅Learn PivotTables in 1 Hour (Excel Crash Course)
Stay in touch!
✅SimonSezIT.com: https://www.SimonSezIT.com/
✅StreamSkill.com: https://StreamSkill.com/
✅YouTube Channel: https://www.youtube.com/user/simonsezittraining
✅LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE https://www.youtube.com/simonsezittraining?sub_confirmation=1
♥️ We appreciate your support!
#SimonSezIT #Excel
@xtratouch77054 : This is a fantastic tutorial... the procession through the various lessons and exercises are structure exceptionally well. Couldn't have spent a more pleasurable time learning Excel. Keep up the excellent work.
@AnaRodriguez-xj7lp : This is by far one of the best tutorials, I needed to brush up on my excel skills, for work, and this 3 hour training was everything, very easy to follow and Cindy did her thing, explaining each module in a manageable way for someone that works with
excel but not on a everyday basis. Once again, thank you kindly, Cindy, and Simon for this outstanding tutorial.
@ksenyat317 : What a great presentation! Thank you so much for putting this course together! Do you have any Excel tutorials for the level after this one?
@marshawooten8669 : Stumbled across this video. Love the organization and ease to jump to topic. I was looking how to calculate or create a formula for hours * rate. My sheet has hours listed (0.75h) and rate $20. I tried following the example in Mod 7 part 2 and I'm not having luck with the downloaded CSV file. You are definitely gifted to be an instructor! Great tone, easy to listen and follow.
@shibasisbiswas7867 : Excellent in-depth tutorial. I have gone through many Excel tutorials but none were so intuitively structured nor were the explanations so in-depth while being easy to comprehend. Really appreciate the effort put in by the instructor Cindy . I would highly recommend anyone willing to engage with Excel in a meaningful way to go through the tutorials in this channel.
Keep up the good work
Excel 2019 Advanced Tutorial
Excel 2019 Advanced Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/36ZPKzO
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
www.learnit.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Start 0:00
Introduction 0:03
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single \u0026 Multi-Level Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting \u0026 Editing Chart Elements 32:28
Creating \u0026 Applying Custom Chart Templates 36:58
Adding \u0026 Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing \u0026 Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying Built-In Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
@TheDisciplinedPoser : This is probably the best excel tutorial I've come upon (that is free). Very thorough and easy to understand. Thank you.
@dribeiro7813 : Thanks a billion!!!❤️ Your teaching style is easy to understand plus the excercise worksheets made available are bonus.
@irinavistar7417 : What a great tutorial !!! I have already watched the first two videos. Looking forward to the rest !!!! Thank you very much, Faz, for putting it all together.
@akashkamal3758 : very useful tutorial ... lots of insights but the best part is that the instructor keeps you engaged
@simpleexcelexamples9619 : Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students)
Excel 2019 Beginner Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/36ZPKzO
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
https://bit.ly/3GnV553
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Start 0:00
Introduction 0:03
Start Screen \u0026 Templates 0:59
Ribbon \u0026 Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup \u0026 Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting \u0026 Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving \u0026 Copying Data 1:09:15
Inserting Rows \u0026 Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
@ashleeandrews4568 : WHY WASNT YOU MY TEACHER IN SCHOOL IM JUST 24 mins in && CAN TELL YOU ARE A WONDERFUL TEACHER!!!! IM DEFINITELY GONNA WATCH THIS OVER && UNTIL IM COMFORTABLE THEN I WILL GO BACK && TAKE THE MS EXCEL 2019 GRADED PROJECT!!! I WANNA MAKE AN 100%
@nlading : Just keep in mind at approximately 1:16:00 when you are describing the find and replace for blank cells, if you replace blanks with zeros that will impact your cells with descriptive stats formulas (average, min, max, count, etc.). If you replace blanks with a dash or "blank" those cells will not be impacted.
@yuniol1116 : D1: Entering Text 30:18
D2: Deleting & Formatting 40:20
D3: Absolute Referencing 1:03:01
D4: AutoFill 1:16:57
D5: Excel Templates 1:32:40
D6: Printing 1:49:58
D7: To go over
@kellybell54 : This is an excellent tutorial. Not everyone is capable of teaching. It takes an innate talent to be able to teach effectively. The person narrating and instructing in this video and the other Excel tutorials is a natural born teacher. Excellent!
@kayl2141 : This video is EXCELLENT! I am a basic Excel user but I’m trying to become more advanced so this video is just what I needed. The way you explain everything is so clear and concise—I love your teaching style! Thanks!
Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!
In this mega, 3-hour long Excel 2019 tutorial for beginners, you'll start on your journey towards Excel mastery. This Excel tutorial packs in so much content, including, getting started with Excel formulas and functions, how dates and time work in Excel, how to print the pages you want to print in Excel, working with ranges in Excel, working with larger files in Excel, freeze panes in Excel, loads of information about formulas in Excel, and so much more. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets.
If you've never used Excel before, or the thought of a spreadsheet makes you nervous, then this Excel crash course packed full of Excel tips and tricks is the place to start.
✅ This Excel tutorial also includes follow-along exercises that you can download below! ➡️
https://www.simonsezit.com/excel-2019-course-exercise-files/
Note: This Excel course is also suitable for Excel 365, 2016, and 2013 users.
Tutorial Markers:
0:00:00 - Intro to Excel
0:01:09 - What's New In Excel 2019
0:09:01 - Course Overview
0:10:18 - Overview of the Excel window
0:18:44 - Mouse-Features
0:21:57 - Backstage View
0:24:35 - Entering Text and Numbers in Excel
0:29:06 - Creating Basic Formulas in Excel
0:35:56 - Relative References in Excel
0:38:57 - Order of Operations in Excel
0:43:45 - Working with Ranges in Excel
0:48:22 - Module 2 - Practice Exercise
0:49:56 - Working with the Save and Save As Commands
0:54:31 - File Extensions, Share, Export and Publish Files
0:58:36 - Module 3 - Practice Exercise
0:59:34 - Opening a File in Excel
1:05:06 - Working with Larger Files in Excel
1:10:41 - Freeze Panes in Excel
1:13:57 - Split Screen in Excel
1:21:03 - Module 4 Exercise
1:23:51 - Headers and Footers in Excel
1:31:15 - Print Titles
1:34:07 - Comments in Excel
1:39:31 - Page Setup Options in Excel
1:47:01 - Fit to Print on One Page in Excel
1:51:00 - Printing Workbooks in Excel
1:54:56 - Module 5 Exercise
1:56:49 - Adding and Deleting Columns and Cells
2:03:00 - Changing Column and Rows Widths
2:06:49 - Module 6 Exercise
2:07:58 - Copt, Cut and Paste
2:15:06 - Copying Formulas
2:20:18 - Module 7 Exercise
2:21:36 - Overview of Formulas
2:24:24 - Create Formulas Using Functions part1
2:34:28 - Create Formulas Using Functions part2
2:39:53 - Absolute Values
2:45:12 - Module 8 Exercise
2:46:30 - Adding Deleting and Renaming Sheets
2:50:38 - Additional Sheet Tab Options
2:55:58 - 3 Dimensional Formulas
3:01:29 - Module 9 Exercise
These tutorials were taken from the full-length Simon Sez IT class
https://bit.ly/3eVSKmb
Get the free MS Excel 2019 course exercise files and complete the exercises here ⏩ https://www.simonsezit.com/excel-2019-course-exercise-files/
Need training for Excel 2021/365? Check out our free 10-hour training course on YouTube ➡️
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first-month-free
Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
Check out our FREE 300+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Level up your Excel skills with free training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc \u0026 here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
\u0026 Pivot Table training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Watch additional popular Microsoft Office tutorials from Simon Sez IT:
✅ Excel 2021 tutorials for intermediate users playlist here:https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Ultimate Microsoft Office Course (12-Hour Course for Beginners):
✅ Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course)
✅ Advanced PowerPoint Hacks (1-Hour Webinar Tutorial)
✅Learn PivotTables in 1 Hour (Excel Crash Course)
Stay in touch!
✅SimonSezIT.com: https://www.SimonSezIT.com/
✅StreamSkill.com: https://StreamSkill.com/
✅YouTube Channel: https://www.youtube.com/user/simonsezittraining
✅LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE https://www.youtube.com/simonsezittraining?sub_confirmation=1
♥️ We appreciate your support!
#SimonSezIT #Excel
@xtratouch77054 : This is a fantastic tutorial... the procession through the various lessons and exercises are structure exceptionally well. Couldn't have spent a more pleasurable time learning Excel. Keep up the excellent work.
@AnaRodriguez-xj7lp : This is by far one of the best tutorials, I needed to brush up on my excel skills, for work, and this 3 hour training was everything, very easy to follow and Cindy did her thing, explaining each module in a manageable way for someone that works with
excel but not on a everyday basis. Once again, thank you kindly, Cindy, and Simon for this outstanding tutorial.
@ksenyat317 : What a great presentation! Thank you so much for putting this course together! Do you have any Excel tutorials for the level after this one?
@marshawooten8669 : Stumbled across this video. Love the organization and ease to jump to topic. I was looking how to calculate or create a formula for hours * rate. My sheet has hours listed (0.75h) and rate $20. I tried following the example in Mod 7 part 2 and I'm not having luck with the downloaded CSV file. You are definitely gifted to be an instructor! Great tone, easy to listen and follow.
@shibasisbiswas7867 : Excellent in-depth tutorial. I have gone through many Excel tutorials but none were so intuitively structured nor were the explanations so in-depth while being easy to comprehend. Really appreciate the effort put in by the instructor Cindy . I would highly recommend anyone willing to engage with Excel in a meaningful way to go through the tutorials in this channel.
Keep up the good work
Excel 2019 Advanced Tutorial
Excel 2019 Advanced Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/36ZPKzO
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
www.learnit.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Start 0:00
Introduction 0:03
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single \u0026 Multi-Level Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting \u0026 Editing Chart Elements 32:28
Creating \u0026 Applying Custom Chart Templates 36:58
Adding \u0026 Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing \u0026 Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying Built-In Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
@TheDisciplinedPoser : This is probably the best excel tutorial I've come upon (that is free). Very thorough and easy to understand. Thank you.
@dribeiro7813 : Thanks a billion!!!❤️ Your teaching style is easy to understand plus the excercise worksheets made available are bonus.
@irinavistar7417 : What a great tutorial !!! I have already watched the first two videos. Looking forward to the rest !!!! Thank you very much, Faz, for putting it all together.
@akashkamal3758 : very useful tutorial ... lots of insights but the best part is that the instructor keeps you engaged
@simpleexcelexamples9619 : Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students)
... 
댓글목록
등록된 댓글이 없습니다.
