How To Use Excel - EXCELLENT EXCEL

Learn How To Use Excel from Beginner to Advanced

2011-05-28T10:40:00.000-07:00

Many individuals need to learn how to use Microsoft Excel because of their career. Regardless if you are a ready-made newcomer or simply need to learn quite a few state-of-the-art skills, improving knowing about it involving Excel may be a fantastic way to improve importance at your workplace as well as make an impression on your manager. The following paragraphs will take you step-by-step through most of the essentials of the software program, in addition to the higher remedies as well as functions you may be keen on figuring out.

Excel is really a spreadsheet program, which can be made from many unique solar cells organised throughout rows as well as tips to form a power grid. Every individual mobile maintains an individual part of details, which are often the multitude, to start a date, a formula, or a part of copy. Formulations are widely-used to perform math along with other surgical procedures around the solar cells, defining it as all to easy to make great predictions, finances, together with other products for eliminating complex enterprise problems.

As you become much more comfortable while using the essentials, it is advisable to discover Microsoft Excel remedies along with state-of-the-art characteristics. Essentially the most valuable recipes We have discovered will be the PMT blueprint, allowing you that you ascertain the particular payment using a loan find out the eye fee, wide variety of obligations, plus initial loan product stabilize. This kind of formulation will let you discover home loans, car finance, in addition to any long run monetary design for example a investment lease contract.

An additional highly developed functionality that may be beneficial in Excel known as VLOOKUP. Web template that you knowledge your brand in order to find the related importance for almost any line in the details kitchen table. By way of example, should you have some sort of meal table involving consumer material, you could utilize VLOOKUP to discover the cellular phone number in the stand simply by entering the buyer ID multitude into your formulation.

Not a soul should learn Ms Excel not having not less than referring to this charting together with graphing operates. Excel supplies a wizard generates making your current charts effortless. Just simply buy a variety to express to this sorcerer how to find the results linked to ones data, say to them where product labels for every single info stage should be, and then simply find the type of data you want to produce. Within minutes you will have a superb along with professional graph which will dwell direct in a of your respective worksheets or why not be ripped and pasted into yet another document, for instance Term page.

Basically, there are numerous intricate capabilities found in Microsof Excel but you will not need to be intimidated by learning them. If you've found yourself a very good course and merely begin with the basics, you will realise immediately exactly how most of the functions interact. Be sure to find the series that is certainly suitable for ones skill, invariably providers produce both a or perhaps introductory lessons, in addition to a semi-pro level program.

MS Excel 2007 - How to Create a Simple Macro That Will Help You Save Time

2011-04-09T18:07:00.000-07:00

This article will explain how create a simple macro that will help you save time. If you use MS Excel 2007, you probably realize how easy it is to filter and manipulate data. Formatting that data can take a little time if you have a lot of changes to make. But if you are always formatting the same report, there's no need to waste all that time.

Recording a macro is easy, and it will let you get the exact same results every time you run it. It's a great feature that is in many versions of Excel. But these instructions apply only to Excel 2007.

Here's how you do it:
When you create your macro, you'll need to past the data you intend to format on a worksheet in the workbook. In the View tab on the ribbon, find the section called Macros. Click the lower portion of the button and select Record Macro. The Record Macro dialog box will appear. You'll need to give your macro a name. Any name will do, but you can't have any spaces or unusual characters. It's kind of like naming a file. Make it something you'll remember. Once you choose a name you can decide if you want to be able to activate the macro with a key stroke combination. Add the letter you want to use. Of course you have to stay away from letters that are already in use, like Ctrl + C or any of the numerous shortcuts already programmed into Excel. Choose the default option to store the macro in This Workbook. Until you get a little more comfortable with macros you'll want to use this option. Later you can learn how to keep your macros in a Personal Workbook that Excel will create for you. Click "OK" and from that point on every key stroke and mouse click you make will be recorded in the macro. Make all the changes you want to make to make your data more readable. You can format the header row, the columns, and even individual cells. You can even set up your print options including the Header and Footer. Any thing you do in Excel will be recorded and can be "played back" whenever you want. Once you've made all the changes, go back to the View section on the ribbon and click the bottom half of the Macro button. You'll see the option to stop recording. Click on that and you're done. To test your macro copy your unformatted data from the original report and paste it into the workbook on a new worksheet. Then, click the Macro button again. Select View Macros and you'll see your macro listed in the Macro dialog box. Highlight the macro name and click Run. Then you'll see your macro at work! If it's a short macro it may run so fast that you can barely keep up with the action. Presto! You just saved yourself the time it takes doing the same formatting tasks every time you need that report. If you don't like how the macro turned out, you can delete it and start over. Just highlight the macro in the Macro dialog box and click Delete.

The final step to make the workbook ready to go every time you need it. First, delete the worksheets you have already formatted, then save the workbook. That's it! Now, every time you run your report, just paste the data into the workbook and run your macro. It's amazing!

Undo and Redo in Microsoft Excel 2007

2011-03-04T06:46:00.001-08:00

Microsoft Excel allows the users to Undo their mistakes, or to repeat some of the action by Redo button. This is the significant improvement that differentiate it way ahead of typewriter, under most of the condition, the users are allowed to correct their mistakes.

Mistakes like wrongly deleted sentences, copy and pasting errors, plotted charts with wrong data and so on are recorded by Microsoft Excel. You may Undo your action once mistakes detected, and it is absolutely okay for you to make any mistakes. Just exactly how it works behind the screen? When you are working on your worksheet, Microsoft Excel will record down steps that you take in your work. The steps are recorded in sequence, and you may initiate Undo when you need it.

For example, say now on cell A1, you enter text "This is a", and on the cell A2, you enter text "Mistake". Say you don't want to word "Mistake" and you wish to remove it. Of course one simple way is to delete the text "Mistake" from the worksheet, however, you may perform the same effect by choosing the Undo button.

You may find the Undo button easily on the Quick Access toolbar, just click on the Undo button you may remove the text "Mistake". Say now you enter the text "Success" on the cell A2 after pressing the Undo button, you will actually remove the text "Success". You can easily restore the word by pressing the Redo button, which sit next to the Undo button.

Microsoft Excel is able to track on up to 100 actions that you made on the worksheet. You may see the list when you click on the downward button beside the Undo button, a summary of number of actions will also be shown at the bottom of the list. For each action recorded, there will be a short description of action for you to understand better on exactly what you will be undoing, you don't want to undo those actions that you may want to keep.

Microsoft Office Excel 2007 Inside Out

2010-12-21T09:10:00.000-08:00

Learn everything you need to know for working with Microsoft Office Excel 2007--from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Excel 2007--all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, you'll be able to dig in to the work-ready resources that help you take your Office Excel 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Office Excel 2007. You will learn how to navigate the product's new features and capabilities, including the new formatting and editing advances such as Live Preview. You'll explore new graphics capabilities, master the charting interface, and learn how to create dynamic lists with PivotTable® reports. You'll even learn how to automate Office Excel with macros, custom functions, and more. Plus, you'll get tools, eBooks, and more on the companion CD. With INSIDE OUT, you get all muscle and no fluff!

Click here to buy from Amazon

Microsoft Excel 2007 Training - Intermediate

2010-12-17T00:01:00.000-08:00

Excellent Excel Microsoft Office Excel 2007 Training
Microsoft Office Excel 2007 Intermediate

Code# : EEB201
Duration : 1 Day (8 hr)
Level : 201
Audience : Intermediate Student
Method : Classroom
Registration Fees : Early Bird-RM350, Late Bird-RM400

Trainee has the skills and knowledge required to create, edit, print and chart simple worksheets. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Module #1
Number Formatting Techniques
→ Formatting Time
→ Formatting Dates
→ Using Alternate Currencies
→ Creating Custom Formats

Module #2
Conditional Formatting
→ Formatting & Clearing Cells Containing Values
→ Using Top 10 Items & Data Bar for Visual Trend

Module #3
Sorting & Filtering
→ Performing An Alphabetical Sort, More Than One Column & by Rows
→ Applying, Using and Clearing A Filter & Creating Custom Filters
→ Using Wildcards in Filter

Module #4
Charting Techniques
→ Create, Modify, and Edit Charts
→ Adding Trendline & Error Bars in Charts

Module #5
Advanced Formula & Function Techniques
→ Absolute & Relative Cell Referencing
→ Using Logical, Character, Lookup & References Formula
→ Error Checking, Editing & Hiding Formula

Module #6
Basic Pivot Table
→ Create Pivot Table & Pivot Chart
→ Modifying field in Pivot Table

Module #7
More Data Manipulation
→ Text to Column
→ Data Validation
→ Remove Duplicates

Module #8
Bonus: Excel Shortcuts
→ 20 Keyboards shortcuts to improve MS Excel 2007 efficiency
**Includes MS Office Excel 2007 Manual, Practical Lab & Stationeries

{Module is last updated on 3rd Dec 2010}

Microsoft Excel 2007 Training - Beginner

2010-12-17T00:00:00.000-08:00

Excellent Excel Microsoft Office Excel 2007 Training
Microsoft Office Excel 2007 Beginner

Code# : EEB100
Duration : 1 Day (8 hr)
Level : 101
Audience : Novice
Method : Classroom
Registration Fees : Early Bird-RM300, Late Bird-RM350

Trainee has the skills and knowledge required to create, edit, print and chart simple worksheets. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Module #1
Introduction to MS Office Excel 2007
→ Getting familiar with new user interface
→ Creating, modifying and moving workbooks
→ Insert, rename, move, hide, copy, and delete sheets
→ Adding buttons to the Quick Access Toolbar (QAT)

Module #2
Data Manipulation
→ Entering, revising, finding and replacing data
→ Modifying worksheets
→ Check spelling, search for synonyms, and translate a word

Module #3
Formatting
→ Formatting Cells
→ Defining Styles
→ Applyinh workbook themes and table styles

Module #4
Basic Charts & Graphs
→ Create, Modify, and move a chart
→ Create a data table, add data, summarize the data, and rename the table

Module #5
Basic Calculations
→ Creating formulas to calculate values
→ Using AutoSum and simple statistical formula
→ Naming groups of data for better productivity

Module #6
Page Layout
→ Editing Page Setup
→ Adding Headers and Footers to Printed Pages

Module #7
Printing
→ Create a custom Headers and Footers containing a graphic
→ Preview a worksheet; change its margins, orientation, size, page breaks, and page printing order

Module #8
Bonus: Excel Shortcuts
→ 20 Keyboards shortcuts to improve MS Excel 2007 efficiency
**Includes MS Office Excel 2007 Manual & Stationeries

{Module is last updated on 3rd Dec 2010}

Microsoft Office Small Business 2007 FULL VERSION [Old Version]

2010-12-16T09:10:00.000-08:00

Microsoft Office Small Business 2007 is a powerful and easy-to-use suite of productivity and contact management software with new tools to help you save time, stay organized, and deliver better customer service. Comprised of the 2007 versions of Excel, Word, PowerPoint, Publisher, and Outlook with Business Contact Manager, this software package empowers you to create professional looking documents and presentations, build powerful spreadsheets, and manage your e-mail messages, calendar, and contacts.

The new look and feel of the 2007 Microsoft Office system automatically displays the menus and toolbars you need when you need them. View larger.

Tasks are easy to follow up on because they are included on the new To-Do Bar and within Outlook reminders. You can also drag tasks onto your calendar. View lager.

You can customize the new information dashboard in Office Outlook 2007 with Business Contact Manager to display your sales pipeline. View larger.

Business Contact Manager also combines contact, customer, and project information in one place. View larger.

Create, preview, and send personalized e-mail publications with Office Publisher 2007 using new E-Mail Merge. View larger.

In addition, Outlook with Business Contact Manager integrates powerful contact management features into Outlook that allow you to access and track all customer information and communications in a central location. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, the Small Business 2007 package makes it easier and more enjoyable for you to get things done at home or at work.
Which edition of Office is right for you? View a comparison of Microsoft Office 2007 editions.

Work More Efficiently and Effectively
The more intuitive look and feel, coupled with the improved tools, make Small Business 2007 the ideal software system to help you work faster to complete routine tasks and create more professional documents, spreadsheets, and presentations. Task-based menus and toolbars automatically display the commands and options you can use, making it faster and easier to find the software features you need. Thanks to the Instant Search function to save you time, junk mail and anti-phishing filters to protect the security of your computer, and new graphics capabilities to help you produce publication-ready documents, (complete with logo, colors, fonts, and business information), this software can increase both your productivity and efficiency, while giving you more time to spend with your customers. And to help minimize time-wasting future edits, the Live Preview feature makes it easy to sample your changes before you apply them.

Office Excel 2007 makes it easy to analyze data. View larger.

Improved Time Management
When work is busy, it's sometimes difficult to stay on-top of appointments and tasks. This is why Small Business 2007 lets you schedule tasks in Outlook that will appear on your calendar, while the To-Do bar presents a consolidated view of tasks, calendar information, and e-mail messages flagged for follow-up. To help effectively manage your time, take advantage of the templates and tools in Word, all of which make it easier to reuse content, so you don't have to start from scratch whenever you create a new document. And keeping track of important information is a snap thanks to new Excel tools for filtering, sorting, and visualizing information to help you find and analyze business data more effectively.

Manage Contact and Customer Information in One Place
To help you manage contact and customer information, Outlook with Business Contact Manager includes a complete contact management solution for small businesses that helps you deliver better customer service. This software enables you to organize all of your contact, prospect, and customer information, so it's easier to manage prospects, respond to customers, and manage your sales process in one place. Enhanced reporting features include over 50 reports that you can easily modify for your unique business needs, and new filtering capabilities help you forecast and close sales. You can also record all types of communications with a customer in one place-- including all e-mail, phone calls, appointments, notes, and documents-- and view a consolidated view of your sales pipeline by using a variety of flexible reports that you can easily modify for your unique business needs. You also can track and manage project tasks and even transfer tasks to coworkers. For added flexibility, you can work offline on your laptop or Pocket PC, and then synchronize data when you return to the office.

Including charts in Office PowerPoint 2007 is easy. View larger.

Produce Professional-Looking Marketing Materials and Campaigns In-House
Small Business 2007 makes it a snap to manage the entire marketing process so you save the time and expense of hiring an outside service. Create and distribute professional-looking marketing materials and campaigns for print, e-mail, and the Web by using Publisher. Then use Outlook with Business Contact Manager and Publisher together to track and manage marketing campaign activities, including compiling mailing lists, distributing materials, and tracking your results. You also can access the library of customizable templates in PowerPoint to create professional-looking presentations that enhance your business identity. If you need to merge information from multiple sources, combine and filter mailing lists and data from Excel, Outlook, Outlook with Business Contact Manager, and Access to create personalized print and e-mail materials and build customized collateral such as catalogs and datasheets.

Dynamic Presentations
One of the most effective ways to inspire both employees and customers is to impress them with a dynamic presentation. With its extensive library of customizable themes and slide layouts, PowerPoint helps you to create powerful charts, SmartArt graphics, and tables, while giving you the time-saving option of quickly previewing formatting changes so your final result is ready to go. You can also use the PDF file format for easier document distribution and high-quality printing. No matter what you need to help your business thrive, Small Business 2007 can make it possible.

Price: $449.95

Click here to buy from Amazon

Learn Excel 2007 Essential Skills with the Smart Method: Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level

2010-12-16T05:12:00.000-08:00

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique:

The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn’t confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
This is the only book that is also available as a low-cost video (DVD). Each can be used as a stand-alone product, but together they provide an incredibly powerful learning experience.
Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
Each lesson has a sample file that models a real-world business problem. You’ll immediately appreciate the value and relevance of each skill as it is taught.

Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.

Price: $21.99

Click here to buy from Amazon

101 Secrets of a Microsoft Excel Addict

2010-12-16T04:47:00.000-08:00

You are about to discover 101 of Excels little-known secrets that have been hiding right under your nose. These secrets are guaranteed to boost your Excel skills and productivity far ahead of everyone around you. Imagine! You the Excel Expert!

Check it out Ms Excel!

Brochure

2010-11-29T00:00:00.000-08:00

"Make education a continuing, never ending process" - Nido Qubein

Download brochure: Ms Office Excel 2007 Training Programme

Required: Adobe Reader

Schedule

2010-11-28T00:00:00.001-08:00

Coming Soon!

E-Flyer

2010-11-28T00:00:00.000-08:00

Budget Planner / Financial Planning / Financial Management in Excel

2010-11-27T00:00:00.000-08:00

"A bank book makes good reading - better than some novels" - Harry Lauder

Download Personal Financial Management

Required: Microsoft Office Excel 2007 / 2010

Online Registration Form

2010-08-31T01:00:00.000-07:00

Register at your convenient time, wherever you are!

Please download the form for Online Registration
Link 1: Ms Excel 2007 (recommended)
Link 2: Ms Excel 2007
Link 3: Ms Excel 2007
Link 4: Ms Excel 2007
Link 5: Ms Excel 2007

Note: Open with Ms Office Excel 2007 / 2010 (recommeded)

Contact Us

2010-08-30T12:00:00.000-07:00

We provide training in Microsoft Office Excel 2007. Our training courses can be run either as public open courses from our schedule or alternatively we can run tailored courses to suit you.

Mr. Lip Kar Lock
Consultant Director
BSc. (Hons) Electrical Engineering (UM)
+6016-5669878

Mr. Lip Kar Heng
Finance & Management Director
+6016-2320504

Email: excellentexcel07@yahoo.com / excellentexcel@hotmail.com
Website: http://www.excellentexcel.com.my/

Feel free to contact us.