Embedded Files
About Me
About Me
Microsoft Excel
Microsoft Excel
A spreadsheet system, which is used to enter, organize (edit, format, sort), perform mathematical computations, save, analyze, summarize & print numerical data.
A spreadsheet system, which is used to enter, organize (edit, format, sort), perform mathematical computations, save, analyze, summarize & print numerical data.
Our Objectives
Our Objectives
Provide a systematic understanding of a spreadsheet & its benefits
Provide a systematic understanding of a spreadsheet & its benefits
Provide essential skills of effectively utilizing spreadsheet software in day-to-day business environment
Provide essential skills of effectively utilizing spreadsheet software in day-to-day business environment
Why is this workshop important?
Why is this workshop important?
MS Excel is the most important computer programs used in the workplace today
MS Excel is the most important computer programs used in the workplace today
Workers are required to learn Excel to enter or remain in the workplace
Workers are required to learn Excel to enter or remain in the workplace
Many employers rely on Excel for decision support
Many employers rely on Excel for decision support
Without Proficiency in MS Excel…
Without Proficiency in MS Excel…
Situation 1
Situation 1
Situation 2
Situation 2
Situation 3
Situation 3
Top 40 Microsoft Excel Interview Questions
Top 40 Microsoft Excel Interview Questions
Can you answer the following questions confidently? How many of them?
Can you answer the following questions confidently? How many of them?
What is Microsoft Excel?
What is ribbon?
Differentiate between workbook and worksheet.
How many data formats are available in Excel? Name some of them.
Specify the order of operations used for evaluating formulas in Excel.
How can you wrap the text within a cell?
Is it possible to prevent someone from copying the cell from your worksheet?
What are charts in MS-Excel?
How can you sum up the Rows and Column number quickly in the Excel sheet?
Explain few useful functions in Excel.
What does a red triangle at the top right of a cell indicate?
How can you add a new Excel worksheet?
What is the use of NameBox in MS-Excel?
How can you resize the column?
Explain pivot tables and its uses.
What are three report formats that are available in Excel?
How would you provide a Dynamic range in "Data Source" of Pivot Tables?
Is it possible to make Pivot table using multiple sources of data?
How can you disable automatic sorting in pivot tables?
What is Freeze Panes in MS-Excel?
What could you do to stop the pivot table from loosing the column width upon refreshing?
Explain workbook protection types in Excel.
Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel?
Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel.
What is IF function in Excel?
Can we create shortcuts to Excel functions?
What is the use of LOOKUP function in Excel?
How can you apply the same formatting to every sheet in a workbook in MS-Excel?
What are left, right, fill and distributed alignments?
To move to the previous worksheet and next sheet, what keys will you press?
What filter will you use, if you want more than two conditions or if you want to analyze the list using database function?
What is the quick way to return to a particular area of a worksheet?
Which function is used to determine the day of the week for a date?
What is the benefit of using formula in Excel sheet?
What is the "What If" condition in Excel formulas?
How can you disable the automating sorting in pivot tables?
What is the AND function does in Excel?
How cell reference is useful in the calculation?
Explain Macro in MS-Excel.
Which are the two macro languages in MS-Excel?
What to discuss
What to discuss
Excel Basic
Working with formulas and functions
Data Analysis
Data visualization with excel dashboard
Our Target
Our Target
Our Approach: Active Learning
Our Approach: Active Learning
We will apply the participatory learning approach or active learning in this training, in which learning is undertaken 'with' rather than 'for' participants.
Our Training Rules
Our Training Rules
Open Minded & Enthusiast
Open Minded & Enthusiast
Think, do, & be positive
Think, do, & be positive
Get Involved
Get Involved
Let's interact
Let's interact
Down to earth
Down to earth
Open up your Camera
Open up your Camera
Online Training Rules
Online Training Rules
Be on time for each virtual session
Be on time for each virtual session
As a best practice, be just a few minutes early!
Asking questions
Asking questions
You may ask the questions during the speaker is talking through the following ways:
Write your questions in the chat box.
Raise your hand by clicking the raise hand button. The host/speaker will unmute your mic, then you may ask question when the host/speaker allows you to speak.
Communicate professionally with others
Communicate professionally with others
Wait for others to finish speaking before you speak.
Each time you speak, state your name so that others begin to recognize your voice.
Build on others’ ideas and thoughts.
Disagreeing is OK – but be respective and courteous.
Participate actively in each session
Participate actively in each session
Share experiences and best practices.
Bring up challenges.
Discuss successes.
Morning Challenges
Morning Challenges
Can we do each of the challenges in one minute?
You want to exercise your brain more?
You want to exercise your brain more?
References
References
Seek for knowledge from the cradle to the grave
~ Al-hadith narrated by Bukhari ~
Google Sites
Report abuse