[go: up one dir, main page]
Scribd
Upload
16 views3 pages

Excel Course Outline

The Excel course consists of six sessions covering objectives, basics, and advanced features of Excel. Participants will learn about data analysis, formatting, equations, and advanced functions like VLOOKUP and Pivot Tables. The course concludes with a final exam to assess knowledge gained.

Uploaded by

hany0604
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views3 pages

Excel Course Outline

The Excel course consists of six sessions covering objectives, basics, and advanced features of Excel. Participants will learn about data analysis, formatting, equations, and advanced functions like VLOOKUP and Pivot Tables. The course concludes with a final exam to assess knowledge gained.

Uploaded by

hany0604
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Excel Course Outline

Session 1:
- The objectives of learning Excel.
o Help in analyzing data accurately.
o Make sound strategic decisions.
- Excel Basics.
o Open Excel.
o Right to Left.
o Rows, columns and cells formatting.
o Ribbon Tools Uses.
o Wrap & Merge Cells.
o Freeze Pane
o Sort & Filter
o Find & Replace

Session 2:
- Using Sheets in Excel
o Add a new sheet.
o Drop Down Menu.
o Date & Time Formatting.
o Links between 2 Sheets.
o Preparing the file for printing.
o Print Preview.
o Header & Footer.
o Page Layout.
- Session 3:
- Starting with Equations
o Arithmetic Operations Priorities.
o SUM.
o AVERAGE.
o COUNT.
o MAX.
o MIN.
o MOD
o IF Statement.

- Session 4:
- Date & Count Equations
o TODAY.
o NOW.
o DATE.
o TIME.
o DATEIF.
o COUNT.
o COUNTA.
o COUNTBLANK.
o COUNTIF.
- Session 5:
- Advanced Equations
o SUBTOTAL.
o VLOOKUP.
o CONCAT.
o MID.
o TRIM.
o UPPER.
o LOWER.
o ROUND.
o CEILING.
o Pivot Table.

- Session 6:
- Final Exam.

You might also like