MS -Excel 2007

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

WELCOME TO MS – EXCEL 2007:

WELCOME TO MS – EXCEL 2007 Made By :- Abhishek Thakur Next

PowerPoint Presentation:

INDEX Introduction Basics of Excel Components Pane in Excel Excel Formulas Shortcut Keys in Excel Next

PowerPoint Presentation:

INTRODUCTION EXCEL is to be very good at doing something. EXCEL is to do extremely well and even better than w e usually do. EXCEL have 16384 column & 1048576 rows. When Excel is opened :- Home pane is at the front. Book1 is default name of workbook & consist of 3 sheets by default. Sheet1 is active by default. Cell A1is active by default. Back

PowerPoint Presentation:

BASICS OF EXCEL OPENING FROM DESKTOP Start All Program Microsoft Office Microsoft Office Excel 2007 SAVING Office Button Save Choose Destination Save Next

PowerPoint Presentation:

OPENING IN MS - EXCEL Office Button New PRINTING IN MS - EXCEL Office Button Print OK CLOSING OF MS – EXCEL Office Button Close Back

PowerPoint Presentation:

COMPONENTS Microsoft Office Button Quick Access Toolbar Title Bar Tab Bar Name Box Formula Bar Dialogue Box Launcher Row Heading Column Heading Active Cell Active Sheet Sheet Tabs Status Bar Zoom Level Slider Back

PowerPoint Presentation:

PANE IN EXCEL Office Button Home Pane Insert Pane Page Layout Pane Formula Pane Data Pane Review Pane View Pane Back

PowerPoint Presentation:

OFFICE BUTTON New :- Opens new workbook Open :- Open saved workbook Save :- Save active workbook Save As :- Excel workbook :- Excel Macro Enable workbook :- Excel Binary workbook :- Excel 1997 – 2003 workbook :- Other Format Print :- Print :- Quick Print :- Print Preview Send :- E – mail :- Internet Fax Prepare :- Properties :- Inspect Document :- Encrypt Document :- Restrict Permission :- Add a Digital Signature :- Mark as Final :- Run Compatibility Publish :- Excel Service :- Document Manager Server :- Create Document Workspace Close Excel Option Exit Excel Back

PowerPoint Presentation:

HOME PANE Clipboard :- Paste :- Cut :- Copy :- Format Painter Number :- Number Format :- Accounting Number Format :- Percent Style :- Comma :- Increase Decimal :- Decrease Decimal Font :- Font Face :- Font Size :- Bold :- Italic :- Underline :- Increase Font Size :- Decrease Font Size :- Border :- Fill Color :- Font Color Next

PowerPoint Presentation:

Alignment :- Top Align :- Middle Align :- Bottom Align :- Left Align :- Center Align :- Right Align :- Decrease Indent :- Increase Indent :- Orientation :- Wrap Text :- Merge & Center Style :- Conditional Formatting :- Format As Table :- Cell Styles Cells :- Insert Cells :- Delete Cells :- Format Cells Editing :- Auto Sum :- Auto Fill : - Auto Clear :- Sort & Filter :- Find & Select HOME PANE Back

PowerPoint Presentation:

INSERT PANE Table :- Pivot Table :- Table Illustration :- Picture :- Clip Art :- Shapes :- Smart Art Text :- Text Box :- Header & Footer :- Word Art :- Signature Line :- Object :- Symbol Chart :- Column Chart :- Line Chart :- Pie Chart :- Bar Chart :- Area Chart :- Scatter Chart :- Stock Chart :- Surface Chart :- Doughnut Chart :- Bubble Chart :- Radar Chart Links :- Hyperlinks Back

PowerPoint Presentation:

Scales to Fit :- Width :- Height :- Scale Sheet Options :- Gridlines Headings :- Headings Arrange :- Bring to Front :- Send to Back :- Selection Pane :- Align :- Group :- Rotate PAGE LAYOUT PANE Themes :- Themes :- Theme Color :- Theme Font :- Theme Effect Page Setup :- Margins :- Page Orientation :- Page Size :- Print Area :- Breaks :- Background :- Print Titles Back

PowerPoint Presentation:

FORMULAS PANE Function Library :- Auto Sum :- Recently Used :- Financial :- Logical :- Text :- Date & Time :- Lookup & References :- Math & Trig :- Statistical :- Engineering :- Cube :- Information Defined Names :- Name Manager :- Define Name :- Use in Formula :- Create from Selection Formula Auditing :- Trace Precedents :- Trace Dependents :- Remove Arrows :- Show Formulas :- Error Checking :- Evaluate Formula :- Watch Window Calculation :- Calculation Option :- Calculate Now :- Calculate Sheet Back

PowerPoint Presentation:

Data Tools :- Text to Column :- Rename Duplicates :- Data Validation :- Consolidate :- What – if Analysis Sort & Filter :- Sort A to Z :- Sort Z to A :- Sort :- Filter :- Clear :- Reapply :- Advanced DATA PANE External Data :- From Access :- From Web :- From Text :- From SQL Server :- From Analysis Server :- From XML Data Import :- From Data Connection :- From Microsoft Query :- Existing Connections Connections :- Refresh All :- Connections :- Properties :- Edit Links Back

PowerPoint Presentation:

REVIEW PANE Proofing :- Spelling :- Research :- Thesaurus :- Translate Changes :- Protect Sheet :- Protect Workbook :- Share Workbook :- Allow Users to Edit Ranges Comments :- New Comment :- Delete :- Previous :- Next :- Show/Hide Comment :- Show all Comment :- Show Ink Back

PowerPoint Presentation:

Zoom :- Zoom :- 100% Zoom :- Zoom to Selection Windows :- New Window :- Arrange All :- Freeze Pane :- View Side By Side :- Synchronous Scrolling :- Reset Window Position :- Split :- Hide :- Unhide VIEW PANE Workbook View :- Normal :- Page Layout :- Page Break :- Preview :- Custom View :- Full Screen Show/Hide :- Ruler :- Gridlines :- Message Bar :- Formula Bar :- Headings Macros :- Macros Back

PowerPoint Presentation:

EXCEL FORMULAS Financial Date & Time Math & Trig Statistical Lookup & References Database Text Logical Information Engineering Cube Back

PowerPoint Presentation:

FINANCIAL RECEIVED SLN SYD TBILLEQ TBILLYIELD VDB XIRR XNPV YIELD YIELDDISK YIELDMAT DOLLARDE DOLLARER DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NVP ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE ACCRINT ACCRINTM AMORDFGRC AMORLINC COUPDAYBS COUPDAYS COUPNCP COUPNUM COPPCD CUMPRINC DB DISC Back

PowerPoint Presentation:

DATE & TIME DATE DATEVALUE DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORK DAYS NOW SECOND TIME TIME VALUE TODAY WEEK DAYS WEEK NUM WORKDAY YEAR YESRFRAC Back

PowerPoint Presentation:

MATHS & TRIGS ABS ACOS ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMFS SUMPRODUCT SUMSQ SUMX2MY2 TAN TANH TRUNC FACT FACTDOUBLE FLOOR GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QOUTIENT RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDVP SERIESSUM SIGN Back

PowerPoint Presentation:

STATISTICAL AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETADIST BENOMDIST CHIDIST CHINV CHITEST CONFIDENCE CORREL COUNT COUNTA COUNTBLANK COUNTIF NORDIST PEARSON PERCENTILE PERCENTRANK PERMUT POISSON PROB QUARTILE RANK RSQSKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP COUNTIFS COVAR CRITBINOM DEVSQ EXPONDIST FDIST FINV FISHER FISHERINV FORECAST FREQUENCY FTEST GAMMADIST GAMMAINV GAMMALN GROWTH HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST STDEVPA STEYX TDIST TINV TREND TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST Back

PowerPoint Presentation:

LOOKUP & REFERENCES ADDRESS AREAS CHOOSE COLUMN GITRIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS RTD TRANSEPOSE VLOOKUP Back

PowerPoint Presentation:

DATABASE DAVERAGE DCOUNT DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DNARP Back

PowerPoint Presentation:

TEXT BAHTTEXT CHAR CLEAN CODE CONTENATE DOLLAR EXACT FIND FIXED LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SEARCH SUBSTITUTE T TEXT TRIM UPPER VALUE Back

PowerPoint Presentation:

LOGICAL AND FALSE IF IFERROR NOT OR TRUE Back

PowerPoint Presentation:

INFORMATION CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEX N NA TYPE Back

PowerPoint Presentation:

ENGINEERING BESSELI BESSELJ BESSELK BESSELV BIN2DEC BIN2HEX BIN2OCT DELTA ERF ERFC GESTEP HEX2BIN HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2HEX Back

PowerPoint Presentation:

CUBE CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE Back

PowerPoint Presentation:

SHORTCUT KEYS IN EXCEL Alt + = Alt + Click Alt + F2 Alt + F4 Alt + F8 Alt + F11 Ctrl + A Ctrl + B Ctrl + C Ctrl + D Auto sum Research Save As Close Excel View Macros MS – Visual Basics Select All Bold Copy Delete Ctrl + F Ctrl + G Ctrl + H Ctrl + I Ctrl + K Ctrl + L Ctrl + N Ctrl + O Ctrl + P Ctrl + R Find Go to Replace Italic Hyperlink Insert Table New Workbook Open Print Remove Next

PowerPoint Presentation:

Ctrl + S Ctrl + T Ctrl + U Ctrl + V Ctrl + W Ctrl + X Ctrl + Y Ctrl + Z Ctrl + 0 Ctrl + 1 Ctrl + 2 Ctrl + 3 Ctrl + 4 Save Insert Table Underline Paste Exit Excel Cut Repeat Undo Hide Column Format Cell Bold Italic Underline Ctrl + 9 Ctrl + ‘ Ctrl + ; Ctrl + + Ctrl + - Ctrl + Arrow Ctrl + F2 Ctrl + F3 Ctrl + Alt + L Ctrl + Alt + F5 Ctrl + Alt + Tab Ctrl + Alt + Shift + Tab Ctrl + Insert Hide Row Show fx Short Date Insert Delete Last Cell Print Preview Name Manager Reapply Refresh All Increase Indent Decrease Indent Copy Next

PowerPoint Presentation:

Ctrl + Home Ctrl + Page Up Ctrl + Shift + F Ctrl + Shift + U Ctrl + Shift + L Ctrl + Shift + P Ctrl + Shift + 7 Ctrl + Shift + ‘ Ctrl + Shift + ; Ctrl + Shift + - Ctrl + Shift + % Ctrl + Shift + F3 Ctrl + Shift + Tab + 3 Ctrl + Shift + Tab + 4 Cell A1 Delete Text Format Cell Expand fx Bar Filter Format Cell Border Edit Cell Time Remove Border Percent Style Create From Selection Custom Cell Currency Next

PowerPoint Presentation:

Ctrl + Shift + Tab + 5 Ctrl + Shift + Tab + 6 Ctrl + Shift + Tab + 7 F1 F2 F5 F7 F9 F12 Shift + Alt + Left Shift + Alt + Right Shift + F2 Shift + F3 Percentage Scientific Border Help Edit Cell Go to Spelling Calculate Now Save As Group Ungroup Insert Comment Insert Function Shift + F4 Shift + F5 Shift + F6 Shift + F7 Shift + F9 Shift + F11 Shift + F12 Left Right Find, Replace Open Pane Research Calc. Sheet Insert Sheet Cell A1 Back

PowerPoint Presentation:

Thank You Thank You Thank You