K-MOOC

주차

주차명

(주제)

주차별학습목표

차시

차시명

평가방법

학습내용

1

Introduction to the software

Introduction to the Microsoft Excel365

1-1

Start a Excel

1-2

Working with An Existing Workbook

1-3

Navigating a Worksheet

1-4

Navigating Data with the GO TO Command

2

Fundamentals of Excel

Learn the Fundamentals of Excel

2-1

Creating, naming and saving Workbooks

2-2

Saving in Different File Formats

2-3

Entering and Editing Basic Data in a Worksheet

2-4

Using Data Types to Populate a Worksheet

3

Using Office Backstage

How to use Office Backstage

3-1

Accessing and Using Backstage View and Print Options

Practical Test

3-2

Changing the Excel Environment

3-3

Customizing the Quick Access Toolbar and the Ribbon

3-4

Accessing and Using Excel Templates

4

Creating Basic Formulae

How to create Basic Formulae

4-1

Understanding and Displaying Formula

4-2

Using External Cell References

4-3

Referring to Data in Another Worksheet

4-4

Referencing Data in Another Workbook

5

Using FUNCTIONS in Excel

How to use FUNCTIONS in Excel

5-1

Summarizing Data with Functions

5-2

Using the SUM Function

5-3

Using the COUNT and COUNTBLANK Functions

5-4

Using the AVERAGE Function

6

Format Cells and Ranges

How to Format Cells and Ranges

6-1

Formatting Excel Worksheets

Quiz

6-2

Inserting and Deleting Cells

6-3

Formatting Cells with Styles

6-4

Applying Conditional Formatting to Cells

7

Format worksheets

How to Format worksheets

7-1

Working with Rows and Column

7-2

Using Themes

7-3

Inserting Headers and Footers

7-4

Transposing Rows or Columns

8

Organise Worksheets

How to Organise Worksheets

8-1

Organizing Worksheets

Midterm Exam

8-2

Working with Multiple Worksheets

8-3

Using Zoom and Freeze to Change the Onscreen View

8-4

Finding and Replacing Data

9

Work with Excel Database

How to work with Excel Database

9-1

Sorting Data

9-2

Sorting Data on A Single and Multiple Criterion

9-3

Filtering Data

9-4

Using Data functions

10

Create Charts

How to Create Charts

10-1

Building Charts

10-2

Formatting A Chart with A Quick Style or Layout

10-3

Modifying A Chart

10-4

Deleting Elements from A Chart

11

Secure Workbooks

How to Secure Workbooks

11-1

Securing Workbooks

Practical Test

11-2

Using the Document Inspector

11-3

Tracking Changes to A Workbook

11-4

Adding Comments to A Workbook

12

Insert Images and Shapes

How to Insert Images and Shapes

12-1

The Insert Tab’sIllustration and Text Tools

12-2

Inserting Pictures

12-3

Adding Shapes

12-4

Adding Graphic Enhancements

13

Print Worksheets

How to Print Worksheets

13-1

Using the printer settings

Quiz

13-2

Changing page settings

13-3

Customise margins

13-4

Page scaling and page setup

14

Customise Excel Templates

How to Customise Excel Templates

14-1

Using excel templates

14-2

Create new colour themes

14-3

Switch or remove a theme

14-4

Changing default themes

15

Final Exam