VTC Legacy
Home / Business Applications

Microsoft Excel 2019

by Melanie Hedgespeth
108 lessons17 chapters7.6 hReleased 20207 free
Start the free chapter

Microsoft Excel is the most widely used spreadsheet application worldwide. Excel is part of the cloud-based suite of applications known as Microsoft 365. Currently the suite holds Office 2019 Applications. rnWith Excel you can create files to track budgets, maintain finances, make sales forecasts, schedules, to do lists, loan amortizations and much more. rnrnThis course will begin with addressing the fundamentals of Excel. You will learn how to work with the interface, understand spreadsheet terminology and access files on a myriad of devices. With Microsoft's usage of a cloud based platform, files can be accessed anywhere, anytime and easily shared with others.rnrnWithin the Excel course, you will learn how to format spreadsheets for professional presentation, utilize formulas, functions and charts. Within Excel you will handle large amounts of data and understand how to filter, sort or create pivot tables. You will also work with time saving templates available in the application. rnrnMicrosoft Excel holds numerous tools to fit many needs in any setting. Work through this course and master the spreadsheet application that will help you both personally and professionally.

Course content

Introduction1 lessons
Fundamentals3 lessons
Interface3 lessons
Spreadsheet Basics9 lessons
Managing Files2 lessons
Formatting Spreadsheets11 lessons
Formulas and Functions19 lessons
Data16 lessons
Charts15 lessons
Pivot Tables5 lessons
Collaboration6 lessons
Macros2 lessons
File Options7 lessons
Templates3 lessons
Tips4 lessons
Wrap Up1 lessons
Author1 lessons