Introduction to Excel (in English)
Hello all. This is a basic course suitable for those with no, or almost no knowledge of Microsoft Excel.
As implied, we will start from scratch, covering the most commonly used functions and tools, with mentions of handy shortcuts along the way. We hope to end with Pivot tables, depending on the pace of the class.
While Excel may not be the most advanced, it is an industry staple meaning that in the short run you will have less difficulty in during your studies at SGH, and in the long run this knowledge and certificate will help you with job applications.
• Aliases (named cells/cellgroups)
• Introductory formulas: Sum, Average, Count, If…
• Addressing (linking to other working sheets/locked cells)
• Sort & Filter
• Data types
• Protect sheets/workbooks
• Freeze rows, columns
• Text to columns
• Various text functions
• Pivot tables
• Conditional formatting