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

NobleProg Training Institute Logo

Microsoft Access - Download The Data

The course is designed for persons with pre-information databases using SQL queries or queries.

by NobleProg Training Institute [Claim Listing ]
New Horizons Singapore Logo

Microsoft Access

Demonstrate that you have the skills needed to get the most out of Access by earning the Microsoft Office Specialist: Access Associate or Expert Certification. This certification demonstrates competency in database design principles.

by New Horizons Singapore [Claim Listing ]
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]
Ask Training Logo

Microsoft Excel Power Query, Data Model, Power Pivot & DAX (Intro)

This course introduces Microsoft Excelā€™s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX).Ā 

by Ask Training [Claim Listing ]
St.Hua Private School Logo

Microsoft Access Essentials

Microsoft Access is a general-purpose, versatile and powerful database management software. In this course, you will build databases that store and retrieve data efficiently, as well as editing and modifying fields and records.

by St.Hua Private School [Claim Listing ]

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