Microsoft Excel Basic to Advanced: A Complete Learning Path
Master Microsoft Excel from the ground up, covering essential basics to advanced techniques in this comprehensive course
4.30 (57 reviews)
4 289
students
6 hours
content
Sep 2024
last update
$44.99
regular price
What you will learn
Create and Open Workbook
Tabs and Ribbon
Errors Functions
AND, OR, XOR, SWITCH, CELL Functions
IF and Nesting IF() Functions
Filter Functions
DATE and DATEVALUE Functions
Convert Time Hours, Minutes and Seconds
COUNT, ROUND, SUM, AVERAGE Functions
Subtotal and Power Functions
INT & TRUNC Function
Find and Replace
LEN, MID, REPT, SPLIT, TEXT and TRIM
INDEX, MATCH, EXACT Functions
VLOOKUP, HLOOKUP and XLOOKUP Functions
Exact match vs Approximate match
Import Data Web to Excel
Convert Number to Word
Dynamic dropdown List
Dependent dropdown List
Charts & Graphs
Sort and Filter Functions
Proetect Worksheet and Worksheet
Freeze and Split Panes
Headers and Footers
Page settings
Set Print Area
Course Gallery
Loading charts...
6186053
udemy ID
16/09/2024
course created date
24/09/2024
course indexed date
QAHTAN ALGHANIMI
course submited by