
Microsoft Excel 2019
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
Spreadsheet Basics9 lessons
Managing Files2 lessons
Formatting Spreadsheets11 lessons
- Font Options5:571 credit or ad
- Alignment4:371 credit or ad
- Numbers6:021 credit or ad
- Styles5:321 credit or ad
- Copy, Cut & Paste4:561 credit or ad
- Format Painter2:431 credit or ad
- Shapes5:271 credit or ad
- Pictures and Icons4:501 credit or ad
- 3D Models and SmartArt5:561 credit or ad
- Links3:511 credit or ad
- Fill Handle4:311 credit or ad
Formulas and Functions19 lessons
- Mathematical Operations4:331 credit or ad
- Addition5:141 credit or ad
- Subtraction3:121 credit or ad
- Multiplication & Division3:141 credit or ad
- Relative and Absolute Cell References3:191 credit or ad
- Average, Minimum & Maximum3:001 credit or ad
- COUNT Functions4:281 credit or ad
- LEN Function1:151 credit or ad
- VLOOKUP Function6:381 credit or ad
- XLOOKUP Function6:081 credit or ad
- IF Function5:471 credit or ad
- IFs Function2:141 credit or ad
- MAXIFs Function2:221 credit or ad
- MINIFs Function2:101 credit or ad
- CONCATENATEFunction3:341 credit or ad
- TEXTJOIN Function2:371 credit or ad
- Comparison Operators4:441 credit or ad
- UNIQUE Function5:521 credit or ad
- SEQUENCEFunction2:561 credit or ad
Data16 lessons
- Sort3:341 credit or ad
- Filter6:121 credit or ad
- Import5:521 credit or ad
- Export4:141 credit or ad
- Flash Fill3:141 credit or ad
- Text To Columns3:391 credit or ad
- Duplicates3:351 credit or ad
- Remove Spaces & Line Breaks3:071 credit or ad
- Data Validation pt. 14:281 credit or ad
- Data Validation pt. 24:161 credit or ad
- Grouping & Subtotals4:011 credit or ad
- Stocks Data Type4:521 credit or ad
- Geography Data Type4:231 credit or ad
- Goal Seek4:471 credit or ad
- Data Table3:001 credit or ad
- Scenario Manager5:001 credit or ad
Charts15 lessons
- Basics6:021 credit or ad
- Design pt. 15:171 credit or ad
- Design pt. 25:431 credit or ad
- Format pt. 15:191 credit or ad
- Format pt. 23:081 credit or ad
- Sparklines3:341 credit or ad
- Column Chart5:131 credit or ad
- Line Chart4:301 credit or ad
- Pie Chart5:521 credit or ad
- Bar Chart4:191 credit or ad
- Combination Chart3:401 credit or ad
- Thermometer Chart2:271 credit or ad
- Area Chart2:341 credit or ad
- Scatter Plot Chart3:151 credit or ad
- Map Chart3:381 credit or ad