Microsoft Basic-Intermediate Excel

Mon Aug 16 2021 at 09:00 am to Tue Aug 17 2021 at 05:00 pm

Intellisoft Training | Singapore

Intellisoft Training Pte Ltd
Publisher/HostIntellisoft Training Pte Ltd
Microsoft Basic-Intermediate Excel Learn the simple tips and tricks in Excel, which make simple to complex tasks easy, with our step-by-step, practical, and hands-on Training.
About this Event

Lesson 1: Getting Started with Excel 2016

  • Starting Excel With Excel 2016
  • Using the Ribbon as the Excel 2016 User Interface
  • Navigating within the Worksheet
  • Selecting a Cell or Range of Cells
  • Entering Data
  • Entering Cell Contents
  • Cutting, Copying, and Pasting Cell Values
  • Copy and Paste Special
  • Saving your Workbook
  • Opening your Workbook

Lesson 2: Managing Rows & Columns in Excel 2016

  • Inserting, Moving & Deleting Cells
  • Managing Columns and Rows
  • Hide and Unhide Rows & Columns
  • Changing Column Width & Row Height

Lesson 3: Managing Worksheets in Excel 2016

  • Format Worksheet Tabs
  • Insert and Delete Worksheet
  • Move and Copy Worksheet
  • Hide & Unhide Worksheet

Lesson 4: Formatting Cells in Excel 2016

  • Formatting the Cell
  • Number and Date Formatting
  • Finding and Replacing Text
  • Working with Styles

Lesson 5: Working with Formulas & Functions

  • Excel Arithmetic Operators & Order of Operations
  • Using Auto Fill Options
  • Using Commonly Used Functions
  • Writing simple & useful Formulas on your own

Lesson 6: Organizing Worksheet & Table Data

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table
  • Formatting a Table For Reporting

Lesson 7: Working with Charts

  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Change the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart
  • Using Chart Titles & Placing Charts

Lesson 8: Working with Graphics

  • Adding Pictures into a Worksheet
  • Customizing Pictures and Objects
  • Adding Drawing Objects into a Worksheet
  • Adding SmartArt into a Worksheet
  • Adding Clip Art into a Worksheet

Lesson 9: Managing Large Workbooks with Excel 2016

  • Managing Large Workbooks
  • Printing Worksheets
  • Setting Page Setup Options
  • Setting Page Breaks

Lesson 10: Customizing & Enhancing Workbooks

  • Customizing Excel to the Way You Work
  • Creating Hyperlinks
  • Working with Workbook Themes
  • Working with Templates
  • New Templates in Excel 2016

Event Venue & Nearby Stays

Intellisoft Training, 06-05 Beach Road, Singapore, Singapore

Tickets

SGD 395.00

Sharing is Caring: