$407.86

Microsoft Basic-Intermediate Excel

Actions and Detail Panel

$407.86

Event Information

Share this event

Date and time

Location

Location

Intellisoft Training

06-05 Beach Road

Singapore, 199588

Singapore

View Map

Refund policy

Refund policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Event description
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
Share with friends

Date and time

Location

Intellisoft Training

06-05 Beach Road

Singapore, 199588

Singapore

View Map

Refund policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

{ _('Organizer Image')}

Organiser Intellisoft Training

Organiser of Microsoft Basic-Intermediate Excel

Intellisoft Training Pte. Ltd. was setup by industry leading experts from the Education industry for the sole purpose of providing quality training to companies and individuals, which lead to Best-in-Class Industry Certifications.

These short training courses help companies to improve their productivity, efficiency and save time.

Intellisoft Training Pte. Ltd. has partnered with ICDL Asia to highest rated International Computer Driving Test Accreditation to Singapore. We are an Approved ICDL Test Center to conduct all ICDL Core and ICDL Advanced Courses in Singapore.

Save This Event

Event Saved