Channel: Kaceli TechTraining

Category: Education

Tags: excel tutorialhow to use microsoft excel 2018teachers techexcel 2018 tutoriallearn excellearn microsoft excel 2018microsoft excel 2019 tutorialmicrosoft wordexel 2018basic excel tutorialmicrosoft excelexcel 2019 tutorial for beginnerskacelimicrosoft excel tutorialexcelexcel 2019how to use excelmicrosoft excel 2018 tutorialexcel 2020microsoft excel for beginnersfreeexcel for beginnersexcel tutorial for beginnersexcel tutorial 2018

Description: 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 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: youtu.be/c1sBpt4wBsE Shorter version of Excel Tutorial: youtu.be/7RCdzTpKO0A Working Files to practice along: kaceli.com/a/excel-2016-data-file 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: kaceli.com If you want to take a course in Excel and receive a certificate of completion visit: learn.kaceli.com If you like this video, check other videos on my channel: youtube.com/skaceli. I create the videos using Camtasia Studio: 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