Participants will develop fundamental Excel skills, including setting up spreadsheets, entering and manipulating data, and using AutoFill to save time. They will also learn how to print spreadsheets correctly, create basic formulas and functions, and edit and format data efficiently. By the end of the course, students will be equipped to manage large workbooks and use Excel’s core features to improve productivity.
Course Dates TBD
Participants will learn to summarize data with PivotTables, clean data using text functions, and automate tasks with logical functions like AND, IF, and OR. The course also covers lookup functions such as VLOOKUP and INDEX/MATCH, converting data into Excel tables, and adding objects like logos to workbooks. Additionally, participants will explore data protection techniques. By the end, participants will be equipped to handle more advanced tasks and increase productivity in Excel.
Course Dates TBD
Participants will learn to use data validation, create macros, and apply tools like scenarios and goal seek for "what-if" analysis. The course also covers auditing worksheets, working with external data, and inserting hyperlinks. Participants will learn to manage multiple workbooks, create forms, and get an introduction to Visual Basic for automating tasks. By the end, participants will be proficient in advanced Excel techniques to enhance productivity and data management.
Course Dates TBD
