- Formatting in Excel
- Text functions
- Mathematical functions Part-1
- Vlookup function
- Data Sorting and Filtering
Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc
A Excel spreadsheet can be understood as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.
As We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
This course brings intermediate level learning in Microsoft level. This course will help you to start using at intermediate level.
The course includes the use of basic level commands like formatting functions available in home tab to the use of lookup functions. The course starts with the use of formatting commands. It is followed by the use of text functions which is very important tools in the excel for manipulation of the data. In the third section, most of the mathematical functions are covered. Some of the mathematical functions are explained with if and ifs conditions. All the commands explained in this course along with the demonstration.
The aspirants of this course will definitely get hands on the excel commands. The course would definitely be helpful for the engineers or any graduate to work with the data manipulated in the excel.
Learn The Secrets of Web Design and How Professional Designers Create Elegant Websites and Mobile Apps.
My educational qualification is M.E. Manufacturing and Automation. I am working an Assistant Professor in an Engineering Institute in Nashik. I have run the Excel for Engineers for the engineering students two times successfully. My interest is to learn the machine and programming languages and prepare the codes for complex mathematical problems. I am basically in the field of Production Engineering. But in addition with that I am also a tutor of C, C ++ and python language.