Did you know Cybrary has FREE video training? Join more than 2,500,000 IT and cyber security professionals, students, career changers, and more, growing their careers on Cybrary.
Module 1: Course Introduction
Module 2: Working with Arrays
Module 3: Advanced Functions
Module 4: Creating Macros
Module 5: Importing Data From Other Programs
Module 6: Customizing Excel User Interface
Module 7: Map Charts
Module 8: Complex Practical Examples
Module 9: Course Summary
For this course, completion of an introduction to Excel course or, for those who have already mastered basic use of Excel, understanding the following: basic Excel operations, managing workbooks, data formats and layouts, creating formulas and creating charts as well as pivot tables. Also, for the Macros module, some basic programming knowledge is required. Students will need access to Office 2019 in order to perform the exercises in this course.
By the end of the course, students should be able to:
❏ Use arrays in functions and formulas ❏ Know how to work with most of Excel functions ❏ Create Macros in Excel ❏ Import data from other files and programs ❏ Customize the Excel user interface ❏ Use map charts ❏ Create complex data analysis formulas and structures
There will be exercise worksheets at the end of some modules with clear task that has to be finished. If needed, step-by-step instructions (cheat sheet) will be provided in separate file.