Jump to content


Start a free course now!

Most Liked Content


#25 Do you have similar courses for Word, PowerPoint and other applications?

Posted by TheSmartMethod on 02 September 2013 - 03:27 PM

The only Smart Method courses that have been published as books/videos so far are:

 

• Learn Access 2003 VBA With The Smart Method ISBN-13: 978-0955459900

• Learn Excel 2007 Essential Skills with the Smart Method ISBN-13: 978-0955459924

• Learn Excel 2007 Essential Skills with the Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2007 Expert Skills with The Smart MethodISBN-13: 978-0955459931

• Learn Excel 2007 Expert Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2010 Essential Skills with The Smart Method ISBN-13: 978-0955459979

• Learn Excel 2010 Essential Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2010 Expert Skills with The Smart Method ISBN-13: 978-0-9554599-8-6

• Learn Excel 2010 Expert Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2013 Essential Skills with The Smart Method ISBN:  978-1-909253-06-3

• Learn Excel 2013 Essential Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2013 Expert Skills with The Smart Method ISBN:  978-1-909253-07-0

• Learn Excel 2016 Essential Skills with The Smart Method ISBN: 978-1-909253-08-7

• Learn Excel 2016 Expert Skills with The Smart Method ISBN: 978-1-909253-09-4

Learn Excel 2016 for Mac Essential Skills with The Smart Method ISBN: 978-1-909253-11-7

Learn Excel 2016 for Mac Expert Skills with The Smart Method ISBN: 978-1-909253-12-4

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills with The Smart Method ISBN-13: 978-0955459962

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills with The Smart Method ISBN-13:978-0-9554599-9-3

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Essential Skills with The Smart Method ISBN-13: 978-1-909253-04-9

• Learn ASP.NET 4.5, C# and Visual Studio 2010 Essential Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Expert Skills with The Smart Method ISBN-13: 978-1-909253-05-6

• Learn ASP.NET 4.5, C# and Visual Studio 2010 Essential Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

 

We're currently working on an (almost completed) VBA book  The VBA book will teach the Visual Basic for Applications (VBA) programming language which is generic to Office 2013 and not specific to Excel or any other application. 

 

Eventually Mike Smart will also write up his Outlook, Access, Word, Project, Power Point… and other courses as books and videos but it will take many years to complete them all. The Smart Method are currently exploring ways of increasing productivity by employing proof-readers,  testers and video editors to free more of Mike's time for course design and recording.  




#927 Do you offer any training for Word

Posted by Prasanna on 17 April 2014 - 06:16 AM

Hi

Is there any training for Microsoft Word. This training is best in the world for Excel. If you have training for Microsoft Word such WordCentral.Com, i am very happy to get this one.

 

 

Regards

Prasnana




#26 Do you have an Excel VBA (Visual Basic for Applications) course available?

Posted by TheSmartMethod on 02 September 2013 - 03:31 PM

VBA is not an Excel skill but a programming language that can be used (amongst other things) to automate Excel and other applications. The Smart Method have run VBA classroom courses (in the context of both the Access and Excel object models) for over ten years.

 

After many years of classroom courses for some of the world’s largest companies it has become apparent that very, very few business users actually need Visual Basic programming skills. In most business scenarios Excel is more than capable of providing every corporate need by correct use of its in-built functionality.

 

We've often been asked to provide a VBA classroom training course but then changed the course to Expert Skills on the day. This has happened because when delegates describe the business problems that they think VBA will help them solve, the solution is easy to implement by correctly understanding Excel’s advanced functionality.

 

If you have a specific business problem that you think that you need VBA to solve why not post it on our support forum.  One of our Excel Experts will, in almost all cases, be able to provide a solution that does not involve bespoke programming.



#85 Forum Rules - Please read before posting

Posted by TheSmartMethod on 03 September 2013 - 01:03 PM

Forum Rules

 

What happens if you break the rules?

The moderator will remove or edit your post and e-mail you explaining why your post has been edited/removed. 

In extreme cases you may be banned (or suspended) from making further forum posts.

The interpretation and application of “the rules” is done by forum moderators.  Their decision is final.

 

The Rules

There are only four simple rules:

 

Rule #1 – Be Nice

If you are a nice person you don’t really even need to read this part!

  • All posts must remain polite and respectful. 
  • User names that have the potential to cause offence to any other user may not be used.
  • Images that have the potential to cause offence to any other user may not be used as avatars.
  • Spam is prohibited.  Spam means the promotion of products or other web sites rather than a genuine contribution towards solving the problem being discussed.  Signatures may not include links to third party websites.
  • You may not use this board to offer solutions in exchange for money.
  • Posts may not promote any illegal activity (such as by-passing copyright protection measures).

Rule #2 – Make the forums as useful as possible

  • Posts must be made in English. 
  • This forum is about using Excel rather than extending it with the VBA programming language.  Suggested solutions to problems must use standard Excel features (including recorded macros) and not be implemented using VBA program code.
  • Do not suggest that a user moves a discussion to private messages or another forum. 
  • Do not post duplicate questions.  
  • If you think another member has broken one of the forum rules use the "Report" button underneath the post to refer it to a moderator. Do not refer to the violation within the discussion thread itself. 
  • The moderators may correct your posts for typos or grammatical errors if this will make them easier for others to read. 

Rule #3 – Do not link to other sites

Your post may still be on our forum in several years’ time. The Internet is constantly changing and if you include links in your posts it is probable that the linked data will change (or disappear completely) in the future. 

 

We can only be sure that links to pages and posts on our own site will always work correctly.

For this reason you can only post hyperlinks to:

  • Any ExcelCentral.com video or e-book lesson
  • Any other thread or posting in the Excel Central forum.

Apart from these two types of links, information should always be provided within the post and not by a link to another resource.

 

Rule #4 – Stay focused

  • Keep scope as narrow as possible.  Don’t ask questions such as: How do I create an accounting system using Excel
  • Use concise and accurate thread titles.  Don’t create threads with abstract names such as Please Help, Need Advice etc.
  • Keep answers on topic.  Don’t post a new unrelated problem on a focused thread.  Start a new thread instead.
  • Do not post one-liners that add no value to the discussion such as OK, I agree etc.



#793 Length of Courses

Posted by Mike on 14 March 2014 - 12:28 AM

Hi

 

How long it takes you to compete either course is (of course) extremely variable. A lot depends upon whether you are completely new to Excel or whether there is a degree of past exposure.

 

Most users of Excel do not need Expert Skills.  To work in the average office job you will usually be hugely in advance of the average other users if you "only" have the skills described in the "Essential Skills" course. 

 

The books are based upon Smart Method classroom courses.  With well motivated and above average intelligence adult course attendees, with zero previous Excel experience, we have trained thousands of Excel users (without exception) to "Essential Skills" standard in one eight hour intensive day.  Unfortunately this is in a classroom environment (and hugely expensive compared to the cost of the book or video course).

 

Just to listen to each Essential Skills video lesson will take around eight hours.  In a (non classroom) environment, using only books or videos as the learning material, I would guess that three days (of intensive attention) would be the maximum needed by most adult learners to master every skill presented.

 

Expert Skills is a little more advanced. 

 

To truly achieve Expert status I ask my corporate clients to allocate two days of intensive classroom training (for users with existing good Excel skills).  In effect most go for one day and it is possible to "cherry pick" different skills to cover those most of relevance to the class in this time frame.  For self study it would be good to double this estimate to 2-4 days depending if you need to know "everything" or a subset of the skills presented.  But once again, you need to ask yourself if you really need Expert Skills (few users really do).

 

Best Regards

 

 

Mike Smart




#55 Do you have similar courses for Word, PowerPoint and other applications?

Posted by TheSmartMethod on 02 September 2013 - 04:34 PM

The only Smart Method courses that have been published as books/videos so far are:

 

• Learn Access 2003 VBA With The Smart Method ISBN-13: 978-0955459900

• Learn Excel 2007 Essential Skills with the Smart Method ISBN-13: 978-0955459924

• Learn Excel 2007 Essential Skills with the Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2007 Expert Skills with The Smart Method ISBN-13: 978-0955459931

• Learn Excel 2007 Expert Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2010 Essential Skills with The Smart Method ISBN-13: 978-0955459979

• Learn Excel 2010 Essential Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2010 Expert Skills with The Smart Method ISBN-13: 978-0-9554599-8-6

• Learn Excel 2010 Expert Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2013 Essential Skills with The Smart Method ISBN:  978-1-909253-06-3

• Learn Excel 2013 Essential Skills with The Smart Method: Video Course (only available online at the ExcelCentral.com web site).

• Learn Excel 2013 Expert Skills with The Smart Method ISBN:  978-1-909253-07-0

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills with The Smart Method ISBN-13: 978-0955459962

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills with The Smart Method ISBN-13:978-0-9554599-9-3

• Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Essential Skills with The Smart Method ISBN-13: 978-1-909253-04-9

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Expert Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Expert Skills with The Smart Method ISBN-13: 978-1-909253-05-6

• Learn ASP.NET 4.5, C# and Visual Studio 2012 Expert Skills with The Smart Method Video Course (only available online at the ASPNetCentral.com web site).

 

Eventually Mike Smart will write up his Access, Word, Project, PowerPoint… and other courses as books and videos but it will take many years to complete them all. The Smart Method are currently exploring ways of increasing productivity by employing proof-readers, testers and video editors to free more of Mike’s time for course design, writing and recording.




#1742 Preparing for the Microsoft MOS Expert Exam 77-427 and 77-428 using The Smart...

Posted by Mike on 04 July 2015 - 09:56 AM

Dear Ishaq

 

The new MOS exam format (for Office 2013) doesn't seek to test any individual Excel skills but, instead, poses a real-world business problem that the student must solve.  This is a very welcome change from earlier exams for which it was impossible to "guess" which skills Microsoft actually were going to test (due to very loosely defined objectives).

 

This is from the Microsoft site:

 

"The new exam format for MOS 2013 presents a short project that the candidate must complete, using the specifications provided. This creates a real-world testing experience for candidates". 
 
Microsoft advise that Excel Skills are tested in the way that they are taught in our courses -  in the context of solving a real business problem.  Our teaching method -  with every skill taught using an example workbook from the real world of business and commerce - should prove ideal for preparation for your exam.  You'll also learn many more extremely useful skills that go well beyond those included in the MOS "Expert" certification. 
 
If you complete our Expert course I know that you will be able to address any real-world business problem for which Excel is an appropriate tool.  If you look at some of the real-world business problems posed on this forum by professional Excel users,  you'll see that many are extremely complex but that all have been solved using only the skills taught in our course. (The solutions are always cross-referenced back to video and e-book lessons that teach the skills used in the solution) .
 
I'd suggest that you proceed as follows:
 
1/ Work through the 2013 Essential Skills and Expert Skills courses until you can complete all of the exercises at the end of each session without referring back to the book or video lesson.
 
2/ Study the problems posed on this forum until you thoroughly understand the solutions we have provided.
 
If you do take (and hopefully pass) the test it would be very interesting if you could post details of the project you were asked to complete and we'll provide a worked example of the solution by referring to the relevant lessons in the Essentials and Expert course.
 
I should also mention that  you will receive our own certification of course completion at the end of our course that you can print out and e-mail directly from your control panel (available when you log-in).    
 
Best Regards

 

Mike Smart




#920 "slidepage" doesn't work

Posted by Guest on 15 April 2014 - 07:54 PM

In the exercises (quizzes), I am told to slide page to the left. There is a right arrow shown. There is no way of causing the page to slide over. Excel 2007.




#787 Formula for date error

Posted by Jonathan on 12 March 2014 - 10:20 PM

Hi Paula,

 

Let me first clarify what I think you want to do.

 

monthname.png

 

The month of the date of birth is in cell C2 and is currently 8.

 

For each of the cells F11:Q11, you want to add 2 to the value if the month is the same as the value in C2 (in this case, August), and only 1 to the value if it is not.

 

You can do this by using the IF function, but you will find that the month names in cells F10:Q10 don't match the number in cell C2.  You could get around this by changing cell C2 to Aug instead of 8, or you could use the MONTH function to extract the numbers from each heading.

 

I'll use the MONTH function in my example.  For a full explanation of the MONTH function, see the PDF and video lesson: Expert Skills Lesson 3-8: Understand common date functions.

 

Here's how the IF formula in cell F11 should look:

=E11+IF(MONTH(1&F10)=$C$2,2,1)

 

If you're having trouble understanding the IF function, you can find more information in the PDF and video lesson: Expert Skills Lesson 3-5: Use the IF logic function.

 

You'll also notice that I have used the absolute reference $C$2 so that this formula can be easily filled across the rest of the months.  For a full explanation of absolute references, see the PDF and video lesson: Essential Skills Lesson 3-12: Understand absolute and relative cell references.

 

The MONTH function looks a little strange, as I've used 1&F10.  This is necessary in order for the MONTH function to recognize (for example) Jan as a date and return the number 1.

 

I have attached a copy of your spreadsheet with the formulas applied:

 

Attached File  Numerology.xlsx   10.68KB   244 downloads

numerology.png

 

Please feel free to reply if you need any more assistance with this.




#637 Slicer is missing

Posted by Jonathan on 13 January 2014 - 05:57 PM

Hi Mr Pointer,

 

The most likely explanation is that the workbook was created in an older version of Excel that does not support the Slicers feature (Excel 2003 or earlier).

 

Fortunately, you can very easily convert your workbook to the latest version of Excel by simply clicking File > Save As and making sure to select the Excel Workbook (*.xlsx) format.

 

For instructions on how to save a workbook in a different format, see Essential Skills Lesson 1-6 Save a workbook to a local file .

For a more detailed look at the different formats supported by Excel, see Essential Skills Lesson 1-7 Understand common file formats .

 

If this doesn't solve your problem, please reply to this post and I will investigate further.




#480 How to share worksheets in Excel

Posted by Jonathan on 01 November 2013 - 01:59 PM

Hi Silvia,
 
There are three different ways to share a workbook, the Locked Document method, The Merge method and by sharing workbooks on a network (the differences are discussed in: Expert Skills, Lesson 8-10: Understand the three different ways to share a document).
 
There's also an (almost hidden) feature called "compare and merge workbooks" that can help you with the merge process.  This is discussed in: Expert Skills, Lesson 7-12: Share a workbook using the merge method.
 
Having said that, from your description it sounds like all of your problems would be solved if you could implement security to correctly address the business need (all of Excel's security features are covered in: Expert Skills, Session Seven: What If Analysis and Security).  You'd find it very rewarding to revise this session as there's a high probability that you'll discover the best solution to the problem when you are fully conversant with Excel's extensive security features.
 
If you decide to continue down the route of having 3 separate spreadsheets and merging them together, you can also potentially highlight any discrepancies by using an IF formula.  You can then use conditional formatting to highlight the discrepancies.
 
The formula to check whether the answers are all equal will look something like:
=IF(AND([Answer1]=[Answer2],[Answer2]=[Answer3]),"YES","NO")
You can learn more about the IF and AND functions in the following lessons:
Expert Skills Lesson 3-5: Use the IF logic function
Expert Skills Lesson 3-16: Use the AND and OR functions to construct complex Boolean criteria
 
To learn about conditional formatting, see Essential Skills Lesson 4-15: Use simple Conditional Formatting.
 
I have attached an example spreadsheet showing how this might work:
Attached File  Questions.xlsx   10.42KB   279 downloads
questions.png
 
I hope this information is useful, and please reply if you need any more assistance.




#2599 Formula for adding a date to an invoice

Posted by Jonathan on 17 January 2017 - 09:20 PM

Hi JaseandShell,

 

Yes, you can use the TODAY function to place the current date in a cell, or use the NOW function for the current date and time.

 

You can see more about how to use these functions in the video lesson: Expert Skills Lesson 3-11 Use the Excel DATE function to offset days, months and years.

 

You can also use insert the current date or date and time without using a formula, using the keyboard shortcuts <Ctrl>+<;> and <Ctrl>+<:> (Control-Semicolon and Control-Colon). The date won't automatically refresh if you use the keyboard shortcut.




#2479 sparkline not recognizing data

Posted by Jonathan on 06 September 2016 - 04:28 PM

Hi Jenny,

 

The reason this is happening is that a sparkline can only draw a line between two data points if there are two data points in a row to draw a line between.

 

In the case of row 15, there is an empty space and then only a single item of data, meaning there is no end point for a line to be drawn to.

 

The solution is to enable Markers for your sparklines. This means that markers will appear for each value instead of lines alone, and will allow you to see the lone data point in row 15. The default markers can be a little hard to see, so you may want to customize them to be larger or to appear in a different color.

 

You can see a complete walkthrough of adding markers to sparklines in the video lesson: Essential Skills Lesson 4-20 Apply a common vertical axis and formatting to a Sparkline group.

 

I have also attached a copy of your workbook with the markers applied:

 

Attached File  sparkline problem.xlsx   205.99KB   36 downloads

sparkline problem.png

 

I hope this is the solution you were looking for, but please feel free to reply if you need any more help with this.




#2187 Validate negative values

Posted by Jonathan on 08 February 2016 - 07:38 PM

Hi LT27,

 

I am not completely sure that I understand what you're trying to do, but it sounds like you want to check whether the Awarded Savings value is negative and, if so, display 0 in that cell. In the same way, you want to display Cost Savings if the Awarded Savings is above zero, and Cost Avoidances if not.

 

Both of these can be achieved by using an IF function to check whether the value is below zero.

 

The first formula will look like this:

=IF(B12-B13<0,0,B12-B13)

 

The second will look like this:

=IF(B12-B13<0,"Cost Avoidances","Cost Savings")

 

If you're having trouble understanding these formulas, you can find a complete explanation of the IF function in the video lesson: Expert Skills Lesson 3-5 Use the IF logic function.

 

I also noticed that you might want the values to appear in red if there are negative savings. You can make this happen automatically by using a formula-driven conditional format.

You can learn more about these in the video tutorial: Essential Skills Lesson 4-18 Create a formula driven conditional format.

 

I have attached a copy of your workbook with the new formulas and conditional formatting applied:

 

Attached File  Test 1.xlsx   10.88KB   40 downloads

Test 1.png

 

I hope this is what you were looking for, but please feel free to reply if you're still not sure how to proceed.




#2149 Is there a way to concatenate multiple cell formulas (instead of resulting va...

Posted by Jonathan on 25 January 2016 - 09:28 PM

Hi bennyb,

 

The FORMULATEXT function will extract the formula from a cell and return it as text. For example =FORMULATEXT(A1) will show the formula that is in cell A1.

 

Your second requirement isn't quite as straightforward, but you should be able to achieve what you need by using the INDIRECT function. INDIRECT will convert text into cell references that will work in formulas, but it won't accept an entire formula.

 

You can learn all about INDIRECT in the video tutorial: Expert Skills Lesson 4-5 Use intersection range names and the INDIRECT function.

 

I've also attached an example workbook:

 

Attached File  INDIRECT.xlsx   9.59KB   57 downloads

INDIRECT2.png

 

I hope this is what you were looking for, but please feel free to reply if you need any more help with this.




#2062 Project 3 years out from date entered minus 1 day

Posted by phoenixrizing on 02 December 2015 - 06:06 PM

Usually, it's the formatting I have trouble with when working with dates. I don't think this is the case now though. It's more an issue with calculations.
 
I want a user to enter a starting date. I will then calculate three years out from that date. This 3-year period is a cycle, so the end date should be one day prior to the start date three years out.
 
Example: If I enter June 23, 2014 in cells E3, F3, G3, the end date should be June 22, 2017 in cell E4.
 
The problem I'm having occurs when I enter a year beyond 2015. When I do this, the projected date goes out three years into the future as it should, but the date remains unchanged. When selecting 2015 and previous years, it seems to work fine.
 
Additionally, I need to account for the start date occurring in one month and the end date being in the prior month while taking into account leap years.
 
Attached File  date forecast.xlsx   14.1KB   77 downloads



#1752 analyzing discontinuous number strings

Posted by Jonathan on 08 July 2015 - 04:06 PM

Hi David,

 

While you could produce a correct result using Excel, this sounds like a problem that could be more suited to programming as it may be a very laborious process to create all of the formulas that are needed.

 

If you do want to proceed using Excel, you should be able to extract the strings by using Excel's FIND function along with several other functions including LEN and MID.

 

I have attached an example workbook showing how this might be achieved:

 

Attached File  StringSplit.xlsx   11.1KB   150 downloads

StringSplit.png

 

As you can see, the first thing I have done is to concatenate all of the values together into a single string using the concatenation operator (&). This makes it possible to use the FIND function on the resulting string.

You can find a more in-depth look at how concatenation is done in the video lesson: Expert Skills Lesson 3-18 Concatenate strings using the concatenation operator.

 

Next, I extract the first string using the following rather complicated formula:

=MID([@Concatenated],FIND("0",[@Concatenated]),FIND("1",[@Concatenated],FIND("0",[@Concatenated]))-FIND("0",[@Concatenated]))

 

This formula finds the first zero in the string and the first 1 in the string and then uses the MID function to extract the characters between them.

 

In order to find the correct place to start to find the next string, the following formula is used:

=FIND([@String1],[@Concatenated])+LEN([@String1])

 

This simply searches for the string in the text and adds the length of the string to the result.

 

You can find more about the FIND and LEN functions in the video lesson: Expert Skills Lesson 3-21 Extract text from delimited strings using the FIND and LEN functions.

You can learn more about the MID function and other string handling functions in the video lesson: Expert Skills Lesson 3-20 Extract text from fixed width strings using the LEFT, RIGHT and MID functions.

 

Now the process can be repeated as many times as are needed to extract all of the strings. In my example I have also added an IFERROR function to return a blank result if there are no more strings to extract. You can find more about IFERROR in the video lesson: Expert Skills Lesson 3-23 Use an IFERROR function to suppress error messages.

 

Now that the strings are extracted, it's a simple matter to find their lengths using the LEN function and discover the longest, shortest and average using the MAX, MIN and AVERAGE functions. These are covered in the video lessons in Essential Skills Session 2: Doing Useful Work with Excel.

 

I hope this is what you were looking for, but please feel free to reply if I can offer any further assistance.




#1599 Function Keys

Posted by Jonathan on 09 April 2015 - 08:26 PM

Hi Annie,

 

It sounds as though your keyboard is allowing secondary purposes for your F2-F8 keys by using the Fn key.  This is a trend that started with laptops in order to keep keyboards compact, but some desktop computer manufacturers have started to do this as well to enable quick access to special features.

 

It's usually the case that keys work normally unless you are holding down Fn, but many keyboards of this type have a "Fn Lock" feature that permanently changes their purpose until it is disabled.  I think you have enabled 'Fn Lock' and that is why your keys aren't working as they should.

 

Unfortunately, there is no common standard for this kind of keyboard so I can't offer any advice on how to disable this - it will depend on the manufacturer of your computer.  If the solution isn't obvious, you might be able to find an answer in the manufacturer's documentation or by contacting them directly.




#1498 Excel 2010 Rounding Decimals

Posted by Mike on 01 March 2015 - 07:17 PM

Hi Phil

 

When you've advanced a little further through the course you'll discover how to show as few or many decimal places as you wish in the lesson:

 

Lesson 4-3: Format numbers using built-in number formats

 

But don't jump ahead in the course to session 4.  Just keep progressing lesson by lesson as knowledge builds upon knowledge as you advance through the course and new skills are introduced.

 

Best Regards

 

 

Mike Smart




#10 Forum Rules - Please read before posting

Posted by TheSmartMethod on 02 September 2013 - 02:05 PM

Forum Rules

 

What happens if you break the rules?

The moderator will remove or edit your post and e-mail you explaining why your post has been edited/removed. 

In extreme cases you may be banned (or suspended) from making further forum posts.

The interpretation and application of “the rules” is done by forum moderators.  Their decision is final.

 

The Rules

There are only four simple rules:

 

Rule #1 – Be Nice

If you are a nice person you don’t really even need to read this part!

  • All posts must remain polite and respectful. 
  • User names that have the potential to cause offence to any other user may not be used.
  • Images that have the potential to cause offence to any other user may not be used as avatars.
  • Spam is prohibited.  Spam means the promotion of products or other web sites rather than a genuine contribution towards solving the problem being discussed.  Signatures may not include links to third party websites.
  • You may not use this board to offer solutions in exchange for money.
  • Posts may not promote any illegal activity (such as by-passing copyright protection measures).

Rule #2 – Make the forums as useful as possible

  • Posts must be made in English. 
  • This forum is about using Excel rather than extending it with the VBA programming language.  Suggested solutions to problems must use standard Excel features (including recorded macros) and not be implemented using VBA program code.
  • Do not suggest that a user moves a discussion to private messages or another forum. 
  • Do not post duplicate questions.  
  • If you think another member has broken one of the forum rules use the "Report" button underneath the post to refer it to a moderator. Do not refer to the violation within the discussion thread itself. 
  • The moderators may correct your posts for typos or grammatical errors if this will make them easier for others to read. 

Rule #3 – Do not link to other sites

Your post may still be on our forum in several years’ time. The Internet is constantly changing and if you include links in your posts it is probable that the linked data will change (or disappear completely) in the future. 

 

We can only be sure that links to pages and posts on our own site will always work correctly.

For this reason you can only post hyperlinks to:

  • Any ExcelCentral.com video or e-book lesson
  • Any other thread or posting in the Excel Central forum.

Apart from these two types of links, information should always be provided within the post and not by a link to another resource.

 

Rule #4 – Stay focused

  • Keep scope as narrow as possible.  Don’t ask questions such as: How do I create an accounting system using Excel
  • Use concise and accurate thread titles.  Don’t create threads with abstract names such as Please Help, Need Advice etc.
  • Keep answers on topic.  Don’t post a new unrelated problem on a focused thread.  Start a new thread instead.
  • Do not post one-liners that add no value to the discussion such as OK, I agree etc.

  • jon likes this