MS Excel Training Outline

2014

MS EXCEL Two-Days Workshop PACKED WITH EASY TIPS AND TRICKS Find out what Excel can do for you. Get more and better done in half the time.

These two days will turn you into a Pro at using Excel. When you add MS Excel to skills in your resumĂŠ next time, mean it.

The essentials New features, icon sets, sort and filter, objects and charts, etc Power tips and shortcuts Secrets to doing things faster & better Powerful formulas and functions convert raw data to something more meaningful, presentable and outright impressive

Flawless spreadsheets Financial reports, graphs ready for presentation, professional looking charts and graphics, etc Troubleshoot Reduce the frustration in printing, editing, correcting errors, validating data and more

Mon - Thurs: 2:00 p.m. - 8:00 p.m. Fri - Sat: 5:00 p.m. - 8:00 p.m.

051 - 26 56 324 | House 4-A, Street 55, F-7/4, Islamabad info@minervites.org | www.facebook.com/minervites www.minervites.org

WHY YOU SHOULD TAKE THIS WORKSHOP? It's the key to doing more done faster. There are things we don't know we can do even though we've been using MS Excel and Word for so long.

There are also things that can be done in half the time if you know the right way. The workshop has helped me with both!

Money-back guarantee Since I never considered there could be so much to Excel and Word, I thought it would be a waste of time. But they assure you that if you are not satisfied for any reason, you get to attend the next workshop for free - except you wouldn't need to.

The resource material is great for later help.

It's an information packed workshop. For someone like me who can't retain large chunks of information for long, the handouts are a great help even after the workshop.

It will help you stand out The instructor was right. We all have MS Excel and Word to flaunt on our CVs. But after this workshop when I write it on my CV, I mean it. It has given me an edge over others at work.

You learn what you can use at work the very next day It's a practical workshop. It's good to know we weren't just wasting time on text and theories.

Everything I learned was about how to use Excel for every day work

Essentials Get started on the right foot  Jump ahead with templates for budgets, forms, reports, etc  Excel interface and ribbon  Increase productivity by customising the ribbon  Changes to the backstage view  Create, manage, save and rename workbooks and worksheets  Special keyboard shortcuts and mouse techniques for increased efficiency  Working with different file types  Uncover different settings

Get that professional look Formatting styles  Use predefined styles or create your own  Modify format of numerical data  Format large data blocks quickly with the Format Painter  Change overall appearance of a worksheet with Themes  Use conditional formatting, using icon sets, data labels and other tips and techniques  Select a range of cells and quickly convert it into a table that stands out  Secrets to the merge and Center button  Organise and protect worksheets

Formulas and functions: Where the power lies  Find out what you must know about working with formulas  Explore the Function Library  Make sense out of your data by using functions and creating formulas  Get quick help on how functions work  Use a data range in your formula to save time and effort  Quickly check common errors in formulas  Use 'Watch Window' - watch the values of selected cells change in real time as you make changes to your work sheet  Evaluate Formulas to check complex functions and identify mistakes  Use the Quick Analysis Tool for instant data analysis

Make your worksheets come alive: Flaunt your workbook      

Add pictures, shapes and objects, 2-D and 3-D charts, sparklines to make your data stand out Insert complex mathematical equations into your worksheets or select data and convert it into a chart Insert screenshots of any open application Use the 'Recommended Chart Features' to visualise data in a chart or create a combo chart Use advance chart types to capture your audience's attention - stock, doughnuts, surface, bubble and radar Use 'Watch Window' - watch the values of selected cells change in real time as you make changes to your work sheet  Evaluate Formulas to check complex functions and identify mistakes  Use the Quick Analysis Tool for instant data analysis

Manage Data Import, sort, filter and more  Stop retyping text from other files into Excel instead just import date from a variety of data sources like the SQL Server, Windows Azure Marketplace, etc  Sort data according to values, cell colour, colour of the font and more  Identify and eliminate bad data using Data Validation  Filter data in a click to have a look at the data you want to see  Add a slicer  Separate the contents of one cell into multiple columns (e.g. first and last name)  Use Flash fill - quickly fill out an entire column of data  Create custom lists

Review, Share and Print:  Cool stuff  Add comments  Track changes made by others to see which ones to keep and which ones to discard  Protect a workbook so only those you want to give access to can open it  Lock certain cells so people cannot edit them  Specify rows and columns to repeat on each page when printing

THE INSTRUCTOR Sana Khalid is an ACA from the Institute of Chartered Accountants in England and Wales.

She has been providing trainings in MS Word and Excel to students, graduates and professionals in Pakistan and Dubai, with an accumulative experience of almost 10 years in the teaching and training industry.

You can write to her at sana.k@minervites.org

Register now - Limited space available.

By Phone: 051 - 26 56 324

Cancellations:

Timings: Mon - Thu: 2:00 p.m. - 8:00 p.m.

Fri - Sat: 5:00 p.m. - 8:00 p.m.

Online:

Cancellations received up to 7 working days before the workshop are refundable with a deduction of Rs 500/registration charges. After that cancellations are subject to the entire workshop fee, which you may credit towards a future workshop, if one is scheduled.

Fill out and submit the registration form at http://fs10.formsite.com/minervites/MSOffice/i ndex.html

Note: If you do not cancel and do not attend, you are still responsible for payment.

Or scan the QR code for quick access to the Payment methods: application form: Payment can be made in cash, cheque or bank transfer and should only be made once availability of seats has been confirmed by us.

Bank account details: Minerva Once we receive your application, you will 23067000111703 receive an e-mail from us confirming available Habib Bank Limited slots and the detailed Course Outline if you Serena Business Complex Branch haven’t already received one.

Customised Training:

Investment:

For customised group / corporate trainings, please write to sana.k@minervites.org with details of expected number of participants, location, and any specific requirements (e.g. MS Office version, customised course outline for financial reports, HR reports, basic internship training, etc).

Scheduled workshops open to all: Rs 10,000 per participant per module Rs 15,000 per participant for two modules 20% discount for students and groups of 3 or more individuals