Learn step-by-step how to easily and elegantly complete spreadsheets and data using Numbers in a Mac environment. A complete Numbers guide that covers everything from basic data entry to functions, chart utilization, and collaboration, all focused on practical application!
4 learners are taking this course
Level Beginner
Course period 12 months
You can learn the main features and interface of Numbers to efficiently create spreadsheets.
You can develop the ability to accurately calculate and analyze data using formulas and functions.
You can create high-quality reports and documents by utilizing visual materials such as tables, charts, and images.
You can complete logical and practice-oriented documents by utilizing collaborative features and document management methods.
Analyze and communicate complex data smartly with Numbers!
Are you getting headaches from complex data work like finance, statistics, and reports?
Everyone has probably experienced feeling overwhelmed from the start due to Numbers' unique interface and features that differ from Excel. Now overcome the difficulties of data work through the Numbers course and achieve both efficiency and accuracy!
In this course, you'll learn step-by-step how to use Numbers, the flagship program of iWork that maximizes spreadsheet work efficiency in Mac environments.
Lesson 10: Learning Frequently Used Functions
Sections 1-2 cover the basics of Numbers, text input, and formula/function usage to build a foundation for data work.
Sections 3-4 develop data analysis and visualization skills through advanced features such as in-depth use of frequently used functions, media and chart insertion.
Finally, Section 5 is a comprehensive course that enhances practical skills by creating documents needed for actual work.
You can understand the main features and interface of Numbers and quickly create documents.
You can accurately perform automatic data calculation and analysis using formulas and various functions.
Effectively utilize visual materials such as images, tables, and charts to enhance the completeness of documents.
You can implement a collaboration-focused work environment by utilizing collaborative work and document sharing features.
iWork - Numbers: A core tool used for creating spreadsheets and managing data in Mac environments
Section 1. Learning Numbers Basics
Numbers interface and learn how to manage spreadsheets and input text.
Getting Started with Numbers
Spreadsheet File Management
Text Input and Editing I
Text Input and Editing II
Section 2. Table Structure and Formula/Function Utilization
Learn how to structure tables and efficiently calculate and analyze data using formulas and functions.
Add table
Table Structure and Editing I
Table Structure and Editing II
Understanding and Basic Usage of Formulas
Section 3. Advanced Function Applications
We cover frequently used functions in depth to enhance your data processing and analysis capabilities.
Mastering Frequently Used Functions I
Mastering Frequently Used Functions II
Mastering Frequently Used Functions III
Mastering Frequently Used Functions IV
Section 4. Inserting and Managing Visual Elements
Insert and edit visual elements such as media, shapes, and charts to enhance the visual communication of data.
Insert Media Content
Shape Insertion and Editing
Object Editing
Chart Insertion and Editing
Section 5. Practical Project
Develop practical skills by directly creating documents needed for actual work.
[Practical Edition] Document Writing I
[Practical Edition] Document Writing II
[Practical Edition] Using Functions I
[Practical] Using Functions II
This course does not provide instructor Q&A.
Lecture materials and lesson plans can be downloaded from [Class Materials] in the first lesson of each section.
Who is this course right for?
Office workers and freelancers who want to systematically learn spreadsheet creation and data management
Mac users who are new to Numbers or want to enhance their practical application skills
Anyone who wants to directly create documents utilizing data such as finance, statistics, and reports
8,280,835
Learners
6,646
Reviews
4.6
Rating
336
Courses
I will help you grow through useful IT lectures.
All
25 lectures ∙ (10hr 39min)
Course Materials:
Check out other courses by the instructor!
Explore other courses in the same field!
25% off for new members
$41.60
25%
$61.60
![[Photoshop Revolution Broadcast] Photoshop Basics CompleteCourse Thumbnail](https://cdn.inflearn.com/wp-content/uploads/photoshop002.jpg?w=420)
![How to Make a Unity 2D Roguelike Game [Korean Subtitles]Course Thumbnail](https://cdn.inflearn.com/wp-content/uploads/unity003.jpg?w=420)
![[Photoshop Revolution Broadcast] Photoshop Advanced Completion - Mastering the Pen ToolCourse Thumbnail](https://cdn.inflearn.com/wp-content/uploads/photoshop001.jpg?w=420)
