+ Reply to Thread
Results 1 to 11 of 11

How to help a beginner user?

  1. #1
    Registered User
    Join Date
    07-11-2017
    Location
    London
    MS-Off Ver
    2007
    Posts
    0

    How to help a beginner user?

    Hi everyone,

    Here is a tricky question due its nature (forum rules) and I don't know how to address it in a correctly way. Also I would like to make a clear remark:

    • A: I would like to have counsel about legal and free Excel courses for beginners that everyone can access or personal exercises made from oneself or personal material from teachers or other members of the forum.
    • B: With this I'm not intended to break any of the respectable rules stated for this forum.

    Here is the issue. My girlfriend is about to start soon her first job in a office environment due the nature of hers future job. But now she's facing the challenge to work with Excel in her daily basis as beginner user, challenge she has never faced before. We can say that she isn't very IT literate, just basic emails, cloud services, MS Word and Power Point.

    The bad thing about it is that she has not patient in terms of learning IT and I 'm not very good at teaching, I use to go to the origin of everything for her to understand the reason and the meaning for the task we are talking about. (As you can see I'm very chatty!).

    A few weeks ago I bought her a beginner book that explains Excel in a very easy language and with simple steps to understand the most common features of Excel from basic aspects and features such as essential editing/formatting techniques to basic formulas and functions. I thought it was enough but she has a major point. She cannot learn until she practise all what the book says. Unfortunately the book doesn't has exercises.

    I haven't the time, the knowledge and the patient for creating her exercises following the book, so here my request:

    Does anyone has/know any free-legal websites, personal exercises for beginners or even better if I'm lucky and at this community are some teachers that could hand me some basic exercises that they've to help their pupils or students.

    I don't want to encourage anyone to break the forum rules and try to sell, promote or benefit from their products/services.

    Please help!!
    Last edited by Targaryen; 07-14-2017 at 10:37 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    2013
    Posts
    4,916

    Re: How to help a beginner user?

    what is her Job Title?

    Administrator?
    Data Entry
    Accounts Clerk?

    Excel is a massive program.

    If we know what she will use it for then we could create a sample workbook for her to get started with.

    https://www.techonthenet.com/excel/formulas/cdate.php
    Please help by:

    Saying Please and Thank you.

    Making requests not demands. I ignore demands.

    Check back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2010
    Posts
    1,591

    Re: How to help a beginner user?

    There's a thread with useful links that might be helpful. I haven't been through many, but I imagine she'll find some good stuff within:

    https://www.excelforum.com/excel-for...additions.html
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    1,826

    Re: How to help a beginner user?

    Welcome to the forum
    Here is one suggestion
    Last edited by kev_; 07-14-2017 at 06:00 PM.

  5. #5
    Registered User
    Join Date
    07-11-2017
    Location
    London
    MS-Off Ver
    2007
    Posts
    0

    Re: How to help a beginner user?

    Hi mehmetcik!

    Sorry you are right, I didn't mention her future job title or her future work field.

    At the moment she is studding a HR Management Master (started this February). She wants to do a internship in her spare time (two days a week) to gain experience and be more prepare for the real world once she finish with it. So as a natural decision, she is applying for HR Admin/clerk (basic role). Could be payroll, development & training, recruitment or other field of her study area. As I am not working in this field (always I've worked in Operations Luxury Retail and now ERP - Microsoft Dynamics AX implementation) I do not have a clue what her daily duties will be in terms of Excel. I guess all sort of reports, time sheets and other employee's related data.

    So I am looking for something that could gather and cover all basic areas for an office environment, nothing to specific owing the company should provide training for their employees with the programs and tools they use for the normal activity for their business.

    Thank you very much for the link you provided, I really appreciate it, but it looks like doesn't fit her needs at the moment.

    I do not know if I have made it clear of I've messed even more...

    Many thanks!

  6. #6
    Registered User
    Join Date
    07-11-2017
    Location
    London
    MS-Off Ver
    2007
    Posts
    0

    Re: How to help a beginner user?

    Hi CAntosh!

    Whoa!! Thank your very much for your link, it has very useful information!!

    I just been checking some links and looks sooo interesting! But to be honest with you these link is going to be useful for me not for her at the moment (I can tell you that I'm going to use some of these links for my personal knowledge!)

    But unfortunately it is to much for her. She's starting to discover about the Excel world, but even she's a smart girl, she's starting to discover how Excel works, she is getting familiar with all command button on the ribbon, so we need to go step by step, slowly but surely.

    Do you know if is in this forum any thread related to very, very beginner users?

    Many thanks!!

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,352

    Re: How to help a beginner user?

    She should start practicing using excel with you if...

    Quote Originally Posted by Targaryen View Post
    these link is going to be useful for me not for her at the moment (I can tell you that I'm going to use some of these links for my personal knowledge!)
    sandy (all lowercase letters)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  8. #8
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    2013
    Posts
    4,916

    Re: How to help a beginner user?

    Try this as a start.

    I use a workbook to store everything that I learn.

    Let me know if this approach will work and I will add more data for you.
    Attached Files Attached Files
    Last edited by mehmetcik; 07-14-2017 at 08:28 PM.

  9. #9
    Registered User
    Join Date
    07-11-2017
    Location
    London
    MS-Off Ver
    2007
    Posts
    0

    Re: How to help a beginner user?

    Hi Kev_!!

    That is the kind of stuff I was looking for!! You have hit the nail on the head!! Thank you very much!!

    At the moment we are using MS Office 2007, our trial licence for MS Office for Windows10 expired shortly after we bought our laptops about a year ago and hence the respective licence.

    However for the exercices you have linked I will try to extrapolate the interface of Excel 2010/2016 to 2007 version in my best way. Basically it has the same layout as previous versions and the tasks are performed in the same way whichever Excel's oldest versions. Even if the ribbon and the Office button are slightly different in terms of features and look, I could manage to use the basic concepts of formatting, basic formulas/functions, tables, filters and others.

    I think it could easily work, in any case I will let you know in a couple of weeks if I the outcome is succesful.

    Thank you!

  10. #10
    Registered User
    Join Date
    07-11-2017
    Location
    London
    MS-Off Ver
    2007
    Posts
    0

    Re: How to help a beginner user?

    Great idea! You are right she can be next to me when I practise with the links provided!!

    This is very true sandy666, the best way to learn is watching someone play around and see what is going on, then she will have a clear picture how Excel works, even if I am practising with complex stuff, she can pick up all the basic concepts.

    She is very clever, well in my humble opinion and experience all women are far clever despite the subject they are dealing with, but for her and in terms of Excel (and with new technologies, pc, smartphones and other devices) she particularly does not have the same view, patient and passion that the people in this forum share in common.

    But for sure I'll take your advise!

  11. #11
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    11,581

    Re: How to help a beginner user?

    Try Excel is fun.

    https://www.youtube.com/user/ExcelIsFun
    You can download the exercises with solutions. He is a good teacher and has good teaching skills. It covers all excel topics except VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1