1 / 18

Presenter Sanjeewa Wijayathilaka MIIE(SL), ACIArb Commercial Manager ( wasl LLC)

Institution of Incorporated Engineers Sri Lanka UAE Branch. Continuing Professional Development Event - 01/2011. Topic. Microsoft Excel for Construction and Engineering Professionals to excel. Presenter Sanjeewa Wijayathilaka MIIE(SL), ACIArb Commercial Manager ( wasl LLC).

ulric
Download Presentation

Presenter Sanjeewa Wijayathilaka MIIE(SL), ACIArb Commercial Manager ( wasl LLC)

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. Institution of Incorporated Engineers Sri Lanka UAE Branch Continuing Professional Development Event - 01/2011 Topic Microsoft Excel for Construction and Engineering Professionals to excel Presenter Sanjeewa Wijayathilaka MIIE(SL), ACIArb Commercial Manager (wasl LLC) Wednesday, 27th April at Hilalco Conference Hall, Abu Dhabi Professionalism Beyond Boundaries www.Iiesluae.org

  2. Institution of Incorporated Engineers Sri Lanka UAE Branch Objectives • Be consistent in presenting reports using Custom Views • Find useful information using Advanced Filters • Speedy routine calculations using Macros • Present information using Charts • Save time using Shortcut keys Professionalism Beyond Boundaries www.iiesluae.org

  3. Institution of Incorporated Engineers Sri Lanka UAE Branch Session Outline 01. Navigating/cruising in workbook 02. Time & Date Functions 03. Cell Formatting 04. Logical & Mathematical Functions 05. Statistical Functions 06. Text Functions 07. Lookup Functions 08. Manipulating Worksheets 09. Paste Special Options 10. Pivot Tables 11. Charts - Gantt Chart Creation 12. Hyperlinks 13. Linking & Embedding 14. Sorting and Filtering Data 15. Tracking and Reviewing Changes 16. Data Validating 17. Auditing 18. Macros 19. Passwords & Security Issues 20. Shortcut Keys Professionalism Beyond Boundaries www.Iiesluae.org

  4. Institution of Incorporated Engineers Sri Lanka UAE Branch Special Characters – Key Strokes • M² - ALT 0178 • M³ - ALT 0179 • 90° - ALT 0176 • Ø – ALT 0216 • One Quarter - ¼ - ALT 0188 • Half - ½ - ALT 0189 • Three Quarters - ¾ - ? Where are these special characters available ? Professionalism Beyond Boundaries www.Iiesluae.org

  5. Institution of Incorporated Engineers Sri Lanka UAE Branch Shortcut Keys (Combinations) • Copy to the Right Ctrl+R • Copy to Down Ctrl+D • To view formulas Ctrl+~ • Sum up rows above Alt += • Minimize a window WINKEY+M or ALT+SPACE+n • Maximize a window ALT+SPACE+x • Enter data to a range of cells Ctrl + Enter • Select current Column / Row entirely Ctrl+Space Bar • Shift+Space Bar • Go to top of the spreadsheet/ Bottom of spreadsheet • Ctrl+Home, Ctrl+End • Calculate all worksheet/ Active worksheet F9, Shift F9 • Quick format : Finance with 2 decimal points(with comma) Ctrl+Shift+1(to 7) • Cell format : Bold/Italic/Underline Ctrl+B/I/U • Access Cell Format Ctrl+1 • Insert Comments Shift+F2 • Insert Functions Shift+F3 • Print Ctrl+P • Select All Ctrl+A • Undo Ctrl+Z • Repeat Ctrl+Y / F4 www.Iiesluae.org

  6. Institution of Incorporated Engineers Sri Lanka UAE Branch Some useful references • http://office.microsoft.com/en-us/excel-help/ • http://www.youtube.com/results?search_query=excel&aq=f • http://people.highline.edu/mgirvin/ExcelIsFun.htm Professionalism Beyond Boundaries www.Iiesluae.org

  7. 1. NAVIGATING/CRUISING IN WORKBOOK

  8. 2. TIME & DATE FUNCTIONS

  9. 3. CELL FORMATTING

  10. 4. LOGICAL & MATHEMATICAL FUNCTIONS5. STATISTICAL FUNCTIONS

  11. 6. TEXT FUNCTIONS

  12. CONTRACTOR 1 7. LOOKUP FUNCTIONS 8. MANIPULATING WORKSHEETS & 9. PASTE SPECIAL OPTIONS CONTRACTOR 2 CONTRACTOR 3 ACCOUNT BALANCE SUMMARY

  13. 10. PIVOT TABLES SUMMARY CHART 1

  14. 11. CHARTS - GANTT CHART CREATION SIMPLE CHART GANTT CHART

  15. CONTRACTOR 1 12. HYPERLINKS CONTRACTOR 2 CONTRACTOR 3 ACCOUNT BALANCE SUMMARY

  16. 15. TRACKING & REVIEWING CHANGES & 16. DATA VALIDATING

  17. 17. AUDITING

  18. 18. MACROS 19. PASSWORDS & SECURITY ISSUES

More Related