Colleges and Universities
Digital Technology
Textbook Publishers
ITI 305 MS Excel 2016 Level III
Course Outline:
Work with advanced formulas, lookup functions. Learn data validation; how to import/ export data. Work with PivotTables and PivotCharts. Use analytical features -Goal Seek and Analysis tool, run and record macros. Students pursuing the Microsoft Office Specialist Certification must take MS Excel I, II and II.
Prerequisites:
MS Excel-Level II or equivalent experience.
Required Textbook & Materials
- Title: Excel 2016 Level 3
- ISBN: 978-1-943248-58-2
- Publisher: 30Bird media
Materials:
Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.
Meeting Information:
Lesson Plan:
Session I
- Course Overview Presentation
- Chapter 1: Logical and Lookup Functions
- Chapter 2: Advanced Formulas
- Chapter 3: Special functions
Session II
- Chapter 4: Importing and Exporting
- Chapter 5: Analysis
- Chapter 6: Macros and Forms