Excel 2019 Complete Tutorial: Microsoft Excel Made Easy
61.5 هزار بار بازدید -
4 سال پیش
-
This is the complete course
This is the complete course on Excel 2019, Office 365 for beginners. It covers most concepts for students to learn Excel and the professionals in the workplace to do day-to-day tasks and it is pretty much an Excel 2019 course. If you like this video, check also https://learn.kaceli.com.
Topics covered along with the Excel 2019 Timeline
00:01:07 Getting Started with Basic Concepts and the User Interface
00:10:47 Spreadsheet concepts for the workplace
00:17:47 Using the Autofill Feature in Excel
00:20:23 Formatting the Worksheet in Excel
00:21:13 Using Conditional Formatting in Excel
00:22:55 Using Basic Functions in Excel: Maximum, Minimum, Average and Count
00:28:00 Performing Financial Calculations Using Simple Functions in Excel: subtraction, multiplication, division using functions
00:32:00 Using the Quick Analysis Tool in Excel for Formatting, Charts, Totals, Tables and Sparklines
00:36:16 Types of References in Excel: Relative, Mixed and Absolute References
00:43:40 Data Sorting and Filtering, Multiple Level Sorting
00:49:26 Using Charts; Modern Charts in Excel
00:58:31 Using Flash Fill in Excel
01:00:45 Cross Sheet Calculations and References
01:06:54 Calculating Percentages
01:14:50 Using Conditional and Logical Functions in Excel
01:20:48 Overview of Pivot Tables in Excel
01:27:16 Using VLOOKUP in Excel
01:49:10 Data Validation in Excel
01:52:31 Using Freeze Panes in Excel
01:54:41 Setting the Print Area in Excel
01:56:35 Linking Data with Word for Live Reports
02:01:27 Working with .csv files
02:05:29 Performing a Mail Merge Using an Excel Data File
02:15:57 Using Financial Functions in Excel: PMT, IPMT, PPMT, rate, per, nper, pv,
Video URL: Excel 2019 Complete Tutorial: Microso...
Shorter version of Excel Tutorial: Excel Tutorial: Learn Excel in 30 Min...
Working Files to practice along: https://kaceli.com/a/excel-2016-data-...
If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
Keep in touch:
For a listing of other Microsoft Office tutorials and guides please check my website: http://kaceli.com
If you want to take a course in Excel and receive a certificate of completion visit: https://learn.kaceli.com
If you like this video, check other videos on my channel: skaceli.
I create the videos using Camtasia Studio: https://techsmith.z6rjha.net/c/124509.... If you purchase it from this link, note I may receive a commission and that will help support this work.
COPYRIGHT NOTICE: No part of this video may be downloaded or distributed without permission from Sali Kaceli. If you have such a need, contact us.
#KaceliTutorials #MicrosoftExcel #ExcelTutorials #Office365
Topics covered along with the Excel 2019 Timeline
00:01:07 Getting Started with Basic Concepts and the User Interface
00:10:47 Spreadsheet concepts for the workplace
00:17:47 Using the Autofill Feature in Excel
00:20:23 Formatting the Worksheet in Excel
00:21:13 Using Conditional Formatting in Excel
00:22:55 Using Basic Functions in Excel: Maximum, Minimum, Average and Count
00:28:00 Performing Financial Calculations Using Simple Functions in Excel: subtraction, multiplication, division using functions
00:32:00 Using the Quick Analysis Tool in Excel for Formatting, Charts, Totals, Tables and Sparklines
00:36:16 Types of References in Excel: Relative, Mixed and Absolute References
00:43:40 Data Sorting and Filtering, Multiple Level Sorting
00:49:26 Using Charts; Modern Charts in Excel
00:58:31 Using Flash Fill in Excel
01:00:45 Cross Sheet Calculations and References
01:06:54 Calculating Percentages
01:14:50 Using Conditional and Logical Functions in Excel
01:20:48 Overview of Pivot Tables in Excel
01:27:16 Using VLOOKUP in Excel
01:49:10 Data Validation in Excel
01:52:31 Using Freeze Panes in Excel
01:54:41 Setting the Print Area in Excel
01:56:35 Linking Data with Word for Live Reports
02:01:27 Working with .csv files
02:05:29 Performing a Mail Merge Using an Excel Data File
02:15:57 Using Financial Functions in Excel: PMT, IPMT, PPMT, rate, per, nper, pv,
Video URL: Excel 2019 Complete Tutorial: Microso...
Shorter version of Excel Tutorial: Excel Tutorial: Learn Excel in 30 Min...
Working Files to practice along: https://kaceli.com/a/excel-2016-data-...
If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
Keep in touch:
For a listing of other Microsoft Office tutorials and guides please check my website: http://kaceli.com
If you want to take a course in Excel and receive a certificate of completion visit: https://learn.kaceli.com
If you like this video, check other videos on my channel: skaceli.
I create the videos using Camtasia Studio: https://techsmith.z6rjha.net/c/124509.... If you purchase it from this link, note I may receive a commission and that will help support this work.
COPYRIGHT NOTICE: No part of this video may be downloaded or distributed without permission from Sali Kaceli. If you have such a need, contact us.
#KaceliTutorials #MicrosoftExcel #ExcelTutorials #Office365
4 سال پیش
در تاریخ 1399/05/15 منتشر شده
است.
61,500
بـار بازدید شده