Google IT Support Professional Certificate
The IT Support Professional Certificate, developed by Google and hosted on Coursera, can help learners become ready for an entry-level job in IT support in under 12 months. No experience is necessary.
This program utilizes a dynamic mix of hands-on labs and other interactive assessments, all developed by Googlers. This certificate program introduces learners to troubleshooting and customer service, networking, operating systems, system administration, and security — all the fundamentals of IT support that are critical for success in the workplace. And, throughout the program, learners will hear directly from Googlers whose own foundation in IT support served as a jumping off point for their careers.
Course 1 – Technical Support Fundamentals
Course 2 – The Bits and Bytes of Computer Networking
Course 3 – Operating Systems and You: Becoming a Power User
Course 4 – Systems Administration and IT Infrastructure Services
Course 5 – IT Security: Defense against the digital dark arts
Course Fee: $1,500
Online and alternative format Instructor Facilitated Training
Total Course Hours: 288
Classes starting September 14th, 2020
Proficiency in Microsoft Office Suite is an essential skill expected in today’s office environment.
This course is geared towards an audience with an intermediate level of computer experience. Learn formatting, how to navigate through workbooks and spreadsheets, create simple formulas, charts and tables. The mail merge feature of MS Word and Excel will be reviewed.
Location: NCCC Sanborn Campus, Room TBA
Cost: $120 per session or both for $215
Day One Agenda – Basic Excel
- Review structure of an Excel worksheets and Workbook
- Formatting data, worksheets, and workbooks
- Basic Excel Formulas and Functions
- Copy and Pasting Data into Excel
- Creating charts in Excel
Day 2 Agenda – Advanced Excel
- Importing data
- Pivot Tables and Pivot Charts
- Advanced Functions
- IF, AND, OR Functions
- LOOKUP functions
- COUNTIF, SUMIF, AVERAGEIF
- Conditional Formatting