I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel
Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.
The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.
Able to apply VLookup, Macros and Pivot Tables easily - M1
Improved my job productivity by 75% - ITE
Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas
View the Latest Advanced Excel Training Schedule to reserve a seat.
Basic & Intermediate Excel 2007
Microsoft Excel 2007 – Basic - Intermediate (Course Outline)
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call 6296-2995 for Details.
Course Duration : 2 days
Excel is a simple tool, and it is very easy to pick up, once you know the simple tips and tricks to do simple to complex tasks easily with our step-by-step approach.
Course Objectives
Excel for Beginners & Intermediate Level is best suited for people who want to get more out of Microsoft Excel and make the best use of the software in their day-to-day use.
Learn Excel tips and techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes or seconds.
Who Should Attend?
This program is highly recommended for those who to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use a spreadsheet application on a personal computer.
Microsoft Excel 2007 for Beginner & Intermediate Levels Covers the Most Important Topics :
Day 1
Section 1: Getting Started
1.1. Starting Out
1.2. About Workbooks
1.3. Exploring Workbook
1.4. Getting Help in Excel 2007
Section 2: The New Interface
2.1. The Quick Access Toolbar
2.2. The Home Tab
2.3. The Insert Tab
2.4. The Page Layout Tab
2.5. The Formulas Tab
2.6. The Data tab
2.7. The Review Tab
Section 3: Excel Basics
3.1. Working with Excel 2007
3.2. Basic Excel Features
3.3. Moving your Data
3.4. Smart Tags and Option Buttons
3.5. Editing Tools
Section 4: Editing Your Workbook
4.1. Modifying Cells and Data
4.2. Cell Formatting
4.3. Enhancing a Worksheet’s Appearance
4.4. Working with Charts, Part 1
4.5. Working with Charts, Part 2
Section 5: Printing and Viewing your Workbook
5.1. Using the View Tab
5.2. Managing a Single Windows
5.3. Managing a Multiple Windows
5.4. Printing your Workbook
Day 2
Section 1: Advanced File Tasks
1.1. Using My Computer within Excel
1.2. Saving your Files
1.3. Using Templates
Section 2: Working with Functions and Formulas
2.1. Using Formulas in Excel
2.2. Exploring Excel Functions
2.3. Using Functions in Excel
2.4. Working with Names and Ranges
2.5. Working with Array Formulas
Section 3: Managing Tables
3.1. Working with Tables
3.2. Working with Records and Fields
3.3. Working with Tables and Filters
3.4. Using Excel as a Database
Section 4: Enhancing your Workbook
4.1. Customizing your Workbook
4.2. Working with Text Boxes
4.3. Word Art
4.4. Clip Art
4.5. Using Objects
Section 5: Finalizing your Workbook
5.1. Protecting your Workbook
5.2. Finishing your Workbook
5.3. Using Excel in Word
5.4. Using Excel and Access
5.5. Using Excel with other Programs and Files
Register for the 2 Day Microsoft Excel 2007 – Basic - Intermediate Class Today. Simply fill the form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at 9066-9991.
To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.
Call Kamini at 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class.