Microsoft Excel Course

Microsoft’s Excel is more than just an online spreadsheet. From its humble beginnings, the Excel program is now the main online spreadsheet employed by everyone. Be it simple home accounting to modular solutions in major corporations, Excel is used by everyone everywhere on an everyday basis. For anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis, this Excel course is for you. After attending our Excel course physically or online, participants will be familiar with the workings of Excel and confidently produce spreadsheets and calculated totals.

No prior knowledge of Microsoft Excel is required for this course here in Singapore. However, participants will need to be familiar with basic operations of a PC, such as using a mouse and managing of program files and folders. A combination of lectures, explicit teaching, practical demonstrations, and peer teaching are applied to deliver this Excel course.

Key Takeaways

Upon completion of this workshop, participants will be able to;

• Forms an excellent formal introduction to Microsoft Excel
• Learn the art of number crunching in a spreadsheet
• Be familiar with the workings of Excel
• Be able to confidently produce spreadsheets and calculated totals

Who Should Attend

Anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis.

Programme Outline

Module 1: Excel Basics

• Interface, Ribbon & Quick Access Toolbar
• Using the File Tab
• Opening & Saving Excel Files
• Spreadsheet Layout & Navigation
• Getting Help

Module 2: Data Entry

• Selecting Cells
• Entering, Editing & Deleting Data
• Data Entry Shortcuts
• Moving & Copying Data
• Using Paste Options

Module 3: Worksheets & Workbooks

• Workbook Organisation
• Worksheet Organisation

Module 4: Formatting

• Columns & Rows
• Text Formatting
• Alignment, Wrapping and Indentation
• Numbers
• Borders & Shading
• Clearing Formatting
• Applying Cell Styles
• Using the Format Painter
• Working with Themes
• Using Conditional Formatting
• Formatting & Applying Table Styles
• Formulas & Functions
• Formulas in Excel
• Functions

Module 5: Charts

• Introduction to Charts in Excel
• Building Basic Charts
• Chart Editing & Formatting
• Working with Quick Analysis
• Inserting Sparklines

Module 6: Printing

• Print Options
• Print Preview
• Printing Charts

Module 7: Templates

• Using Templates
• Creating & Modifying Templates
• Saving on Existing Workbook as a Template

Module 8: Protections

• Overview of Data Protection
• Locking & Hiding Cells
• Setting Spreadsheet Passwords
• Worksheet & Workbook Protection
• File Protection

Methodologies

No foreknowledge of Excel is required. Participants need only be familiar with the operations of a PC, such as mouse handling and file management.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied to this course.

Course Enquiry

For more information on our Excel courses here in Singapore, please complete the enquiry form.