The one who Present Skills / Express their Talents,
are Only Recognized and are Successful in Life.
For Expressing the Talent in a right way , the person first
should know "How to Present it ??"....
|
|
Talent results in Good performance , Good performance
comes from Consistent Smart working , Systematic Review with
RCA (Root cause analysis) and CAPA (Corrective and Preventive
Action).
|
|
While coming to the point Good Performance, Many of us
perform well but are not good at Presenting.
|
|
Everything in Life can be measured through Data , Actual or
Approximate.
|
|
Data Presentation is a Tool which measures our Performance.
|
|
For Data Presentation we need to now the Tool of presenting.
Many Softwares are developed where there have made life easier
by Automating Data Management...
|
|
But how many ever may be the Advanced Software found, basic
reporting will be made in “MS-EXCEL”.
|
|
💻 Even if you come from a software development and computer
science background. U will look down upon Management who
use excel for Task Management while they are thousands of lines
of C++ code.
|
|
Even if u work on bug tracking and management,
Guess what U use?
|
|
Excel, ofcourse ...Then when moving to testing, and U need the
simplest way to port test data from script outputs to make reports
for the management team.
|
|
Any guesses?
|
|
Excel’s data import functionality.
|
|
U been a part of a team that use the functionalities in Excel to
model really Large business cases - U should know how to read
an Excel file!
|
|
U have to learn the tricks of Excel.
|
|
Counting, subtraction, multiplication, summation,
|
For each, there is a unique function
|
|
Some of its features are really cool! You can use it for copying
and pasting
|
You can do conditional formatting, You can use it for data filtering,
|
You can use it for maths,
|
You can use it for stats,
|
You can create macros and formulae
|
And with each cell, it lets you play!
|
You can draw pies and graphs,
|
You can prepare all kinds of charts,
|
.xls is the extension of the only file,
|
which makes the management smile 😊
|
|
|
Now go ahead and learn Excel to Excel in ur Profession.. 👍
|
|
And they is no Question of MBA or UG students who come from
any core subjects like..
|
|
1. Sales & Marketing
|
2. Finance
|
3. Costing
|
4. Human Resources
|
5. Material Management....etc
|
|
|
Excel Skills are necessary to understand Management Reporting...
|
|
|
********************************************
|
|
Now learn how to EXCEL in MS-EXCEL
|
|
We generally have an thinking that learning EXCEL else Data
reporting is a simple one which can be learned after getting JOB.
But there are many tools which are useful to learn before joining
an Organization...
|
|
Every company has its own format to be filled , Data to be projected,
Analysis to be made. Using Excel, you can present your performance.
Even it is Self Assessment Report to assign your Own performance...
|
|
However good your are in Work , you have to present in a
Professional manner to project your Performance..
|
|
It is tool to Remind, Mend your target yourself, It is a Hidden
Boss who supports you to know yourself
|
|
One of the best tool to present data / Performance is a Graph
|
|
And
|
|
Reports are mostly used in All the departments, Learning the
below Topics to Sustain in this Competitive Work Environment....
|
|
1. Advanced Excel
|
2. Macros for Data Management(Reduces Repetitive Works)
|
3. Report Analysis
|
4. Dynamic Excel Charts
|
5. Interactive Power Point Presentation
|
6. Process Flow Chart
7. SWOT Analysis
8. CAPA + PDCA
|
|
|
👆 Above All Skills are essential to get a Job and even Sustain
later ...
|
|
All type of Departments need the Skills....👇
|
|
1. Sales & Marketing
|
2. HR
|
3. Brand Analytics
|
4. Production
|
5. Purchase
|
6. Finance & Costing
|
7. Customer Care
|
8. Stores
|
9. Subcontract
|
10. Company Secretary.......
|
|
|
Course Covers the below List of Topics :
|
|
1. MIS Reports (Management Information Systems)
|
2. BI Reports (Business Intelligence)
|
3. Data Analysis Reports
|
4. Data Forms, Report Templates
|
5. Interactive PowerPoint Templates
|
6. Process Flow chart
7. SWOT Analysis
|
8. CAPA + PDCA
|
TOPICS 1 -4
MIS : MANAGEMENT INFORMATION SYSTEM
• Data : A Fact or a piece of information
• Information : Knowledge discerned from Data
• Business Intelligence : Information Management pertaining to
an organization’s policy or decision – making , particularly
when tied to strategic or operational Objectives
|
A Data should be with all the information required. For getting a Graph ,
Good Data formatting is required
GRAPHICAL DATA
|
|
Bar & Line Graph Combined :
|
Bar and Line with Trend Graph :
If you have a Target of 10 Tasks / may be that relate to
Sales/ Data collection / Data entry / Finance information /
Back office work / Production / Top Management .
|
|
Anecdotes / Analysis Points :
|
|
1. Even after reviewing the previous years average - Targets are
not revised . Management should have reviewed the performance
in a periodically manner so that the required training should have
being given to continue the Task.
|
2. Monthly Data should be reviewed to upgrade the performance,
else there will be shocks to Boss and themselves.
Consistency is much important than.. Target Achievements.
|
3. Go through Micro level data to analyze where he did better
Performance and continue the systems or learning to improve
or sustain the same performance.
|
4. There is a Trend line where it shows the projection based
on previous months achievements
|
DYNAMIC GRAPHS
|
|
|
Here you can see the State, which can be selected , also another
arrow shows the Persons in that state , where at a glance all the data
for all states and all staff are captured here using Data format :
Vlookup, IF , Pivot Tables, Name Manager , List box , Data Graph
Layout , Name manager
|
VLOOKUP PICTURE
|
|
You would have worked on Vlookup using for data , but we can
use it for picture also, for example : if we select Name the Image
reflects
|
GROUPING COLUMNS/ ROWS & AUTO COLORING
THROUGH CONDITIONAL FORMATTING
|
Color is a Good tool in Analyzing...
It is an Symbolic Representation
|
AUTOMATE DATA FORMS & REPORTS
|
|
Name Manager, Data Validation, Indirect, Substitute, Shapes,
Conditional Formatting
|
|
This is a Excel Sheet which resembles like a Form for Data entry
which can be used for automating Sales Reports & Performance
|
EXCEL VBA MACROS
|
AUTOMATE DATA FORMS & REPORTS
|
|
Macros Enable to reduce the Time in working on Repeated Tasks
|
|
Macros help in recording the Task and repeat End
number of times which saves time and manual Errors.
|
|
For example Bulk Emails , Formatted reports , Data Alignment ,
Corrections etc.
|
| List of
Advanced Formulas to present DATA |
| 3. Pivot
Table & Pivot Reporting |
| 6. Advanced
Filter & Sort |
| 8. Conditional
Formatting |
|
|
|
| COURSE
IN A GLANCE |
|
|
| Editing Workbooks |
| Cell / Text Alignment |
Entering, Editing
,Deleting, Moving & Copying Text / Data |
| Format Cells ( Numbers, Dates) |
| Font Style & Size |
| Text Alignment |
| Borders & Shades |
| Merge & Wrap |
| Pastespecial |
| Format Painter |
| Save As Excel |
| Create New Excel Sheet |
| Move or Copy Sheets |
| Hiding / Deleting Sheets |
| Open / Shift / Close |
| Adding Shapes/Text Box |
| Pivot
Tables |
Pivot Table Wizard •
Changing the pivot table layout • Formatting • |
| Grouping items • Inserting fields • Pivot Table Options |
| Lay out reports directly on worksheet • Pivot Chart |
| Using navigation techniques |
1) CTRL + Arrow Key. While the arrow keys
are used to navigate
around the worksheet, they only move one cell at a time.
...
2) SHIFT + Arrow Key. ...
3) CTRL + PgUp/PgDown. ...
4) F2 key
5) CTRL + 1 |
| Protect & UnProtect |
Rows/Columns/Sheet |
|
Sharing a file •
Tracking changes • Accepting or rejecting changes |
| Smart Charts |
Organisational
Charts, Dynamic Charts, Editing and Formatting charts |
|
| Formatting Worksheets |
| Print Alignment |
Adjust
Margins |
| Page Orientation |
| Header and Footer |
| Inser Page Breaks |
| Set Background |
| Page View |
Freeze
Panes |
| Formatting and Proofing |
Formatting
Cells with Number formats, Font formats, Alignment,
Borders, etc •
Copying and Clearing Formats • Working with Styles •
Spell Check, Find
& Replace and AutoCorrect |
| Conditional Formatting |
Color
shading based on Values / Formulae |
| Unique & Duplicate Text Highlight &
Removal |
| Icon Sets |
| Data Filters (Advanced Filters) |
Data Sorting (Sorting Data • Adding Subtotals
• Autofilter •
Freeze Panes • Group and Outline ) |
| Using Ranges |
Data Validation ( Using Auto Lists &
Applying Data validation rules
• Inserting comments, Advanced List
Management ) |
| Precedents/Dependents • Goto Special |
| Using Styles |
| Using Themes |
| Using Templates |
| Using Macros |
Introduction to
Macros • Automate repeated works |
| Purpose of Macros • Recording macros • Where to save macros |
| Running macros: • Custom buttons, menu items, keyboard shortcuts |
| Using Outlook |
Email
Link |
| Working with Formula |
Sum,
Average, Max, Min, Coun, CountA, Countif, If Statements,
Nested If, If And ,
If OR , Combining If, Sum If, Proper ,Lower, Left,
Right, Substitute ,
Indirect |
| Lookup & Information Functions • |
Vertical
Lookup (Vlookup) • Horizontal Lookup (Hlookup) |
| Vlookup Picture |
| Match & Index |
| Hyperlinks |
Range Names • Concept and Purpose •
Naming individual or range cells
• Deleting and amending named ranges
•
Using named cells/ranges in formulae |
| Formulae Auditing Tools • Revealing
Formulae • Tracing |
| Name Manager |
| Advanced Charting Using List Box |
| Advanced Filter |
| Grouping , UnGrouping |
| IsText, IsDate , IsNull , IsErr,
Is Error, IsNa |
| What If
Analysis |
Scenarios • Goal Seek
• Solver |
|
|
|
| Shorcuts |
| Ctrl+S |
Save |
| Ctrl+C |
Copy |
| Ctrl+V |
Paste |
| Ctrl+X |
Cut |
| Ctrl+Z |
Undo |
| Ctrl+Y |
Redo |
| Cropping |
Image
Crop |
| Ctrl+D/R/L |
Copy
text from Above/Right/Left |
| Ctrl+H |
Find
& Replace |
| Ctrl+F |
Find |
| Ctrl+W |
Close
Excel |
| Ctrl+ / - |
Insert/Delete |
| Ctrl+A |
Selection |
| Alt += |
Sum |
| Ctrl+Scroll |
Zoom
out / in |
| Alt +Enter |
Wrap
Text |
| F4 / fn + F4 |
Auto
Repeat |
| ALT |
Shortcuts |
| Print Screen |
Screen
Shot |
| Ctrl+P |
Print |
|
|
|
OTHER TOPICS
|
|
WHO CAN ATTEND THE COURSE :
Students , Professionals : Executives, Team or Personal Assistants,
Administrators, Coordinators, Office Managers, Finance Managers and
others in corporate operational roles. Research has shown that the role
of the Executive Assistant has evolved considerably in recent years.
Support staffs are often expected to initiate their own report writing and
even perform some level of financial analysis.
This specialized course is not a general Excel training course; rather it
teaches the use of Advance Excel with Analytical Skills in a Reporting context.
Contact @ email ID: exceltoexcel24@gmail.com
|
|
******************************************************************
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
