excel.advanced.course

excel.advanced.course - Formulas

Resolved · Low Priority · Version Standard

Formulas

Beatriz has attended:
No courses

by - delegate Beatriz [1 post] (2008 Jan 9 Wed, 11:27) Reply

Can you choose a range including text AND numbers in the same cell when entering a criteria ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formulas

by - trainer Amanda diamond contributer [1243 posts] (2008 Jan 11 Fri, 17:15) Reply

Hi Beatriz

Thank you for your question.

Could you please provide some more detail about what you are wanting to use the criteria for? This will help me to better answer your question.

Thanks in advance
Amanda

· Advanced Excel and PivotTable Reports
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Prepare for your MOS Certification with MS Excel Courses
· How to check for and reduce errors in Microsoft Excel

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

Rate this page: