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


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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock

Check Today's 30+ Free Courses on Telegram!

X