ted-learning-logo

Microsoft Excel 2016/2019 Basic & Intermediate

Join Microsoft Excel 2016/2019 Basic & Intermediate training course to gain better understanding of many Excel features such as formulas & charts.

Free

2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

This course covers the very basics of the Excel spreadsheet. It is suitable for complete beginners without prior knowledge of Excel. At the end of this course you will have good understanding of the basic Excel features and you will be able to create a simple, presentable spreadsheet. The the intermediate level understanding of the spreadsheet. It is suitable for beginners wanting more knowledge on formulas and creating simple charts. At the end of this course you will have better understanding of the Excel features and you will be able to create formulas and charts.

What Will I Learn From This Course?

Understand basic spreadsheet concepts

Create basic formulas

Format worksheets

Use multiple worksheets

Create bar, lines and pie charts

Create drawings & picture objects

Print worksheets and graphs

Pre-requisites

Knowledge of Microsoft Windows

Course Outline for This Programme

  1. What’s new in Excel 2016/2019
  2. 2016/2019 Landing Page
  3. Managing the Account & Services
  4. Documents On The Go
    i. Privacy guaranteed
    ii. Sharing Files
  5. Charting in Excel 2016/2019
  6. Analyze data in real-time using Quick Analysis
  7. The Revised Insert Tab
    i. Excel recommendations
    ii. Search & Insert Online Pictures
    iii. Office Apps
  8. Comprehensive Data Sources
    i. Power View
    ii. Flash Fill
  1. Creating A New Workbook
  2. The Excel Interface
    i. The Quick Access Toolbar
    ii. File Tab
    iii. Home Tab
    iv. Insert Tab
    v. Page Layout Tab
    vi. Formulas Tab
    vii. Data Tab
    viii. Review Tab
    ix. View Tab
    x. Developer Tab
    xi. Contextual Tabs
  3. Using Accelerator Keys
  4. Using The Dialog Box Launcher
  5. Saving A Workbook
  6. Opening A Workbook
  7. Creating A Workbook from a Template
  8. Switching to Another Workbook
  9. Navigating In Excel Using Keyboard
  10. Selecting A Range
    i. Continuous range
    ii. Non Continuous range
  11. Current Region
  1. Entering and Editing Data
    i. Entering Data
    ii. Editing Data
  2. Moving and Copying Cell Contents
    i. Moving cell contents
    ii. Copying Contents of cell / cells
  3. AutoFill
  4. Custom Lists
  5. Using the Fill Command
  6. Flash Fill
  1. Understanding Formulas
    i. Operators
    ii. Using Cell references in Formulas
  2. Functions
    i. AutoSum
    ii. Average Function
    iii. Max Function
    iv. Min Function
    v. COUNT
    vi. COUNTA
  1. Formatting Columns
    i. Modifying Column Width
    ii. Inserting columns
    iii. Deleting Columns
    iv. Modifying Row Height
    v. Inserting Rows
    vi. Deleting Rows

  2. Formatting Text
    i. Changing the Font type
    ii. Changing the Font Size
    iii. Changing the Font Color
    iv. Bold, Italics and Underline

  3. Formatting Numbers
    i. Commonly Used Number Formats
    ii. Applying Currency Formats
    iii. Applying the Comma format
    iv. Applying Percentage styles
    v. Increasing or Decreasing Decimals

  4. Changing Alignment
    i. Horizontal and Vertical Text Alignment
    ii. Merging Cells
    iii. Text Wrapping
    iv. Text Orientation

  5. Borders and Shading
    i. Applying Borders
    ii. Applying Cell Colors

  6. Format Painter

  7. Applying Cell Styles

  1. Setting up your Worksheets
    i. Page Breaks
    ii. Setting Page Orientation
    iii. Setting Margins
    iv. Setting Headers and Footers
    v. Setting a Print Area

  2. Print Titles

  3. The Scale To Fit

  4. Sheet Options

  5. Previewing your Worksheet

  6. Printing your Worksheet

  1. Adjusting Zoom
    i. To use the Zoom Slider
    ii. To use Zoom from the Ribbon
    iii. To use the Zoom dialog box
    iv. To use Zoom to Selection

  2. Using Multiple Windows
    i. To open multiple windows of a single worksheet

  3. To open multiple windows of several workbooks
    i. To open a window for each worksheet in a Workbook

  4. Using Freeze Panes
    i. To freeze panes
    ii. To unfreeze panes
    iii. To freeze the first column only

  5. Using Split Windows
    i. To split a worksheet
    ii. To remove the split
    iii. To split using icons

  6. Custom Views
    i. To create a custom view of the whole sheet
    ii. To display a saved view
    iii. To delete a saved view

  7. Hiding and Unhiding Worksheets and Workbooks
    i. Hide a worksheet
    ii. Display a hidden worksheet

  8. Working With Multiple Worksheets

  9. Renaming Worksheet Tabs
    i. Changing Worksheet Tab Colors

  10. Inserting Worksheets
    i. Inserting Worksheets: Ribbon Option
    ii. Inserting Worksheets: Right Click Option
    iii. Inserting Worksheets: Button Option

  11. Moving Worksheets
    i. Moving Worksheets: Same Workbook using the Ribbon
    ii. Moving Worksheets: Same Workbook, Right Click
    iii. Moving Worksheets: Same Workbook, Drag and Drop Option
    iv. Moving Worksheets: Different Workbook

  12. Copying Worksheets
    i. Copying Worksheets: Same Workbook using the Ribbon
    ii. Copying Worksheets: Same Workbook using Right-click
    iii. Copying Worksheets: Same Workbook, Drag and Drop Option
    iv. Copying Worksheets: Different Workbook

  13. Deleting Worksheets

  14. Grouping and Ungrouping Sheets
    i. Grouping Worksheets
    ii. Ungrouping Worksheets

  1. Cell References: Relative and Absolute
    i. Relative cell references
    ii. Absolute cell references
    iii. Mixed Cell References
  2. Inserting Dynamic Dates and Times
    i. Inserting a Dynamic Date Only
    ii. Inserting a Dynamic Date and Time
  3. Inserting Static Dates and Times
    i. Inserting a Static Date
    ii. Inserting a Static Time
  4. Mathematical Functions
    i. COUNTIF
    ii. SUMIF
  1. Quick Analysis
    i. Formatting
    ii. Charts
    iii. Totals
    iv. Tables
    v. Pivot Tables
    vi. Sparklines
  1. Applying Cell Highlighting

  2. Applying Top, Bottom, and Average Rules

  3. Applying Data Bars, Color Scales, and Icon Sets
    i. Data Bars
    ii. Icon Sets

  4. Creating a Customized Rule

  5. Editing Rules

  6. Prioritizing Rules

  7. Deleting Rules

  1. Customizing your Workbook

  2. Inserting a Symbol or Special Character

  3. Adding and Editing Shapes

  4. Creating and Altering Diagrams
    i. Changing the Diagram Type

  5. Incorporating Text

  6. Adding a Signature Line

  7. Working with Text Boxes
    i. Adding a Text Box
    ii. Selecting a Text Box
    iii. Manipulating a Text Box
    iv. Formatting a Text Box

  8. WordArt

  9. Adding WordArt to your Spreadsheet
    ii. Changing the Font Color
    iii. Changing the Outline Color
    iv. Adding Effects
    i. ClipArt
    i. Finding ClipArt
    ii. Inserting ClipArt
    iii. Manipulating ClipArt

  10. Inserting a Photographic Image
    i. Insert a Photographic Image Stored on your Computer
    ii. Insert a Photographic Image from the Web

  11. Formatting a Photographic Image

  1. What is a Chart?
    i. Understanding How Excel Handles Charts

  2. Excel 2013/2016 Recommended Chart

  3. Inserting A Chart
    i. Column
    ii. Bar
    iii. Line
    iv. Pie
    v. Area
    vi. X-Y Scatter
    vii. Surface
    viii. Doughnut
    ix. Stock
    x. Radar
    xi. Bubble
    xii. Cylinder, Cone, and Pyramid

  4. Elements of a Chart
    i. Adding Chart Elements
    ii. Title
    iii. X or Category axis
    iv. X Axis Title
    v. Y or Value axis
    vi. Y Axis Title
    vii. Legend
    viii. Tick marks
    ix. Gridlines
    x. Series
    xi. Plot area

  5. Chart Styles (Formatting a Chart)
    i. Change the Chart Type
    ii. Changing the Chart Location
    iii. Display a Chart Title
    iv. Customize the Chart Legend
    v. Displaying a Data Table in a Chart
    vi. Show Data Labels
    vii. Connect data labels to data points using leader lines
    viii. Select a Chart Color Style
    ix. Change Axis Options
    x. Axes
    xi. Gridlines
    xii. Adding Text Boxes With Links
    xiii. Place a Picture in a Data Series

  6. 3-D Charts
    i. Enhance a 3-D Chart

  7. Adjust Chart Data

  8. Filtering Chart Data

  9. Working with Charts
    i. Moving and resizing a chart
    ii. Copying a chart
    iii. Deleting a chart
    iv. Printing Charts

  10. Chart Tips.

Curriculum is empty
Julian

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications

whatsapp-icons
whatsapp-icons