Excel Complete: From Basic to Advanced

U1: Section 2 Excel Introduction

→ Home Application
→ Excel Interface - General Explanation
→ File tab
→ Excel File Formats
→ How to Save a New File
→ How to Open an Already Created File
→ My Excel Version
→ Save As
→ How to Print
→ Save as PDF
→ Save As HTML
→ Text vs. Number Data Types
→ Quick Access Toolbar
→ Sheet composition and key combinations
→ Organization of Sheets
→ Selecting Cells and Columns
→ Copy, Cut, Paste Rows Columns
→ Hiding Rows and Columns Copy Sheets
→ Column and Row Size
→ Freeze columns and rows
→ Add comments in cells
→ Explanation Challenge 1 Intro Excel


U2: Section 3 Basic Excel

→ Type of References and Mathematical Operations
→ Introduction Basic Graphics
→ Column Chart
→ Line Chart
→ Pie Chart
→ Sort and Filter Data in a Table
→ Exercise 1 - Sort
→ Exercise 1 - Filter
→ Exercise 2 - Filter
→ MM List and Duplicate Format
→ Autocomplete
→ Composition and Structure of Functions in Excel
→ SUM function
→ Exercise 1 - Professors' Fees
→ Exercise 2 - Simple Budget
→ AVERAGE and PRODUCT functions
→ Exercise 1 - Simple Average
→ Exercise 2 - Average Product
→ Exercise 3 - Notes
→ SUMPRODUCT function
→ Exercise 1 - Intro SumProduct
→ Exercise 2 - Monthly Fishmonger Sale
→ Exercise 3 - GOT Commissions
→ COUNT and AVERAGEIF functions
→ Exercise 1 - Sales Records
→ Exercise 2 - Attendance
→ MAX and MIN functions
→ Exercise 1 - Max Min
→ Exercise 2 - Kindergarten
→ TODAY function
→ Exercise 1 - Today
→ SUMIF function
→ Exercise 1 - SumarSi Teachers' Fees
→ Exercise 2 - Total Products
→ Inspection Window
→ Precedents and Dependents in Excel
→ Explanation Challenge 2 Basic Excel

U3: Intermediate Excel Section

→ Conditional Formatting
→ Exercise 1 - Red notes
→ Validation and Protection of Sheets
→ Exercise 1 - Fruits and Vegetables The Pandemic
→ Exercise 2 - Cabin Rental
→ Exercise 3 - Hide Information
→ Book Protection
→ Formula Protection
→ SUMIF function
→ Exercise 1 - Fruits and Vegetables
→ Exercise 2 - Total Products II
→ IF function
→ Exercise 1 - Cash Payment
→ Exercise 2 - Fog
→ Nested Functions with IF, AND, OR Function
→ Exercise 1 - It Can Happen
→ Exercise 2 - Goals
→ Exercise 3 - Days Worked
→ Explanation Set
→ Exercise 1 - SICONJUNTO
→ Exercise 2 - DIABETES
→ VLOOKUP Function
→ Exercise 1 - Intro VSearch
→ Exercise 2 - Person ID
→ Exercise 5 - Payroll of Workers
→ Exercise 3 - Whole Notes
→ Exercise 4 - Exact Notes
→ FindH function
→ SIERRAR Function Explanation
→ Exercise 1 - Pet Store
→ Exercise 2 - ID-IF-ERROR
→ Exercise 3 - Vehicle License Plate
→ Exercise 1 - Sales Hugo, Paco, Luis
→ FILTER Exercise - Employee Salary
→ FILTER Exercise - Salary Employees 2
→ FILTER Exercise - COURSES
→ FILTER Exercise - Pharmacy Headquarters
→ Subtotals
→ Exercise 1 - Sparky Appliances
→ Exercise 2 - Cost per Dept.
→ Pivot Tables and Charts
→ Exercise 1 - Works
→ Pivot Tables with Data Segmentation
→ Exercise 1 - Cell Phone Sales
→ Presentation Pivot tables
→ Exercise 3 - Sales Olympics
→ Explanation Challenge 3 Excel Intermediate

U4: Section 5 Pivot Tables and Data Analysis

→ Pivot Tables and Charts
→ Exercise 1 - Works
→ Pivot Tables with Data Segmentation
→ Exercise 1 - Cell Phone Sales
→ Exercise 3 - Sales Olympics
→ Presentation Pivot tables
→ Data Used
→ Tricks and Connections
→ Source Data Update
→ Segmentation Blocking
→ Report Filter Pages


U5: Section 6 Advanced Excel

→ Cell Names and Cell Ranges
→ CONCATENATE function
→ Exercise Name Surname
→ Salespeople Lists Exercise
→ INDIRECT function
→ Indirect Exercise
→ Exercise 1 - Cities
→ Exercise 2 - Airplanes
→ Exercise 3 - Categories
→ Search Objective
→ Exercise 1 - Loan
→ Exercise 2 - Market Share
→ Exercise 3 - Saving for Retirement
→ Scenarios
→ Exercise 1 - Currencies
→ Exercise 2 - Loan2
→ Introduction to Macros
→ Macro Environment
→ Exercise 1 Sales
→ Exercise 2 - Hotel Reservation
→ Explanation Challenge 4 Advanced Excel

Course evaluation

→ This course contains a final exam

G-Tools: For Students

→ Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

→ Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.