TeachMeSoft: Daftar Isi Excel

PENGENALAN AWAL

⏬
⏬

BAB I MEMBUAT DAN MENGELOLAH DOKUMEN

1. Membuat Dokumen dan Membuka File Non-Asli

2. Menavigasi Dokumen

3. Format Dokumen

4. Kustomisasi Opsi dan Tampilan Dokumen

5. Konfigurasikan Dokumen untuk dicetak atau disimpan

BAB II FORMAT TEKS, PARAGRAF DAN SECTION

1. Menyisipkan teks dan paragraf

2. Format Teks dan Paragraf

3. Grup text dan Paragraf

BAB III MEMBUAT TABEL DAN LIS

1. Membuat Tabel

2. Modifikasi Tabel

3. Membuat dan Memodifikasi Lis

BAB IV MENERAPKAN REFERENCES

1. Membuat endnotes, footnotes, and citations

2. Membuat Caption

BAB V MENYISIPKAN DAN MEMFORMAT OBJEK

1. Menyisipkan dan Memformat Building Block

2. Menyisipkan dan Memformat Shape dan SmartArt

3. Menyisipkan dan Memformat Picture

Microsoft Excel 2013
Prerequisites
Managing worksheets
Managing worksheet content
Managing Excel tables
Managing data entries

1 Create and manage workbooks and worksheets
1.1 Create workbooks and worksheets
Creating new workbooks and worksheets
Reusing existing content
Practice tasks
1.2 Navigate through worksheets and workbooks
Locating data and worksheet elements
Inserting hyperlinks
Practice tasks
1.3 Format worksheets and workbooks
Modifying page setup
Inserting page elements
Changing workbook themes and colors
Modifying rows and columns
Configuring data validation
Practice tasks
1.4 Customize options and views for worksheets and workbooks
Displaying different views of worksheets
Displaying multiple parts of a workbook
Hiding and displaying workbook content
Customizing the Quick Access Toolbar
Customizing the ribbon
Working with macros
Modifying workbook properties
Practice tasks
1.5 Configure worksheets and workbooks to print or save
Printing workbook content
Saving workbooks
Practice tasks
Objective review

2 Manage cells and ranges
2.1 Insert data in cells and ranges
Creating data
Reusing data
Practice tasks
2.2 Format cells and ranges
Formatting cell structure
Formatting cell content
Applying number formats
Copying formatting
Practice tasks
2.3 Order and group cells and ranges
Modeling data
Creating named ranges
Working with data groups and summaries
Practice tasks
Objective review

3 Manage tables
3.1 Create tables
Practice tasks
3.2 Modify tables
Practice tasks
3.3 Filter and sort tables
Practice tasks
Objective review

4 Apply formulas and functions
4.1 Utilize cell ranges and references in formulas and functions
Referencing cells and cell ranges in formulas
Defining order of operations
Practice tasks
4.2 Summarize data by using functions
Practice tasks
4.3 Utilize conditional logic in functions
Practice tasks
4.4 Format and modify text by using functions
Practice tasks
Objective review

5 Create charts and objects 121
5.1 Create charts
Practice tasks
5.2 Format charts
Practice tasks
5.3 Insert and format objects
Adding pictures to sheets
Adding text boxes to sheets
Adding SmartArt graphics to sheets
Practice tasks
Objective review