Menguasai Microsoft Excel untuk Persiapan Ujian Sertifikasi MO-200 bagi Tenaga Perkantoran Umum

Video Preview

• Introduction Course: Menguasai Microsoft Excel

  • Introduction Course: Menguasai Microsoft Excel

    -m

  • Apa itu Microsoft Office Specialist (MOS)?

    -m

  • Ujian Sertifikasi Microsoft Office Specialist

    -m

• Manage Worksheets and Workbooks

  • Import Data From .txt Files

    -m

  • Import Data From .csv Files

    -m

  • Search For Data Within A Workbook

    -m

  • Navigate To Named Cells, Ranges, Or Workbook Elements

    -m

  • Insert And Remove Hyperlinks

    -m

  • Modify Page Setup

    -m

  • Adjust Row Height And Column Width

    -m

  • Customize Headers And Footers

    -m

  • Customize The Quick Access Toolbar

    -m

  • Display And Modify Workbook Content In Different Views

    -m

  • Freeze Worksheet Rows And Columns

    -m

  • Change Window Views

    -m

  • Modify Basic Workbook Properties and Display Formulas

    -m

  • Set A Print Area

    -m

  • Save Workbooks In Alternative File Formats

    -m

  • Configure Print Settings

    -m

  • Inspect Workbooks For Issues

    -m

• Manage Data Cells and Ranges

  • Paste Data By Using Special Paste Options

    -m

  • Fill Cells By Using Auto Fill

    -m

  • Insert And Delete Multiple Columns Or Rows

    -m

  • Insert And Delete Cells

    -m

  • Merge And Unmerge Cells

    -m

  • Modify Cell Alignment, Orientation, And Indentation

    -m

  • Format Cells By Using Format Painter

    -m

  • Wrap Text Within Cells

    -m

  • Apply Number Formats

    -m

  • Apply Cell Formats From The Format Cells Dialog Box

    -m

  • Apply Cell Styles

    -m

  • Clear Cell Formatting

    -m

  • Define A Named Range

    -m

  • Name A Table

    -m

  • Insert Sparklines

    -m

  • Apply Built-In Conditional Formatting

    -m

  • Remove Conditional Formatting

    -m

• Manage Tables and Table Data

  • Create Excel Tables From Cell Ranges

    -m

  • Apply Table Styles

    -m

  • Convert Tables To Cell Ranges

    -m

  • Add Or Remove Table Rows And Columns

    -m

  • Configure Table Style Options

    -m

  • Insert And Configure Total Rows

    -m

  • Filter Records

    -m

  • Sort Data By Multiple Columns

    -m

• Perform Operations by using Formulas and Functions

  • Insert Relative, Absolute, And Mixed References

    -m

  • Reference Named Ranges And Named Tables In Formulas

    -m

  • Perform Calculations By Using The Average(), Max(), Min(), And Sum() Functions

    -m

  • Count Cells By Using The Count(), Counta(), And Countblank() Functions

    -m

  • Perform Conditional Operations By Using The If() Function

    -m

  • Format Text By Using Right(), Left(), And Mid() Functions

    -m

  • Format Text By Using Upper(), Lower(), And Len() Functions

    -m

  • Format Text By Using The Concat() And Textjoin() Functions

    -m

• Manage Charts

  • Create Charts

    -m

  • Create Chart Sheets

    -m

  • Add Data Series To Charts

    -m

  • Switch Between Rows And Columns In Source Data

    -m

  • Add And Modify Chart Elements

    -m

  • Apply Chart Layouts

    -m

  • Apply Chart Styles

    -m

  • Add Alternative Text To Charts For Accessibility

    -m

• Closing: Menguasai Microsoft Excel

  • Closing: Menguasai Microsoft Excel

    -m