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




#86 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.



#579 Calculating Payments, Present Value, Interest Rate and Period in Excel

Posted by Jonathan on 10 December 2013 - 11:36 PM

Hi TJ,
 
You seem to be asking if you can calculate any of the four values (Payments, Present Value, Interest Rate and Number of Periods) as long as you know three of them.  Fortunately, Excel has a separate function to calculate each one of these!  These are the PMT, PV, RATE and NPER functions.
 
You can calculate Payments by using Excel's PMT function, as covered in Expert Skills Lesson 3-3: Use the formula palette and the PMT function.
Each of the four functions works in a very similar way, so I would recommend starting here and making sure that you completely understand the PMT function before continuing with the others.
 
If you wanted to calculate the Present Value when you knew the Payments, Interest Rate and Number of Periods, you could use the PV function in the same way as you would use the PMT function. The PV function is fully explained in Expert Skills Lesson 3-4: Use the PV and FV functions to value investments.  This lesson also covers the FV function, which allows you to calculate the Future Value - see the lesson for more on this.
 
If you wanted to calculate the Interest Rate when you knew the Payments, Present Value and Number of Periods, you could use Excel's RATE function.
 
If you wanted to calculate the Number of Periods based on the Present Value, Interest Rate and Payments, you could use Excel's NPER function.
 
The PMT, PV, RATE and NPER functions all work in a very similar way.  The only difference between them is which of the four values they calculate.
 
I have attached an example spreadsheet showing how to calculate each of the four values.
 
Attached File  Interest.xlsx   11.67KB   239 downloads
interest.png
 
If you are having difficulty understanding how to use any of the four functions, I recommend reviewing the following lessons and making sure that you understand all of the concepts covered:
Expert Skills Lesson 3-3: Use the formula palette and the PMT function
Expert Skills Lesson 3-4: Use the PV and FV functions to value investments
 
I hope this information is useful. If you are having trouble implementing this, please reply to this post with further details of what you are trying to do.




#468 Can I download sample files on two computers.

Posted by Mike on 28 October 2013 - 08:23 PM

Yes.  You can download the sample files to as many computers as you want to.  You can even do this if you haven't purchased a course or book (to use with the freeview system).




#2458 Retrieving the month from a European Style week no

Posted by Jonathan on 09 August 2016 - 01:09 PM

Hi Karcy,

 

Your formula is returning the correct dates for each week number according to the WEEKNUM function, but you're likely finding that it is returning December for the first week of 2015 because the Monday of that week occurred on the 29th of December 2014. This is technically correct, so you may need to work around this with an IF function if you want it to always return January for the first week.

 

You can see an in-depth explanation of how to use the IF function in the video lesson: Expert Skills Lesson 3-5 Use the IF logic function.

 

I have attached an example workbook using your formula, along with an IF function applied to return the desired month. It also shows your formula applied to all weeks in 2015 and 2016, proving that the result always matches the result of the WEEKNUM function:

 

Attached File  ReverseWEEKNUM.xlsx   14.37KB   33 downloads

ReverseWEEKNUM.png

 

You might notice that I've also removed the CHOOSE function from your formula and replaced it with a custom format (mmm) that simply displays the Month part of the date. You can see an explanation of custom formats and how to apply them in the video tutorial: Essential Skills Lesson 4-4 Create custom number formats.

 

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




#2319 Charting using {=TABLE()}

Posted by Jonathan on 22 April 2016 - 07:14 PM

Hi Budana,

 

The TABLE function only works in conjunction with Excel's Data Table feature, so you will only see it where a data table has been used.

 

You can see a complete explanation of data tables in the following video lessons:

Expert Skills Lesson 7-1 Create a single-input data table

Expert Skills Lesson 7-2 Create a two-input data table

 

If you create a data table using the skills taught in those lessons you should be able to apply it to charts like the one in your example.

 

I hope this helps, but please feel free to reply if you need any more help with this.




#2265 number formats

Posted by JPK1066 on 29 March 2016 - 08:28 PM

Hi

 

 I;m trying to copy a WS with a lot of 1-0 and 2-0 and 1-3 counts and Excel keeps reading it as a date ... how do I get an exact copy of the numbers?




#2059 Is it possible to immediately display a comment or something on a locked shee...

Posted by Murph on 01 December 2015 - 05:48 PM

Hi Jonathan

 

What I am attempting to do I have attached as a sample, to illustrate the need.

 

What I would like to do is once the user has a choice to enter a Y or N, (I already have the Data Validation routines functioning as you suggested).

But additionally, I would like to pop a separate box or window with a fully detailed description of what they are replying to.

So the first line is a light overview of the question.

 

The popped box would contain full details for example:

Situation1: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Situation2: Not applicable
Situation3: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 
The Data Validation pop boxes have a very limited flexibility it appears on formatting the message.
 
I noticed the Title is presented with a bold font which is nice, however if the user wants to enhance any portion of the actual Input Message, this appears not to be possible.
 
Thanks!!

Attached Files




#1885 how to title/name columns

Posted by Jonathan on 11 September 2015 - 09:29 PM

Hi Beloved,

 

If you create a Table, the headings in the Table will always appear at the top of the Excel screen even if you have scrolled down so that the first row is no longer visible.

 

You can see this in action, as well as how to create a Table in the video lesson: Expert Skills Lesson 1-11 Convert a range into a table and add a total row.

 

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




#1795 Custom View button is disabled

Posted by Jonathan on 05 August 2015 - 06:47 PM

Hi jegllaume,

 

There are a number of treasons why this can happen:

I hope that you're able to solve the proble with this information, but if not please feel free to attach your workbook and I will take a look at it.

 

For instructions on attaching workbooks to posts, click here.




#1377 Consolidate figures from raw data

Posted by Jonathan on 10 January 2015 - 04:19 PM

Ok sir..This what actually i want....And i have one doubt...If i am creating a template using the file you have send, but by deleting all the sourse data from 'weighment sheet', keeping the pivote table format as such, won't it be work?...Because, if somebody else is using this file, by entering data in weighment sheet itself, they will get the consolidated data they need...

 

You should be able to use this as a template if you delete every row from the table except for the first one. You need to keep the first row, since deleting the first row would remove all of your formulas.

 

Because the data is held in a Table, the pivot tables will automatically pick up any new data that is added by the user when they are refreshed.

 

As I mentioned in my previous post, you can find more about Tables in: Expert Skills Lesson 1-11 Convert a range into a table and add a total row.  I really recommend reviewing this lesson if you're not sure about Tables.




#1140 Formatting a range using an Excel macro

Posted by Jonathan on 11 September 2014 - 08:13 PM

Hi Frank,

 

I'm not quite sure if I'm understanding what you're trying to do, but it sounds like you could do this by recording a Macro that cuts cells A2:A5 and pastes them into cells A1:A4, then cuts cell B3 and pastes it into cell A5.

 

You wouldn't be able to make this happen automatically with a macro, but you could use a shortcut key or link a button to your macro in order to run it very quickly and easily.

 

For instructions on how to record a macro, see the video lesson: Expert Skills Lesson 9-11 Record a macro with absolute references.

For instructions on linking macros to buttons, see the video lesson: Expert Skills Lesson 9-16 Use shapes to run macros.

 

I hope this helps, but if you'd like me to take a look at your workbook, please feel free to reply and attach it.  For instructions on how to attach files to posts, see this thread.




#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


#1458 Access 2013 vs Excel 2013

Posted by Jonathan on 06 February 2015 - 08:18 PM

Hi Shawn,

 

It sounds like you need a system that allows you to maintain a table of Customers and store a list of Service Tickets for each customer. This is known as 'relational' data because there is a relationship between Customers and Service Tickets. While Excel 2013 has introduced some tools for working with relational data, Access is really the best choice when you need this kind of system.

 

For a more in-depth explanation of relational data, see the video lesson: Expert Skills Lesson 6-1: Understand primary and foreign keys.

 

Although Access is a good choice for storing relational data, Excel can still be very useful as a tool for analyzing the data in your Access database. You can see how to connect an Excel workbook to an external data source (such as an Access database) in the video lesson: Expert Skills Lesson 5-4: Use an external data source.

 

I hope this helps, but please feel free to reply if I can offer any more advice.