⏱ Duration7 hours
🏢 FormatOn-site delivery · Customized design
👤 InstructorJohn Kim
✅ Key OutcomeLearn real-world Google Sheets use cases and apply them on the job
The Google Sheets course is a 7-hour intensive program designed by John Kim, CEO of Nanum Consulting. It builds practical spreadsheet skills that boost work efficiency. Its 14 step-by-step modules take you from the basics to advanced features, and you learn the core skills for data analysis and work automation through hands-on practice. You will raise your personal productivity and learn to get the most out of Google Sheets as a team collaboration tool, a skill that is essential in the modern digital workplace. The curriculum draws on Nanum Consulting’s experience training at 50+ major corporations and institutions.
Who is this course for?
This course suits practitioners and leaders at companies and institutions that need IT & Digital skills. It is especially recommended for organizations aiming to “build proficiency with Google Sheets.”
What will you learn?
- Build Google Sheets proficiency
Curriculum
Module 1: 0.5 hr
- ᆞWhat is Google Sheets?
- ᆞSigning in with a Google account
- ᆞAccessing Google Drive and creating folders
- ᆞBasic file operations
Module 2: 0.5 hr
- ᆞCreating a spreadsheet and naming sub-sheets
- ᆞEntering data in cells
- • Trying out keyboard shortcuts
Module 3: 0.5 hr
- ᆞUnderstanding relative and absolute references
- ᆞMerging and splitting cells
- ᆞAdjusting table appearance and cell formatting
Module 4: 0.5 hr
- ᆞUsing data search and sort features
- ᆞBuilding a database
- • Analyzing data with filters
- • Using the Explore feature
Module 5: 0.5 hr
- ᆞUsing the SUM and average functions
- ᆞThe IF function: changing results by condition
- ᆞThe VLOOKUP function for extracting data
Module 6: 0.5 hr
- • Chart basics
- ᆞVarious chart styles
- ᆞPublishing charts to the web
Module 7: 0.5 hr
- ᆞCreating pivot tables and basic use
- ᆞAdvanced pivot table applications
- ᆞRestoring pivot table edit history
Module 8: 0.5 hr
- • Data protection settings
- ᆞCollaborating with co-editors (using comments and notes)
- ᆞSharing data and downloading for offline use
Module 9: 0.5 hr
- ᆞChanging text and number formats
- ᆞAdjusting fonts and cell height and width
- ᆞCreating easy-to-read tables
Module 10: 0.5 hr
- ᆞINDEX and MATCH functions
- ᆞThe QUERY function for searching data that meets multiple conditions
- • Using date and time functions
Module 11: 0.5 hr
- ᆞManaging data quality with input validation rules
- ᆞAutomating tasks with simple scripts
- ᆞAutomation and spreadsheet integration examples
Module 12: 0.5 hours
- • Highlighting data with conditional formatting
- • Analyzing data from different angles with filter views
- ᆞVisualizing summary data
Module 13: 0.5 hr
- ᆞReal-time co-editing and version history
- ᆞUsing real-time edit notifications
- ᆞTips for improving collaboration efficiency
Module 14: 0.5 hr
- • Real-world workplace use cases
- ᆞProject management and data tracking
- ᆞTips and tricks for advanced users
Expected results / After the course
- Learn real-world Google Sheets use cases and apply them on the job
On-site training references
Sahmyook UniversityKDI School of Public Policy and ManagementNanum Consultingand more
About the instructor
John KimInstructor John Kim, author of “B2B Marketing Design” and CEO of Nanum ConsultingView profile →
Related courses
We tailor this course to your company
From diagnosis to execution — Nanum Consulting
FAQ
It suits any role that needs data management and analysis, including office administration, planning, marketing, sales, HR, and finance. It is especially valuable for professionals who want to use a cloud-based collaboration tool instead of Excel.
John Kim’s hands-on training lets you learn step by step through 14 focused modules. Beyond explaining features, it provides practical templates and collaboration know-how you can apply to real work right away.
The 7 hours are divided into 14 modules of 0.5 hours each, enabling focused, step-by-step learning. Pricing varies by company size and number of participants, and we provide a customized quote after a consultation.
John Kim is a specialist instructor with many years in IT training, with on-site delivery experience at companies of all sizes, from large corporations to small and mid-sized businesses. As an expert in Google Workspace training for working professionals, he is known for high training satisfaction.
How to Use Google Sheets
The Google Sheets course is a 7-hour intensive program designed personally by John Kim, CEO of Nanum Consulting, to build practical spreadsheet skills that maximize work efficiency
Training objectives
- Build Google Sheets proficiency
Expected results
- Learn real-world Google Sheets use cases and apply them on the job
Curriculum
Module 1Module 1: 0.5 hr
- ᆞWhat is Google Sheets?
- ᆞSigning in with a Google account
- ᆞAccessing Google Drive and creating folders
- ᆞBasic file operations
Module 2Module 2: 0.5 hr
- ᆞCreating a spreadsheet and naming sub-sheets
- ᆞEntering data in cells
- • Trying out keyboard shortcuts
Module 3Module 3: 0.5 hr
- ᆞUnderstanding relative and absolute references
- ᆞMerging and splitting cells
- ᆞAdjusting table appearance and cell formatting
Module 4Module 4: 0.5 hr
- ᆞUsing data search and sort features
- ᆞBuilding a database
- • Analyzing data with filters
- • Using the Explore feature
Module 5Module 5: 0.5 hr
- ᆞUsing the SUM and average functions
- ᆞThe IF function: changing results by condition
- ᆞThe VLOOKUP function for extracting data
Module 6Module 6: 0.5 hr
- • Chart basics
- ᆞVarious chart styles
- ᆞPublishing charts to the web
Module 7Module 7: 0.5 hr
- ᆞCreating pivot tables and basic use
- ᆞAdvanced pivot table applications
- ᆞRestoring pivot table edit history
Module 8Module 8: 0.5 hr
- • Data protection settings
- ᆞCollaborating with co-editors (using comments and notes)
- ᆞSharing data and downloading for offline use
Module 9Module 9: 0.5 hr
- ᆞChanging text and number formats
- ᆞAdjusting fonts and cell height and width
- ᆞCreating easy-to-read tables
Module 10Module 10: 0.5 hr
- ᆞINDEX and MATCH functions
- ᆞThe QUERY function for searching data that meets multiple conditions
- • Using date and time functions
Module 11Module 11: 0.5 hr
- ᆞManaging data quality with input validation rules
- ᆞAutomating tasks with simple scripts
- ᆞAutomation and spreadsheet integration examples
Module 12Module 12: 0.5 hours
- • Highlighting data with conditional formatting
- • Analyzing data from different angles with filter views
- ᆞVisualizing summary data
Module 13Module 13: 0.5 hr
- ᆞReal-time co-editing and version history
- ᆞUsing real-time edit notifications
- ᆞTips for improving collaboration efficiency
Module 14Module 14: 0.5 hr
- • Real-world workplace use cases
- ᆞProject management and data tracking
- ᆞTips and tricks for advanced users
About the instructor
John Kim, Lead Instructor
10 years in industry · 15 years teaching (3,000+ lectures)
Education
· MBA (advanced major: Marketing), Korea University Graduate School of Business (graduated)
· Sungkyunkwan University Consultant Program (completed)
· Sogang University Graduate School of Business, Short-Term MBA (completed)
· Seoul National University Lifelong Education Instructor Development Program (completed)
· Chung-Ang University, B.A. in English Language and Literature (graduated)
Experience
· Current: CEO, Nanum Consulting
· Formerly at Hyosung Corp., Daeduck Electronics and Shinhan Diamond: overseas assignments and strategic planning (10+ years)
· Current partner instructor, Expert Consulting
· Current: Partner instructor, PSI Consulting
· (Current) Partner instructor, Korea SMEs and Startups Agency and SME Training Institute
Credentials and publications
· Certified consultant
· Certified teacher
· Completed official IDEO Design Thinking training
· B2B Marketing Design (1 Apr 2025)
· The Chinese Diamond Tool Market: Present and Future (co-authored, Korea Tool Association)
· Battles That Changed History and Innovative Weapons (in progress)