Microsoft Advance Excel Course
Categories: Office Productivity
About Course
Advanced Excel
Advanced Excel skill set is crucial to advance your career. Excel training focuses on a number of critical skills that can be utilized and valued in almost any position in a company. After training, you should be better able to:
- Visualize, manipulate, and evaluate the data.
- Provide answers and solutions to problems affecting the business by being able to interpret data at a more advanced level.
- Maintain, organize, and balance complex financial and inventory accounts.
- Create tracking systems for different departments and operations, including various workflow processes.
- MS Excel is widely used in organizations across departments, basic understanding of the Microsoft Excel
- Important for employees at all levels across verticals
What Will You Learn?
- Be a Confident & Advanced Microsoft Excel user
- Able to solve complex problems in Excel
- Learn new techniques and formulas to tackle tasks faster and better in Excel
- Apply the right tools for a given task instead of going to your go-to tools and making them work for every situation
- Reduce complexity of your spreadsheets
Course Content
1. Introduction
-
1.1 The Company
-
1.2 Spreadsheet Modeling
00:00 -
1.3 Overview
00:00
2. The Excel Environment
-
2.1 Opening a Workbook
00:00 -
2.2 The Excel Ribbon
00:00 -
2.3 The Quick Access Toolbar
00:00 -
2.4 Worksheets
00:00 -
2.5 Moving around a worksheet and a workbook
00:00 -
2.6 Printing a worksheet
00:00 -
2.7 Saving a workbook file
00:00
3. Working with Data: Basic Techniques
-
3.1 Cells and Ranges
00:00 -
3.2 Selecting Ranges
00:00 -
3.3 Selecting all cells in a dataset Using shortcut keys
00:00 -
3.4 Selecting all cells in a worksheet
00:00 -
3.5 Selecting Non Contiguous Ranges
00:00 -
3.6 Selecting Cells and Named Ranges
00:00 -
3.7 Selecting Otherwise Difficult to Select Cells with Go To Special
00:00 -
3.8 Filling Series
00:00 -
3.9 Copying and Moving Entries
00:00 -
3.10 The Undo Command
00:00
4. Increasing spreadsheet readability
-
4.1 Working with Rows and Columns
00:00 -
4.2 Making Better Use of Screen Space
00:00 -
4.3 Basic Cell Formatting
00:00 -
4.4 Basic Number Formatting
00:00 -
4.5 Conditional Formatting
00:00 -
4.6 Formatting and Other Options with Paste Special
00:00 -
4.7 Setting Up a Worksheet for Printing
00:00
5. Excel Formulas
-
5.1 Copying Formulas
00:00 -
5.2 The Autocomplete Formula Option
00:00 -
5.3 Entering Formulas by Pointing
00:00 -
5.4 Other Ways to Copy Formulas
00:00 -
5.5 Hierarchy of Mathematical Operations
00:00 -
5.6 Summation Icon
00:00 -
5.7 Editing or Correcting Formulas
00:00 -
5.8 Showing Actual Formulas in Cells
00:00
6. Useful Excel functions
-
6.1 IF Statements
00:00 -
6.2 Text Functions
00:00 -
6.3 Flash Fill
00:00 -
6.4 Basic Date and Time Functions
00:00 -
6.5 Range Names
00:00 -
6.6 Lookup functions
00:00 -
6.7 Other Lookup and Reference Functions
00:00 -
6.8 Error Trapping
00:00 -
6.9 Rounding Functions
00:00 -
6.10 The SUMPRODUCT Function
00:00 -
6.11 Modeling Uncertainty in Excel
00:00 -
6.12 Excel Financial Functions
00:00 -
6.13 COUNT, COUNTA, and COUNTBLANK Functions
00:00 -
6.14 Excel Statistical Functions
00:00 -
6.15 Conditional Counts
00:00 -
6.16 Conditional Sums
00:00 -
6.17 Removing Duplicates
00:00 -
6.18 Sorting in Excel
00:00 -
6.19 Filtering Data
00:00 -
6.20 Subtotals
00:00 -
6.21 Pivot Tables
00:00 -
6.22 Pivot Charts
00:00 -
6.23 Conditional Formatting: The Formula Option
00:00
7. Charts
-
7.1 Creating Charts
00:00 -
7.2 Moving and Resizing Charts
00:00 -
7.3 Basic Formatting of Charts
00:00 -
7.4 Formatting Axes and Data Series
00:00 -
7.5 Customizing Charts
00:00
8. Importing data into Excel
-
8.1 Importing from a Text or Word file
00:00 -
8.2 Using Web Queries to Import Data from the Web
00:00
9. The Art of Spreadsheet Modelling
-
9.1 Model Building Blocks
00:00 -
9.2 Model Terminology
00:00 -
9.3 The Spreadsheet Model Building Process
00:00 -
9.4 One-Way Data Tables
00:00 -
9.5 Two-Way Data Tables
00:00 -
9.6 Goal Seek
00:00 -
9.7 Auditing
00:00 -
9.8 Error Trapping
00:00 -
9.9 Spinners
00:00
10. Monte Carlo Simulation
-
10.1 Uncertainty and Monte Carlo Simulation
00:00 -
10.2 Useful functions like Random, Rank, Frequency
00:00
Student Ratings & Reviews
No Review Yet