| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is contained in excel intermediate?
I need to have covered the content of the intermediate level in Excell by
Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Only the person who wrote the document using that phrase!
Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Thank you Bernard,
However, I wonder if you could advise on any areas which would be considered the next step up from beginner? You're right I've a 3 hour job interview on Friday morning which includes testing on Excel - they require Intermediate/Advanced skills and I'm panicing - copy of excel for dummies should be with me on Tuesday!! Maria "Bernard Liengme" wrote: Only the person who wrote the document using that phrase! Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Things to look at while waiting for book
For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html EEE 754 Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Chip's stuff on array formulas: http://www.cpearson.com/excel/excelF.htm Know about F9 (recalc) and the Formula Auditing tool in XL 2003 (View | Toolbars | Formula Auditing - Evaluate Formula Know how many row and cols in XL2003 and that nesting limit is 7. Beware that XL2007 has about 1 million rows and over 1000 columns and nesting 64 deep. If you are weak with charts visit Jon's site http://peltiertech.com/Excel/ChartsHowTo/index.html Other people will add/subtract from my list but just get on and doing some thinking about Excel. Be honest - you will be unhappy if the job is beyond your abilities. all the best -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... Thank you Bernard, However, I wonder if you could advise on any areas which would be considered the next step up from beginner? You're right I've a 3 hour job interview on Friday morning which includes testing on Excel - they require Intermediate/Advanced skills and I'm panicing - copy of excel for dummies should be with me on Tuesday!! Maria "Bernard Liengme" wrote: Only the person who wrote the document using that phrase! Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Many thanks.
Hoping to get the job as I'm looking forward to the challenge! Will let you know what happens. Thanks again Maria "Bernard Liengme" wrote: Things to look at while waiting for book For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html EEE 754 Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Chip's stuff on array formulas: http://www.cpearson.com/excel/excelF.htm Know about F9 (recalc) and the Formula Auditing tool in XL 2003 (View | Toolbars | Formula Auditing - Evaluate Formula Know how many row and cols in XL2003 and that nesting limit is 7. Beware that XL2007 has about 1 million rows and over 1000 columns and nesting 64 deep. If you are weak with charts visit Jon's site http://peltiertech.com/Excel/ChartsHowTo/index.html Other people will add/subtract from my list but just get on and doing some thinking about Excel. Be honest - you will be unhappy if the job is beyond your abilities. all the best -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... Thank you Bernard, However, I wonder if you could advise on any areas which would be considered the next step up from beginner? You're right I've a 3 hour job interview on Friday morning which includes testing on Excel - they require Intermediate/Advanced skills and I'm panicing - copy of excel for dummies should be with me on Tuesday!! Maria "Bernard Liengme" wrote: Only the person who wrote the document using that phrase! Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Looks like you already have a challenge.
I teach an intermediate course on Excel we cover: Customizing Toolbars and Menus Displaying more buttons Hiding or displaying toolbars Personalized menus and toolbars Creating a new toolbar Working with Dates Interpreting two-digit years Date functions Date formatting Outlining Creating outline levels manually Creating outline levels automatically Naming Cells Using the Name box to create a range name Naming cells by using existing row and column labels Worksheet Functions Use SUM to add nonadjacent ranges Using the insert function command Nesting functions Simple vs. complex functions Using the PMT() function Using the IF() logical function Using the AND() Operator within an IF() statement Nested IF() statements Using the VLOOKUP() function Linking Linking cells on the same worksheet Linking values between worksheets Linking cells in different workbooks Changing the link source Changing from a link to a value Breaking links Working with Excel Lists Creating a list Sorting a list Using a data form Filtering a list Using advanced filtering Using Database Functions with Lists Using the DSUM() function Using the DCOUNT() function Using the SUM() function -- Thanks, Shane Devenshire "Maria" wrote: Many thanks. Hoping to get the job as I'm looking forward to the challenge! Will let you know what happens. Thanks again Maria "Bernard Liengme" wrote: Things to look at while waiting for book For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html EEE 754 Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Chip's stuff on array formulas: http://www.cpearson.com/excel/excelF.htm Know about F9 (recalc) and the Formula Auditing tool in XL 2003 (View | Toolbars | Formula Auditing - Evaluate Formula Know how many row and cols in XL2003 and that nesting limit is 7. Beware that XL2007 has about 1 million rows and over 1000 columns and nesting 64 deep. If you are weak with charts visit Jon's site http://peltiertech.com/Excel/ChartsHowTo/index.html Other people will add/subtract from my list but just get on and doing some thinking about Excel. Be honest - you will be unhappy if the job is beyond your abilities. all the best -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... Thank you Bernard, However, I wonder if you could advise on any areas which would be considered the next step up from beginner? You're right I've a 3 hour job interview on Friday morning which includes testing on Excel - they require Intermediate/Advanced skills and I'm panicing - copy of excel for dummies should be with me on Tuesday!! Maria "Bernard Liengme" wrote: Only the person who wrote the document using that phrase! Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is contained in excel intermediate?
Many Many thanks - this is just what I needed. Will be able to study long
and hard now. Greatly appreciated Maria "ShaneDevenshire" wrote: Looks like you already have a challenge. I teach an intermediate course on Excel we cover: Customizing Toolbars and Menus Displaying more buttons Hiding or displaying toolbars Personalized menus and toolbars Creating a new toolbar Working with Dates Interpreting two-digit years Date functions Date formatting Outlining Creating outline levels manually Creating outline levels automatically Naming Cells Using the Name box to create a range name Naming cells by using existing row and column labels Worksheet Functions Use SUM to add nonadjacent ranges Using the insert function command Nesting functions Simple vs. complex functions Using the PMT() function Using the IF() logical function Using the AND() Operator within an IF() statement Nested IF() statements Using the VLOOKUP() function Linking Linking cells on the same worksheet Linking values between worksheets Linking cells in different workbooks Changing the link source Changing from a link to a value Breaking links Working with Excel Lists Creating a list Sorting a list Using a data form Filtering a list Using advanced filtering Using Database Functions with Lists Using the DSUM() function Using the DCOUNT() function Using the SUM() function -- Thanks, Shane Devenshire "Maria" wrote: Many thanks. Hoping to get the job as I'm looking forward to the challenge! Will let you know what happens. Thanks again Maria "Bernard Liengme" wrote: Things to look at while waiting for book For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html EEE 754 Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Chip's stuff on array formulas: http://www.cpearson.com/excel/excelF.htm Know about F9 (recalc) and the Formula Auditing tool in XL 2003 (View | Toolbars | Formula Auditing - Evaluate Formula Know how many row and cols in XL2003 and that nesting limit is 7. Beware that XL2007 has about 1 million rows and over 1000 columns and nesting 64 deep. If you are weak with charts visit Jon's site http://peltiertech.com/Excel/ChartsHowTo/index.html Other people will add/subtract from my list but just get on and doing some thinking about Excel. Be honest - you will be unhappy if the job is beyond your abilities. all the best -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... Thank you Bernard, However, I wonder if you could advise on any areas which would be considered the next step up from beginner? You're right I've a 3 hour job interview on Friday morning which includes testing on Excel - they require Intermediate/Advanced skills and I'm panicing - copy of excel for dummies should be with me on Tuesday!! Maria "Bernard Liengme" wrote: Only the person who wrote the document using that phrase! Sorry, but I cannot really tell you more. Buy Excel for Dummies asap, read it from cover to cover, pray hard, and go to the interview Tell us the outcome - we are routing for you! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Maria" wrote in message ... I need to have covered the content of the intermediate level in Excell by Thurs 06th Nov 2008 but I don't know where to start. Does anyone know what I should be covering? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Intermediate value of a set of array. | Excel Worksheet Functions | |||
| Using intermediate results in Worksheet functions | Excel Worksheet Functions | |||
| Calculate intermediate total on page change and carry it over. | Excel Discussion (Misc queries) | |||
| How to get intermediate values from smooth graph in Excel ? | Charts and Charting in Excel | |||
| How do I get an intermediate value between data points on a graph? | Excel Discussion (Misc queries) | |||
Linear Mode
