Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2.5 hours on-demand video
  • 64 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Job Search

Basic Excel Questions for Job Interviews

Learn Excel Skills and Job Interview Questions Simultaneously
Rating: 4.3 out of 54.3 (9 ratings)
1,675 students
Created by Interview 2 Learn
Last updated 7/2015
English
English
30-Day Money-Back Guarantee

What you'll learn

  • 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.

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.

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.

Who this course is for:

  • 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.

Course content

4 sections • 44 lectures • 2h 24m total length

  • Preview02:52
  • Preview01:17

  • Preview01:41
  • Preview01:24
  • Preview03:12
  • How do you sort data?
    Preview10:47
  • Preview03:51
  • Preview03:49
  • Preview01:58
  • Preview01:28
  • What is Autofill?
    Preview13:03
  • How do I copy the value and not the formula to another cell?
    03:29
  • How can I combine two text cells together to create one word or sentence?
    04:22
  • What are Excel macros?
    02:48
  • How do you protect a worksheet from changes?
    06:20
  • How is protecting a worksheet different than protecting a workbook?
    05:04
  • What is the format painter?
    02:51
  • What can mess up a data sort?
    01:47
  • How do you change a cell's alignment?
    04:06
  • How do you change number formats?
    02:49
  • How can I convert a row of values into a column of values?
    01:59
  • How do you change a string of text into multiple columns of text?
    04:07

  • How do you format data in a cell?
    05:44
  • How do you insert a comment in a cell?
    04:24
  • How do you change the zoom on a worksheet?
    03:03
  • How can I make text in a cell appear on multiple lines?
    02:51
  • How can you group your most popular commands on the ribbon?
    04:17
  • How can I show the gridlines when printing an Excel sheet?
    01:12
  • How do you find a value in Excel?
    02:15
  • How do dates work in Excel?
    06:25
  • How can you change the default file save location?
    01:32
  • What is the QAT?
    01:54
  • What are split panes?
    04:15
  • How do you find which cells have a formula in them?
    03:33
  • What is the Compatibility Checker?
    01:47
  • How do you set a page to print in Landscape mode?
    01:40
  • How do you change the worksheet tab color?
    02:12
  • How do you find out what a button on the ribbon does?
    01:35
  • How do you print a worksheet so that it all fits in one page?
    01:10
  • How do you show the Developer tab?
    01:12
  • How do you change a page break?
    02:39
  • How do I calculate the difference between two dates?
    03:03

  • Help me out my leaving a review of this course
    2 pages
  • Course Knowledge Test
    1 page

Instructor

Interview 2 Learn
Instructor
Interview 2 Learn
  • 4.3 Instructor Rating
  • 9 Reviews
  • 1,675 Students
  • 1 Course

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.