1 / 24

Workshop on Excel

Join Dr. P. Sravan Kumar, MBA, PhD, HoD at B.I.T. Institute of Technology Hindupur, for a workshop on Microsoft Excel. Explore the fundamental and advanced features of Excel, including creating, editing, and analyzing data, using formulas and macros, working with pivot tables, and more. Enhance your Excel skills and become proficient in data analysis and reporting. Don't miss this opportunity to excel in Excel!

kellygonzales
Download Presentation

Workshop on Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Workshop on Excel Dr P Sravan Kumar MBA PhD HoD, B.I.T. Institute of Technology Hindupur www.drpsravan.wordpress.com

  2. Excel Journey • Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.  • It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications • It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993 • It has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

  3. Versions • Can you say smart phone OS • Can you say Your cell phone OS version • Yes Excel versions • Microsoft released the first version of Excel for the Macintosh on September 30, 1985 • First Windows version was 2.05 in November 1987

  4. Versions • Excel 2.0 - 1987 • Excel 3.0 – 1990 • toolbars, drawing capabilities, outlining, add-in support, 3D charts Etc. • Excel 4.0 - 1992 • Auto fill option

  5. Versions • Excel 5.0 – 1993 • Introduced VBA macros but is fails due to virus attack • Excel 95 - V 7.0- 1995 • It supports 32 bit OS • Excel 97 - v8.0 • Excel 2000 - v9.0 • Excel 2002- v10.0 • Excel 2003 - v11.0 (most popular )

  6. Versions • Excel 2007 - v12.0 • Excel in 2007 used the new ribbon menu system. This was different from what users were used to, and was met with mixed reactions. • Excel 2010 - v14.0 • Excel 2013 – v15.0 • Excel 2016 – v16.0

  7. Glance of Versions

  8. Extension formats 2007

  9. Before 2007 Excel formats

  10. Spread Sheet • Excel is spread sheet • Consist of row • Generally it is in 1 2 3 • Column • Genarally it is A B C

  11. Fundamental of excel • Cell • Combination of row and column is cell it represent the address as well • Ex A1 here A-column and 1 row • Ex CZ343 Column____ and Row ____ • Ex RX100 Column____ and Row ____

  12. Cell address • Column and Row both combination cell

  13. Formula bar

  14. Ribbons • Shortcut key press alt then select the letter(s) • Please try now

  15. Using Short Cut keys • Save Time • Save Energy • Leading the team in corporate • Many more ………

  16. BASIC Microsoft Excel • Spreadsheet basics • Creating, editing, saving and printing spreadsheets • Working with functions & formulae • Graphically representing data : Charts & Graphs • Analyzing data : Data Menu, Subtotal, Filtering Data • Working with functions & formulae Formatting worksheets , Securing & Protecting spreadsheets

  17. ADVANCED Excel • Formulas & Macros Formulas: • Use the Function Wizard, Common functions • (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT) • Nested functions , Name cells /ranges /constants • Relative, Absolute, Mixed cell references : >,<,= operators • Logical functions using IF, AND, OR, NOT • The LOOKUP function , Date and time functions , Annotating formulas

  18. ADVANCED Excel • DATA Analysis : • Sub Total Reports, Auto Filter • Password Protecting Worksheets • Linking Multiple Sheets • Sheet Referencing • Linking Between Word/Excel/Ppt

  19. ADVANCED Excel • Functions : LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF • What-if-analysis • GOAL SEEK • NESTED IF • Reporting • Character Functions • Date Functions • Age Calculations • Consolidation of Data • Data Validation

  20. ADVANCED Excel • PIVOT TABLES : • Enter the Pivot Table Data • Create the Pivot Table • Adding Data to the Pivot Table • Filtering the Pivot Table Data • Change the Pivot Table Data • Analyze Data Columns in Pivot Tables • Adjust Data to Analyze

  21. ADVANCED Excel • MACRO’S ( Int ) : • Macros • Definition and use, Record a macro • Assign a macro, Run a macro • Store a macro, Introduction to VBA Prog.

  22. ADVANCED Excel • Develop the Worksheet : • Plan a worksheet , Row and Column labels • Split worksheet /box /bar, Copy data and formulas • Display /move toolbars , Enhance worksheet Appearance

  23. ADVANCED Excel • Special Operations : • Use multiple windows : Copy/ paste between Worksheets • Link worksheets , Consolidate worksheets • Import and link from other Applications • Use AutoFormat : Create, use and modify styles and templates • Print features : Create /edit an outline • Graphic Operations: • Create charts , Enhance charts, Drawing toolbar features

  24. What is expected from me? • Project Analysis related Excel • Fundamental of excel • Advanced Excel (few tools Depending on Time)

More Related