Microsoft MS Excel 2013, 2016, 2019 and 365 (Basic to Intermediate)

by Intuition International Claim Listing

The reasons why our courses MS Office,isĀ  the most popular course.

S$280

Contact the Institutes

Fill this form

Advertisement

Intuition International Logo

img Duration

8 Hours

Course Details

The reasons why our courses MS Office,is  the most popular course

 

Microsoft Excel Course Plan:

4Hrs:

  • Purpose of Excel
  • Navigate and Select Cells in Worksheets 
  • Create a Basic Worksheet 
  • Inputting data
  • Fixed-Width Fonts
  • Inserting, Renaming, Deleting Rows and Columns 
  • Add Borders and Colours to Cells 
  • Change column width and row height
  • Merge Cells and Wrap Text
  • Apply Number Formatting 
  • Apply Font Properties 
  • Edit Worksheet Data 
  • Find and Replace Data 
  • Autofill Data
  • Data Segregation using Text to Column
  • Working with Lists - Sorting and Filtering (> versus >=, <  versus <=, AND versus OR).
  • Sort and Filter by Color
  • Deleting Every Other Row

 

4Hrs

  • Create Formulas in a Worksheet 
  • Understand commonly used Functions like SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, ROUND, ROUNDUP, ROUNDDOWN.
  • Insert Functions in a Worksheet 
  • Reuse Formulas
  • Create Formulas using $ sign 
  • IF, SUMIF and COUNTIF
  • Insert Text to Column
  • Transposing Data 
  • Inserting Header and Footer 
  • Align Content in a Cell 
  • Apply Page Break, Split and Freeze Panes
  • Creating 2D and 3D Charts
  • Showing Data Labels, Legend, Titles, Format
  • Moving and copying Worksheet 
  • Inserting, Renaming, Deleting, Hiding Worksheet 
  • Save and Print a Worksheet
  • Central Branch

    52 Telok Blangah Road, Central

Check out more MS Excel courses in Singapore

ARC Learning Academy Limited Logo

Using Microsoft Word For Personal Productivity

Microsoft Word is easy to use for document creation and word processing. Learners will be taught the basics such as creating and saving documents, formatting text, inserting graphics and special characters, and organizing data in tables.

by ARC Learning Academy Limited [Claim Listing ]
  • Price
  • Start Date
  • Duration
ITEL Learning Systems Logo

Microsoft PowerPoint Courses

Microsoft PowerPoint is full of features which allow you to present information in a concise and exciting format. ITEL Learning Systems has Microsoft PowerPoint courses and training that you will need to help you create professional and captivating presentations.

by ITEL Learning Systems [Claim Listing ]
Ccisg Logo

Microsoft Office 2016/2019/365 Timesaving Quick Tips

This course aims at equipping participants with timesaving tips and tricks in Microsoft Excel, Microsoft Word and Microsoft PowerPoint that will boost up their work productivity.

by Ccisg [Claim Listing ]
Global Training Partners Logo

MS Access 2013 Course

Outlook 2013 training is offered by Global Training Partners.Ā University professors and national experts create our course curriculum.

by Global Training Partners [Claim Listing ]
Koenig-Solutions Logo

Microsoft Visio With VBA Course

Microsoft Visio with VBA Certification validates professionals' expertise in using Microsoft's diagramming and vector graphics software, Visio, combined with Visual Basic for Applications (VBA), to automate repetitive tasks and enhance functionality.

by Koenig-Solutions [Claim Listing ]

Ā© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy