1. Home
  2. Course
  3. Advanced Excel 2007 Certificate

Advanced Excel 2007 Certificate

  

About this Course

Understand how you can apply Advanced functions of Microsoft Excel 2007 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.

Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

Course Outline:

Day 1 of Advanced Excel 2007

  • Lesson 1: Custom & Conditional Formats
  • Lesson 2: Using Formulas & Functions
  • Lesson 3: Working with Range Names
  • Lesson 4: Using Advanced Functions
  • Lesson 5: Managing Tables
  • Lesson 6: Using Auto Filter

Day 2 of Advanced Excel 2007 

  • Lesson 7: Getting Most from your Data
  • Lesson 8: Working with Charts
  • Lesson 9: Working with Pivot Tables
  • Lesson 10: Using Shared Workbooks
  • Lesson 11: Worksheet Protection
  • Lesson 12: Multiple Workbooks
  • Lesson 13: Working with Macros
  • Lesson 14: Scenarios in Excel 2007 (Optional)
              - How to Create a Report from a Scenario (Optional)

              - Auditing Tools (Optional)

Prerequisites

This course is not for Excel beginners. If you do not know how to copy information from one Excel worksheet cell to another, then this course is not for you... join our Excel for Beginners / Intermediate training program first. 

Join the Advanced Microsoft Excel workshop only if you have been using Microsoft Excel for atleast 3 months, know the basics, and are ready to learn the more advanced functions, tricks and techniques of Microsoft Excel 2007.

Seperate class for Advanced Excel 2010 is available. Check dates/schedules of Advanced Microsoft Excel 2010 class at Intellisoft.

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: