excel in courses - excel intermediate
Microsoft Office Training McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams add this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Excel intermediate

excel in courses - Excel intermediate

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel training courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

resolvedResolved · Low Priority · Version Standard

Excel intermediate

Emily has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course

by - delegate Emily [10 posts] (2008 Jan 23 Wed, 16:33) replyReply

Outlines, why use them? When you could maybe hide or freeze?

Excel Advanced 1 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2009 Jan 9 Fri Bloomsbury 1 book now £240 £245
2007 2009 Jan 14 Wed Bloomsbury 5 book now £235 £245
2002/XP 2009 Jan 14 Wed Tooting 0 FULL    
2003 2009 Jan 16 Fri Southwark 0 FULL    
2007 2009 Jan 21 Wed Bloomsbury 3 book now £240 £245
2003 2009 Jan 21 Wed Southwark 2 book now £235 £240
Full Schedule: See all 114 Excel Advanced course dates.
Bookings currently available until 31st March 2010.

RE: Excel intermediate

by - trainer Amanda diamond contributer[1297 posts] (2008 Jan 28 Mon, 09:25) replyReply

Hi Emily

Thank you for your question.

To explain the difference between some of these features:

Freeze panes is used when you want sections of your screen to remain in place when you scroll through your spreadsheet (for example, you want to be able to see headings for your rows or columns when you scroll).

Hiding is used to temporarily 'hide' columns or rows of data from your spreadsheet. This may be for viewing or printing purposes, e.g. if there are only certain columns of the spreadsheet that someone wants a print out of.

To bring hidden columns or rows back, you can 'unhide' them.

Outlining also allows you to hide and unhide columns or rows of data, but instead of selecting the columns or rows and selecting the Hide or Unhide option, it gives you a little symbols and numbers that are visible at the top and left side of the screen that you can use to control the visibility of data. So using an outline is sort of like a shortcut to hiding and unhiding data.

I hope this makes sense.
Amanda

RE: Excel intermediate

by - delegate Emily [10 posts] (2008 Jan 28 Mon, 14:31) replyReply

Hi Amanda,

Thanks for your reply. I tried to print out the notes from the CD this weekend but there does'nt seem to be anything on the cd? Did anyone else have that problem?

RE: Excel intermediate

by - trainer Amanda diamond contributer[1297 posts] (2008 Jan 29 Tue, 14:41) replyReply

Hi Emily

I haven't heard from anyone else who has had the same problem, but I can either send you a zipped folder which contains the CD content, or I can arrange to have another CD mailed to you. Which would you prefer?

Amanda

RE: Excel intermediate

by - delegate Emily [10 posts] (2008 Jan 29 Tue, 15:16) replyReply

Thanks for your reply. I would love to have the CD mailed to me, if thats ok?

My address is 13c Healey Street, London NW1 8SR.

Thanks for all your help.

Emily

RE: Excel intermediate

by - trainer Amanda diamond contributer[1297 posts] (2008 Jan 29 Tue, 16:51) replyReply

Hi Emily

No problem I will arrange to have this done.

Amanda


Related articles

· Why Should I Learn Visual Basic in Excel?
· Prepare for your MOS Certification with MS Excel Courses
· What's Better Than the Help Function in Excel? Microsoft Training
· Microsoft Excel Training: Essential for Today's Employees
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Rate this page:
3.0/5 (5 votes cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Training venues
Client list
FAQ
Pricing and availability
Course details / Syllabus

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London
Microsoft Office training

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
Microsoft access courses · Microsoft training access course
Microsoft+access+training · Access courses in london

Training Information
Training Articles

AddThis Social Bookmark Button What's this?
Add to: Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo