Advanced Excel Course Syllabus: What Will You Learn?
                     Attitud
TeH E  W O R L D  J F  P R O F E SS I O N A L SAT T I T U D E  TA L LY  
A C A D E M Y
Advanced 
Excel Course 
SWyhllaatb Wusil:l You 
Learn?
Build Practical Excel 
Skills for Your Career
www. 
attitudeutallyacademy.com
Attitud
T H E  W O R L D  O F  
P R O F E S S I O N A L S
W .  1 5 5 8  e|  2 0 0 8  
C O M P A N Y
Excel 
Fundamental
sBuild a strong foundation for efficient data work
Excel interface and 
worksheets
Formatting cells and 
tables
Basic 
formulas
Keyboard 
shortcuts
attitudetallyacademy.co
m
Attitud
T HeE  W O R L D  O F  P R O F E S S I O N A L S
N ° I S O  9 0 0 1 ,  2 0 0 8  
C O M P A N Y
Make logical 
IF, decisions
AND, =IF(A1>50, "Pass", 
OR "Fail)
Advanced 
Handle errors 
Excel IFERRO gracefullyR =IFERROR(A1/B1, "Check 
F Data"Powoerrfulm formuulalsa fosr 
Summarize with 
smarter data manipulation SUMIF conditions
COUNTIF =SUMIF(B:B, "Sales", 
AVERAGEI C:C)
F =COUNTIF(D:D, “100”)
=AverageIF(E:E, “0”, 
F:F)
attitudetallyacademy.com f =SUMIF(B:B, "Sales", 
x C:C)
Attitud
T H E  W O R L D  O F  
P R OeF E SS I O N A L S
A N  I S O  9 0 0 1  -  2 0 0 8  
C O M PA N Y
Find data vertically in a 
Lookup VLOOKU table.=VLOOKUP(A2, B:E, 3, P FALSE)
Function Find data horizontally in a table.
HLOOKU
s P =HLOOKUP(A1, A:F, 2, FALSE)
Key functions to 
Flexible lookup in any 
retrieve data XLOOKU direction.
efficiently. P =XLOOKUP(A2, A:A, B:B, "Not Found")
Powerful combination 
INDEX for dynamic lookups.
& =INDEX(B:B, MATCH(E2, A:A, 
MATCH 0))
attitudetallyacademy.co
m
Attitud
T HeE  W O R L D  O F  P R O F E S S I O N A L SN  |  I S O  |  2 0 0 8  
C O M P A N Y
Data Cleaning A B C D E
& 1
2
MPreparea data nthat ias accgurate,e consmistent aned annalysist-
ready 3
4 f 
Remove x
duplicates 5
f Use text 
x functions
6
Sort and filter 7
data
Apply data 8
validation
Sheet +
Handle errors 1
effectively
attitudetallyacademy.co
m
Attitud
T H E  W O R L De O F  P R O F E S S I O N A L S
N  |  I S O  2 0 0 0  |  2 0 0 0  C O M PA N Y
Data 
Analysi
sExtract insights and 
make data-driven 
decisions
Pivot Tables and Pivot 
Charts
Conditional 
formatting
Summarize large 
datasets
attitudetallyacademy.co
m
Attitud
T HeE  W O R L D  O F  P R O F E S S I O N A L S
W T D  2 0 0 1  -  2 0 0 8  
C O M P A N Y
SALES 
DASHBOARD
Reports & 
Dashboard
s
Turn data into clear 
insights that drive better 
decisions MONTHLY BUSINESS 
REPORT
Professional 
reports
Charts and 
KPIs
Interactive 
dashboards
Business 
summaries
attitudetallyacademy.co
m
Attitud
T H E  W O R L D  O F  
P R O F E S S I O N A L S
M  I  S  O  9e0 0 1  :  2 0 0 8  
C O M P A N Y
What If 
Advanced Analysis
Excel 
Productivit Goal 
Tools y FeaturesPowerful features to analyze, X Seek
manage and work smarter
Advance Named 
d Ranges
Filtering
attitudetallyacademy.co
m
Attitud
T H E  W O R L D  O F  
P R O F E S S IeO N A L S
W  |  2 0 3 0  |  2 0 0 8  
C O M P A N Y
Practica
l
P& rJobje cts
SHankds-ionl plrsojects that strengthen 
your
skills and deliver real workplace 
reSsaulletss .
report
Attendance 
tracker
MIS 
report
Financial data 
analysis
Dashboard 
project
attitudetallyacademy.co
m
Attitud
T H E  W O R L D  O F  
P R OeF E S S I O N A L S
&  1 5 0 0 0 0 1  -  2 0 0 0  C O M PA N Y
Master Excel. 
Build Your 
CJoba-reardye er.
skills
Faster 
reporting
Better data 
Iamnaplryosviesd office 
productivity
Start 
ALedavrannincged Excel 
Today
attitudetallyacademy.co
m
THANK YOU
Thank you for joining us today. We hope you found this presentation valuable. We wish you all the best.
For more information, or visit 
our website:- 
Attitude Academy