Introduction
  • Course Introduction and Overview
  • What is Microsoft Excel
Excel Overview (For Beginners)
  • Excel Overview. Section Overview
  • Launching Application. Excel Overview and Excel Templates
  • Excel User Interface Overview
  • Excel Worksheet. Excel Rows and Cells
  • Excel Ranges
  • Working with Cells: Resizing and Navigation
  • Calculating Expenses
  • Calculating Income
  • Categorizing Budget Data
  • Formatting Cells in Excel
  • Cool Features of Excel
  • Recap of the Material Covered in this Section
  • Quiz 1: Excel Overview.
Excel Tables
  • Typical Structure of Excel Tables
  • How to Create Table in Excel
  • How to Format Excel Tables
  • How to enter data into Excel Tables
  • How to Add Data Validation in Excel Tables
  • How to Revert Tables Back into Range
  • How to Sort and Filter data in Excel Table
  • How to Remove Excel Table Data Columns
  • How to Change Excel Table Design Styles
  • How to Use Excel Table Slicer
  • How to Create Pivot Table from Excel Tables
  • How to create a copy (Duplicate) Excel Table
  • How to reference Excel Tables using Formulas and Structured Reference
  • How to Reference Excel Tables using Formulas
  • How to Reference Excel Table Totals in Formulas
  • Quiz 2: Excel Tables.
Hands On Excel Assessment Test (Basic/Intermediate)
  • Section Overview
  • Expand Columns to fit the content
  • Change Font Styles and Sizes
  • Using Formulas and Functions
  • Calculate Profit
  • Row Header formatting. Charts and Graphs
  • Formatting. Working with Worksheets
  • Page Orientation and Margins. Printing worksheet. Save as PDF
  • Quiz 3: Hands on Excel assessment test .
Intermediate Excel Hands-on Excel Assessment Test - Typical First Questions
  • Intermediate Hands-on Excel Assessment Test - Section Overview
  • Question 1: Please describe the data in Excel Tab
  • Tip: How to Effectively manage your time during Interview and Assessment Test
  • Question 2: Please create Unique ID to Identify Each Row for Executives
  • Question 3: How to Create Random Unique 6 Digit ID
  • Tip: How to Handle Interview and Assessment Test Stress and work under pressure
  • Question 4: Create Custom Row ID to uniquely identify each row
  • Question 5: How to Create Unique GUID id for each row
  • Quiz 4: Intermediate Excel Hands-On Assessment Test.
Consulting Interview Questions - VLOOKUP (Advanced)
  • Consulting Interview VLOOKUP Questions - Section Overview
  • How to use VLOOKUP to find a Row of Data, Containing Certain Value
  • Excel VLOOKUP Overview
  • Challenges we are facing to answer the question
  • Wild Card Concept in Excel
  • VLOOKUP Question: Solution
  • Variation of VLOOKUP Question
  • Quiz 5: Consulting Interview Questions
Advanced Excel Assessment Test and Interview Questions
  • Section Overview
  • How to Import data from PDF into Excel
  • Professionally Format imported data
  • Describe Imported Data
  • Change Tab name and Assign Data Types
  • Create Excel Table
  • Split Name Column into First and Last Name
  • Split Address using Power Query
  • Determine City based on Zip Code
  • Calculate State based on Zip Code
  • Create Pivot Table
  • Determine Total Sales using Pivot Table
  • Create Map which shows Sales by State
  • Which County in California has largest Sales by Volume
  • Tip: What is the best way to learn new features in Excel
  • Quiz 6: Advanced Excel Assessment Test and Interview Questions
How To Pass LinkedIn Excel Assessment Test [15 Questions Test]
  • Introduction
  • Question 1
  • Question 2
  • Question 4
  • Question 5
  • Question 6
  • Question 7
  • Question 8
  • Question 9
  • Question 10
  • Question 11
  • Question 12
  • Question 14
  • Question 15
  • Passed the test - next steps
How to Import Adobe PDF File into Excel and Cleanse the Data
  • Section Overview
  • Import PDF into Excel through Microsoft Word
  • Cleansing the data: Split Name into First and Last Name