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.
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.
Learn what to do when you can't see the data in your cells.
Move around your spreadsheet and still see header rows and columns
Hide your rows and columns from view to clean up your spreadsheets
Need a row or column in the middle of your data? Find out how with this lecture.
Make your text more readable by wrapping it around in your cells
Copy the results of a formula and not the formula itself
Make a sentence or name from multiple cells
Learn what Excel macros are and why you might need to know more about them
Keep others from changing your data or your formulas by protecting your worksheet.
Find out why protecting your entire workbook might be a good thing
Quickly change the formatting of one cell to match another
Data didn't sort? Find out some reasons why your data might not have sorted correctly
Make the text in your cells look different by changing its alignment
Change number formats to make numbers more readable
Move data around to quickly make column headers or rows of data
Break those strings of text into multiple columns
Make the values in your cells look a lot better
Add comments so others know what you are really doing
Can't see everything? Can't see anything? Change the zoom value on your worksheet so you can actually work on it.
Using an Excel cell for comments? Learn how to put each comment on its own line
Stop looking around the ribbon for your favorite commands. Make your own command tab
Print an Excel worksheet and actually be able to use it by printing the gridlines
Find that value you just know is there
Find out all about those mystereous dates and why a number often pops up.
Save a file where you want it and not where Excel wants to put it.
Learn all about the mysterious QAT and how it may help you when working with Excel
Make your spreadsheet show in multiple views so you don't have to keep moving up and down or left and right
Find those formulas someone stuck in your spreadsheet
Why does that box pop up when I try to save Excel for my coworker?
Print in landscape mode so you can see everything
Add tab colors to help group your worksheets together
What does that weird little button do?
Stop wasting paper for those quick print-outs. Print everything on one page.
You'll have to use this tab sooner or later. Might as well learn how to add it to your ribbon.
Get that 1 little column or row to print with the others by changing your page breaks
How many days are left until I retire? Find out how to calculate the difference between dates.
Review time. Help me out by leaving a review of this course so I can make it better.
Test your knowledge - if you dare.
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.