第 1 季
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.
