Microsoft Excel Beginners 2019

Say hello to Excel. You'll cover the learning objectives and get an overview of mouse-features, backstage view, and Excel window.

In this episode, you'll learn how to create basic formulas, relative references, and order of operations. In addition to this, you'll also work with ranges.

This episode shows you how to save workbooks by using save and save as commands. You'll also find out what are file extensions and learn how to share, export, and publish files.

In this episode, you'll learn how to open files and find techniques to work with larger files. You'll also learn how to work with freeze pane and split screen options.

In this episode, you'll learn all about page setup to take the printouts of workbooks.

This video takes you through the techniques of adding, deleting, and changing rows, columns, and cells.

This episode will show you how to move data in the workbook using cut, copy, and paste techniques.

In this episode, you'll get an overview of formulas and learn how to create formulas using functions and absolute values.

In this episode, you'll work with sheets to find out how to add, delete, and rename sheets and you'll also encounter dimensional formulas.

This episode will show you how to format cells, numbers, and tables. You'll also find out about format painters, borders and shading, styles, handles, and custom lists. In addition to this, you'll also learn techniques to protect sheets.

In this episode, you'll go through different types of charts and learn how to create and edit charts. You'll also learn how to create link chart titles.

In this episode, you'll learn how to create range names, manage names, and use names in formulas.

This episode will show you how to sort and filter data and how to remove duplicate data easily. You'll also get an overview of the advanced filters used in Excel.

In this episode, you'll learn how to create and outline and subtotal.

Want to work with views? Watch this episode.

In this episode, you'll create formulas between files, work with links, and consolidate data.

In this episode, you'll become familiar with If statements, VLookups, data validation, and formula auditing

In this episode, you'll learn how to create pivot tables and pivot charts.

In this episode, you'll learn Excel additional features such as Slicers, Goal Seeker, and Text to Columns.

Want to find out Excel shortcuts that'll make your working with Excel workbooks easy? Watch this episode.

Thank you for taking up this course.