Basic Excel Questions for Job Interviews

Learn Excel Skills and Job Interview Questions Simultaneously
5.0 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,650 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 44
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

Microsoft Office contains a power tool that is being used all over the world. Excel is used by numerous companies and individuals for tasks ranging from a basic task list to advanced financial operations.

Don't let the concept fool you, this is a complete course for those missing to learn more about Excel.

During the demonstrations for each lecture, the question is not only answered through series of exercises, you will often get more information than the question itself.

An example would be this question:

What is Autofill?

A very easy question to answer with a very short answer. In this course, the demonstration to answer this question has 29 Exercises with a total of 36 steps.

Easy question and answer, but fully demonstrating this feature take a few minutes. I do not simply want to answer the question and provide a quick demonstration of 1 or 2 different things you can do with this feature. I want to give you enough knowledge to not only answer any interview questions you may have about this topic, but to discover how you might be able to use the feature during your daily work with Excel at your job.

Using this new way of learning a technology subject, you will gain the confidence you need to “ACE” common Excel interview questions you may get during your next job interview and get the job or promotion you deserve.

What will I learn?

Interview2Learn's basic Excel interview questions course contains 40 basic questions with provided answers that you can use during an interview. I also provide videos with me working through each answer so that you can fully understand each answer.

Workbooks and exercise PDFs are provided so each student can work on the exercises at their own pace. Giving you the workbook with my sample data and the steps allows you to try on your own and if you get stuck - go back to the lecture video and watch me work through it.

There is also two downloads at the end of the course with every question in this course. The first download are only the questions. This gives you a chance to try them yourself.

The second download is the questions and the basic interview ready answers. Let's you practice how you would answer the question during an actual interview.

And because you have the demonstration videos and manuals and you have taken the time to go through each one on your own - you'll be able to answer each question with confidence during your interview and go further into the answer if the asked.

Not interviewing for a new job, but still need to understand Excel?

No problem, in order for you to understand the answer to the interview questions we provide very detailed explanations and demonstration exercises. Following along with the explanations and explanations will give you the knowledge you need to put Excel to work for you immediately. The interview questions serve to “bind” the knowledge you obtain for common scenarios you may find on the job. Instead of a simple “Next Slide”, you get a question you to think about. It is this process that will make the information stand out in your mind the next time you encounter a similar scenario while working.

What are the requirements?

  • Students should have knowledge of basic Microsoft Excel before starting the course.
  • Students should have access to a Excel 2013 in order to complete the lecture exercises on their own.
  • Students should be willing to learn Excel in a new way.
  • Students should be curious about the subject to expand on what is taught during the course.

What am I going to get from this course?

  • Complete the knowledge test at the end of the course in order to gauge the knowledge they gained during the course.
  • Have confidence in their ability to answer common Excel interview questions.
  • Have a better understanding on how to use Excel in your day-to-day work.
  • Reduce the amount of time it takes to develop future Excel spreadsheets.

What is the target audience?

  • Anyone who is about to sit through an interview for a job that might use Excel should take this course.
  • Anyone who is struggling to work through basic Excel spreadsheets should take this course.
  • Anyone who wishes to learn a few tips and tricks to speed up your spreadsheet development.
  • Anyone who wishes to get a better job but can't because of a lack of basic Excel skills.
  • Anyone who has no understanding of Microsoft Excel should not take this course until they have a basic understanding of Excel.
  • Anyone wishing to fail their next interview and stay at their same job because they couldn't answer common Excel interview questions should not take their course.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Requirements
02:52

Learn all about this exciting new way to learn Excel. Our series of interview questions are designed to help you pass interviews asking common Excel questions and at the same time give you the knowledge needed to use Excel on your daily job.

01:17

What do you need to know in order to begin this course? What software is needed? Anything else?

This lecture will let you know the details of the course and how what you need to know and have before beginning this course.

Section 2: Interview Questions Part 1
01:41

Learn what to do when you can't see the data in your cells.

01:24

Move around your spreadsheet and still see header rows and columns

03:12

Hide your rows and columns from view to clean up your spreadsheets

10:47

Sort your data how you want it and not how you have to enter it

03:51

Need a row or column in the middle of your data? Find out how with this lecture.

03:49

Make your text more readable by wrapping it around in your cells

01:58

Bring two or more cells together

01:28

Show all your data in a quick and easy way

13:03

Let Excel complete a sequence of data or fill cells for you

03:29

Copy the results of a formula and not the formula itself

04:22

Make a sentence or name from multiple cells

02:48

Learn what Excel macros are and why you might need to know more about them

06:20

Keep others from changing your data or your formulas by protecting your worksheet.

05:04

Find out why protecting your entire workbook might be a good thing

02:51

Quickly change the formatting of one cell to match another

01:47

Data didn't sort? Find out some reasons why your data might not have sorted correctly

04:06

Make the text in your cells look different by changing its alignment

02:49

Change number formats to make numbers more readable

01:59

Move data around to quickly make column headers or rows of data

04:07

Break those strings of text into multiple columns

Section 3: Interview Questions Part 2
05:44

Make the values in your cells look a lot better

04:24

Add comments so others know what you are really doing

03:03

Can't see everything? Can't see anything? Change the zoom value on your worksheet so you can actually work on it.

02:51

Using an Excel cell for comments? Learn how to put each comment on its own line

04:17

Stop looking around the ribbon for your favorite commands. Make your own command tab

01:12

Print an Excel worksheet and actually be able to use it by printing the gridlines

02:15

Find that value you just know is there

06:25

Find out all about those mystereous dates and why a number often pops up.

01:32

Save a file where you want it and not where Excel wants to put it.

01:54

Learn all about the mysterious QAT and how it may help you when working with Excel

04:15

Make your spreadsheet show in multiple views so you don't have to keep moving up and down or left and right

03:33

Find those formulas someone stuck in your spreadsheet

01:47

Why does that box pop up when I try to save Excel for my coworker?

01:40

Print in landscape mode so you can see everything

02:12

Add tab colors to help group your worksheets together

01:35

What does that weird little button do?

01:10

Stop wasting paper for those quick print-outs. Print everything on one page.

01:12

You'll have to use this tab sooner or later. Might as well learn how to add it to your ribbon.

02:39

Get that 1 little column or row to print with the others by changing your page breaks

03:03

How many days are left until I retire? Find out how to calculate the difference between dates.

Section 4: Course Wrap Up
2 pages

Review time. Help me out by leaving a review of this course so I can make it better.

1 page

Test your knowledge - if you dare.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Interview 2 Learn, Instructor

Interview2Learn is an industry leader in providing sample interview questions on a wide range of technical topics. Our team of technology professionals have been consulting, training, and giving interviews for over 20 years. We strive to help technology professionals and candidates increase their confidence level in their ability to “ACE" their next technical interview.

Ready to start learning?
Take This Course