21 エピソード
1『Intro to Excel』
1『Intro to Excel』
Say hello to Excel. You'll cover the learning objectives and get an overview of mouse-features, backstage view, and Excel window.
2『Creating Workbooks』
2『Creating Workbooks』
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.
3『Saving Workbooks』
3『Saving Workbooks』
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.
4『Nagivating Workbooks』
4『Nagivating Workbooks』
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.
5『Page Setup & Print Options』
5『Page Setup & Print Options』
In this episode, you'll learn all about page setup to take the printouts of workbooks.
6『Working with Rows, Columns, and Cells』
6『Working with Rows, Columns, and Cells』
This video takes you through the techniques of adding, deleting, and changing rows, columns, and cells.
7『Moving Data』
7『Moving Data』
This episode will show you how to move data in the workbook using cut, copy, and paste techniques.
8『Formulas and Functions』
8『Formulas and Functions』
In this episode, you'll get an overview of formulas and learn how to create formulas using functions and absolute values.
9『Working with Sheets』
9『Working with Sheets』
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.
10『Formatting Worksheets』
10『Formatting Worksheets』
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.
11『Charts』
11『Charts』
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.
12『Working with Names』
12『Working with Names』
In this episode, you'll learn how to create range names, manage names, and use names in formulas.
13『Sorting and Filtering』
13『Sorting and Filtering』
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.
14『Outlining and Subtotaling』
14『Outlining and Subtotaling』
In this episode, you'll learn how to create and outline and subtotal.
15『Working with Views』
15『Working with Views』
Want to work with views? Watch this episode.
16『Linking Files』
16『Linking Files』
In this episode, you'll create formulas between files, work with links, and consolidate data.
17『Advanced Formula Creation』
17『Advanced Formula Creation』
In this episode, you'll become familiar with If statements, VLookups, data validation, and formula auditing
18『PivotTables』
18『PivotTables』
In this episode, you'll learn how to create pivot tables and pivot charts.
19『Additional Excel Features』
19『Additional Excel Features』
In this episode, you'll learn Excel additional features such as Slicers, Goal Seeker, and Text to Columns.
20『Shortcuts』
20『Shortcuts』
Want to find out Excel shortcuts that'll make your working with Excel workbooks easy? Watch this episode.
