OVERVIEW
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Upon successful completion of this course, you will be able to create and develop Excel worksheets andworkbooks in order to work with and analyse the data that is critical to the success of your organization.
- Get started with Microsoft Excel.
- Perform calculations.
- Modify a worksheet.
- Format a worksheet.
- Print workbooks.
- Manage workbooks.
- Typically spans 1 day (9am to 5pm).
- Nonetheless, we can customize both the program’s duration and schedule to cater to unique client requirements (e.g., compact 1-2 days workshops or extended sessions beyond 3 days).
- Beginners and Novices
- Office Workers
- Administrative Staff
- Students and Educators
- Small Business Owners
PROGRAM OUTLINE
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Excel Online
- Topic E: Enter Cell Data
- Topic F: Use Excel Help
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Colors, Borders, and Styles
- Topic E: Apply Basic Conditional Formatting
- Topic F: Create and Use Templates
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
PROGRAM METHODOLOGY
- Hands-on Activities: Practical exercises to reinforce theoretical concepts.
- Group Discussions: Opportunities for peer-to-peer learning and exchange of ideas.
- Role Plays: Simulations of realistic situations to build practical skills.
- Feedback Sessions: Reviews and reflections to encourage improvement.
- Problem-solving Exercises: Develop critical thinking and decision-making skills.
- Experiential Learning: Learning by doing, promoting active involvement.
- Interactive Lectures: Engaging presentations by experts in the field.
- Case Studies: Real-world scenarios for learners to apply their knowledge.
- Quizzes & Tests: Regular assessments to track learning progress.
CONTACT US
Our Experts Are Here to Help