phone call us Inspizone+65 8586 4485
Email us Inspizoneenquiry@inspizone.com
Send Enquiry
Chat with us InspizoneChat With Us
Advanced Microsoft Excel 2010 Course

Learn Advanced Microsoft Excel 2010 Course

SkillsFuture Eligible
SDF

Skills Development Fund

FORECASTING DATA

Learn VLookup, Hlook up, Consolidation, Protecting Worksheet, Workbook, Basic Macros






Course Start Date


  • 07/04/2024 | 9:30 to 4:30
    Weekend
  • 17/04/2024 | 7:00 to 10:00
    Week Days
  • 04/05/2024 | 9:30 to 4:30
    Weekend
  • Schedule


    Day: 1 Day
    Duration: 7 Hours
    Timings: 9:30 AM - 5:30 PM

    10 Anson Road, 26-08A International Plaza, Singapore 079903

    Register Now

    Why Choose Us


    • SkillsFuture Credit Eligible
    • Expert Local Trainers
    • Hands-on Training by experts
    • Certificate of Achievement
    • Free Refresh Class within 6 Month

    Quick Register


    
Quick Register

    Who Should Attend This Advanced Microsoft Excel 2010


    This Myob Course is ideal for those who are in charged of using MYOB/ ABSS to manage company’s account.

    Course Completion Requirements:

    Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

    Advanced Microsoft Excel 2010 Course Singapore


    Advanced Excel 2010 Course Objective: –

    • Our Advanced Excel 2010 Training Course is an interactive hands-on program.
    • We train participants step by step, from basic to advanced level functions of Excel.
    • It includes all essential skills like cell formatting, creating pivot tables, Macros, Templates, and using what-if equations plus explore how to visually represent data with charts and graphs, and even best practices for sharing your data on the web.

    Who Should Learn Excel 2010 Advanced Training Course?

    This course is meant for participants who would like to be told the fundamental operations of the Microsoft Word to perform their regular responsibilities, and who wish to use the application to be more productive in their work.

    • IT professionals
    • Business analysts
    • Project managers
    • Business owners and entrepreneurs
    Advanced Excel 2010 Course
    Advanced Excel 2010 Course

    Advanced Excel 2010 Training participant will get:

    • 100% confidence over Excel
    • know tips and tricks of Excel
    • how to minimize extra work using automated regular daily tasks using advanced functions
    • Deep knowledge to manage report, filter data and generate reports from Excel database
    • right use advanced functions of Excel 2010 to increase productivity
    • knowledge Augment data in spreadsheets using Pivot Table, Macros, templates, charts, graphics, and formulas and be work efficient.

    Microsoft Excel 2010 – Expert Level is for participants who want to add more sophistication and automation to excel gain a solid understanding of advanced features of spreadsheets and attain expertise in complex operations.

    Inspizone’s Advanced Excel Course is intended for current Microsoft Excel users who wish to deal with workbook and productivity features. It includes areas such as creating Complex Charts, Pivot Table, worksheet consolidation and linking with external data file, data analysis tools, and automating workbook operations using macros.

    Enhance your skills on Microsoft Excel 2010 Course with hands-on training delivered by certified Microsoft trainers.

    Grants available


    SkillsFuture Eligible

    SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

    SDF

    Skills Development Fund

    SDF: Deductible of 2$/hours for S/PRs trainees under company sponsorship.

    How to claim Fund

    How to claim Fund from SkillsFuture Singapore .

    Advanced Excel 2010 Course Outline


    How To Do Custom & Conditional Formats In Excel 2010

    • Working with Custom Format
    • Creating and editing Conditional Formatting in Excel 2010
    • Working with Templates
    • Deleting Conditional Formatting from the Selected Range

    How To Use Advanced Formulas & Functions In Excel 2010

    • Working with Cell Reference and Absolute Cell Reference
    • Working by using Functions like Text, Left, Upper, Date, Today, Sum Function
    • How to Concatenate the text values
    • Calculating using Functions
    • Working with IF function
    • Using Logical Functions
    • Using the Vlookup and Hlookup Functions

    Working With Range Names In MS Excel 2010

    • How to create, delete & use Range Names
    • How to use Range Names in Heading & Formulas
    • Working 3-D Range Names
    • Modifying Range Names
    • Calculate data across worksheets

    How To Do Data Sorting And Filtering In Excel 2010

    • Using Filter, Advance Filter
    • Using Database function
    • How to Sort Data
    • How to AutoFilter
    • Creating a Custom AutoFilter
    • Using Advanced Filter
    • Using Database Functions

    Fetch Result From Your Data

    • Creating Subtotal
    • Using Automatic Outline
    • Grouping Data Manually
    • Using Data Validation

    Hands-On With Pivot Tables In Excel 2010

    • Creating a PivotTable & Filter Pages Report
    • Adding PivotTable Report Fields
    • Updating a PivotTable Report
    • Selecting a Report Filter Field Item
    • Changing the Summary Function
    • Publishing PivotTable Reports to the Web
    • Moving PivotTable Report Fields
    • Using Expand and Collapse Buttons
    • Hiding/Unhiding PivotTable Report Items
    • Practice – Creating/Revising PivotTables
    • Introducing Slicers
    • Using Slicers to Filter Data
    • Deleting PivotTable Report Fields
    • Formatting a PivotTable Report

    Sharing Workbook Using Excel 2010

    • Opening and Editing a Shared Workbook
    • Tracking Changes
    • Resolving Conflicts in a Shared Workbook
    • Managing Conflicting Changes
    • Resolving Conflicting Changes
    • Setting Change History Options
    • Adding a History Worksheet
    • Reviewing Tracked Changes

    Hands-On With Worksheet Protection

    • How to protect your Worksheets
    • Using Consolidated Worksheets
    • Consolidating by Category
    • Consolidating by Position
    • Practice – Consolidating Worksheets
    • Protecting range with password
    • How to protect your Workbook
    • How to protect your Excel Files

    Hands-On With Macros In Excel 2010

    • Recording a Macro
    • Display the Developers Tab
    • Changing Macro Security Setting
    • Using a Macro Button
    • Creating a Macro Button
    • Copying a Macro Button
    • Formatting a Macro Button
    • Moving/Sizing a Macro Button
    • Deleting a Macro Button
    • Running a Macro
    • Deleting a Macro

    Getting Master With Charts In Excel

    • Creation & Formatting a Chart
    • Adding Labels
    • Playing the Chart Type & Data Source
    • Updating Data Source
    • Changing the Chart Location

    google logo Reviews of our students


    Jacqueline Lee
    Jacqueline Lee
    2021-09-22

    Went for a accounting course, Steven was friendly and helpful
    Wenyan Yeo
    Guido Sudero
    2021-09-01

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Ken Cheong
    THIRUMALA DEVI
    2021-09-15

    Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.
    Josephine Low
    Lachu Gandhi
    2021-09-07

    Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.
    Wenyan Yeo
    Wenyan Yeo
    2021-09-01

    Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.
    shengwei tan
    shengwei tan
    2021-07-01

    Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.
    Joanna
    Joanna
    2021-06-14

    Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.
    Chiqui Ehong
    Grace CH Ong
    2021-06-11

    A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂
    Arun Dixit
    Arun Dixit
    2021-05-01

    I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.
    Guido Sudero
    Avira Dixit
    2021-04-29

    I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!

    Frequently Asked Questions (FAQs)


    What is MYOB/ABSS?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    What is my salary potential as an Accountant specialist after completion of this MYOB certification course?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Why do organizations hire Accountant professionals?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Is this MYOB training course up to date?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Which course will be available for live instructor-led online classes?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    How do I enroll in this MYOB Certification course?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Frequently Learn Together