City & Guilds Courses - Microsoft excel Course in Mauritius
Our Microsoft Excel Course is designed to enhance your data analysis and management skills to boost workplace productivity. Covering everything from basic spreadsheet functions to advanced data handling and visualization techniques, this course provides practical knowledge that enables you to effectively analyze data, create reports, and streamline workflows.
This course is offered at Levels 1, 2 and 3 with typing speed ranging from 24 wpm to 50 wpm.
The course contents below will correspond to the level which you are studying.
Microsoft EXCEL course in mauritius
Excel Basics and Data Entry
- Workbook and Worksheet Management: Learn to navigate workbooks, create, open, and save files.
- Data Entry: Enter and edit data efficiently, including autofill techniques and cell navigation.
- Cell Referencing: Understand absolute, relative, and mixed cell references for effective formula creation.
Formatting and Layout
- Cell Formatting: Adjust cell formats for font, color, and alignment to improve readability.
- Conditional Formatting: Apply rules-based formatting to highlight data insights.
- Worksheet Layout: Customize layout with row and column resizing, freezing panes, and page breaks.
Formulas and Functions
- Basic Formulas: Use SUM, AVERAGE, COUNT, MIN, MAX for quick calculations.
- Logical Functions: Implement IF, AND, OR for data analysis and decision-making.
- Date and Time Functions: Work with DATE, TIME, NOW functions to manage time-sensitive data.
Data Analysis Tools
- Sorting and Filtering: Organize data by sorting and applying advanced filters for precise data insights.
- Pivot Tables and Charts: Create dynamic pivot tables and charts to summarize and visualize data trends.
- Data Validation: Set rules to control data entry and ensure accuracy.
Charts and Visualization
- Chart Types: Generate and customize bar, line, pie, and column charts.
- Advanced Chart Options: Format charts for professional presentations, including trendlines and chart elements.
- Sparklines: Add mini-charts within cells to display quick data trends.
Advanced Formulas and Functions
- Text Functions: Manipulate text with CONCATENATE, LEFT, RIGHT, MID, UPPER, LOWER.
- Lookup Functions: Use VLOOKUP, HLOOKUP, INDEX, MATCH for cross-referencing data.
- Financial Functions: Calculate financial data using PMT, NPV, IRR for budgeting and investment analysis.
Data Security and Sharing
- Workbook Protection: Apply password protection and restrict access to sensitive data.
- Sharing Options: Collaborate in real-time and track changes within Excel.
- Excel Integration: Link Excel data with Microsoft Word and PowerPoint for seamless reporting.
Proofing and Printing
- Proofing Tools: Use built-in tools to check for spelling and grammar.
- Page Setup: Customize margins, orientation, and headers/footers for print optimization.
- Print Options: Adjust print area, scaling, and print preview for professional document output.
CITY & GUILDS COURSES IN MAURITIUS
CITY & GUILDS COURSES IN MAURITIUS
The City & Guilds courses lead to Awards, Certificates and Diploma for IT Users.
You can choose from a wide array of IT subjects and topics to build up your Diploma. City & Guilds helped numerous of our students start a Career in Web Development, IT Officers, Graphic Designer, Customer Support and much more.
CITY AND GUILDS COURSES ORGANISATION & TIMING
We have created a schedule for this course to match with most availabilities.
Our unique methodology includes in-class lectures, practical sessions, online coaching, past-papers and state of the art testing tools ensure that students get the best preparation for the examinations, which are set and marked by the City & Guilds UK three times per year. Locally, the exams are organized under the supervision of the MES.
Pre-requisite: None
Duration: From 3 months to 2 years, depending on exit route – Certificate, Award or Diploma.
- At least 2 sessions per week
- Course Materials
- Practical Sessions
- Career Development
CONTACT US FOR MORE INFORMATION
RELATED ARTICLES
Building a Career in Cybersecurity
Embarking on a cybersecurity career requires structured learning and certifications. At INFOCLUB Training Centre, we have a plan to make
Unleash Your Child’s Digital Potential This Summer with Fun, Hands-On IT Courses! As the summer holidays roll around, it’s time
The Belbin Model, also known as Belbin Team Roles, is a framework for understanding the roles individuals naturally adopt in
