Outcome – Learn to navigate the Excel user interface expertly, perform basic to intermediate calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
What Will I Learn?
Microsoft Excel remains the go-to software for persons seeking quick data analysis.
Learn a marketable skill.
Work Smarter rather than harder
Topics for this course
Create and format workbooks.
Analyze and present data
Building basic formulas
Harnessing the power of functions?
Working with text functions
Working with logical and information
Working with lookup functions
Working with date and time functions
Working with math functions
Create and manage, filter and sort tables.
Create charts and objects.
Collaborate and share in Excel.
Introduction to PivotTables
Learners should be age 16 or over and must have a basic understanding of Maths, English, and ICT.
No prior knowledge is required.
Students must have access to a computer
Desktop computer or laptop
Operating system Windows 10
Adobe Acrobat Reader
High-Speed Internet connection (Hotspots are not recommended)
Webcam (Built-in or external)
Microphone (Built-in or external)
Note: The latest version of ALL applicable Microsoft software will be provided by ICTC.
New Excel users who want to learn Excel spreadsheet fundamentals and get up to speed with an overview of what Excel offers. Existing Excel users who are self-taught in using spreadsheets or would like a refresher course of Excel’s essential features and principles.
Please note with immediate effect, ICTC has indefinitely discontinued All technical courses that require hands-on/In-person participation.
We are currently only offering Microsoft Office, Computer Essentials and Accounting Online Courses.
We sincerely apologize for any inconvenience, however the maintenance of proper health and safety guidelines for both our instructors and students is of critical importance at this time. Thank you for your ongoing support. Stay safe, keep sanitized and stay at home