Jump to content
Engineering Talks

About This Club

Microsoft Excel for engineers

Category

Software & Apps

Description

Fee Course on
*Excel for Engineers*
We are forming a community to enhance our spreadsheet skills In next couple of months, I'll be sharing tutorials and exercises in this club so whether f you want to learn from beginning or the advanced concepts.... join the club

We are starting soon...

  1. What's new in this club
  2. Version 1.0.0

    35 downloads

    Tutorial 4 Match & Lookup example
  3. In this tutorial, we will learning the use of VLookup HLookup Match Index another video just to go more deeper in VLOOKUP https://www.youtube.com/watch?v=kFjhTKjBhZM
  4. I learnt something new in tutorial 1. How to get the total value.. I use to do it this way Eg. =Sum(B3:B15) Which also works Thank you very much.
  5. Thank you very much for all the good work, am from Nigeria, can you please send a copy to me via email at (suleiliya@gmail.com) like PDF or word document.
  6. Dear members, First three videos tutorials have been released This will give you the very basic about Excel.... Please visit Excel tutorials https://engineeringtalks.com/blogs/blog/49-excel-tutorials/ happy learning }
  7. In this tutorial we will learn to write basic formulas and introduction to cell referencing Relative referencing which is the default referencing Absolute referencing Mixed Referencing Important points 4 type of referencing can be cycle through f4 key - when we are in edit mode of cell - (use f2 to enter into edit mode) - A1 , $a$1 , A$1, $A1 Shortcut Ctrl + ~ (tilde which is just above 1 in windows) pl download file
  8. Version 1.0.0

    45 downloads

    Tutorial 3 - Cell referencing
  9. Where we can use Excel Lets look into various elements of Excel & Ribbon Important shortcuts Ctrl +F1 Page Up Page down with Alt and without Alt Right arrow (Tab) Left Arrow ( Shift + tab)
  10. hello every one, Today we are starting with our first tutorial, I just thought to start with creating our first workbook. Please see the video and then do it once on your own.. I am also attaching file for reference
  11. I use excel in monitoring and forecasting when resources will finish and how much will be needed to sustain machines availability every month. i also use excel for inventory purposes and maintenance planning
  12. Good morning. I mainly use for data interpretation by plotting graphs. But would like to see its applications in depth for Machine Design and other related areas of Mechanical Engineering.
  13. There is no Preliminary Exercise 1 in Microsoft Excel for Engineers with the link provided.
  14. I am a Engineering Professor (Mechanical and Civil) and use Excel to improve my classes - I'm interested in creating calculus sheet for Resistence of Materials and Hydraulics & Pneumatics cases.
  15. Used the columns to enter the scores achieved. Then denoted a specific position for the weighted percentage. This was then multiplied by the students totals.
  16. Expect to start within five days.... We are waiting for more participants.. to give it a pace....
  17. Good afternoon Saurabh, I would like to know the scheduled commencement of the course.
  18.  

×
×
  • Create New...