. Apart from this, there is also facility to add comments by other users if desired as per permission. Data analysis tools Microsoft Excel has a variety of tools for data analysis such as data tables, solvers and data validation. It also has features like what-if analysis and sensitivity analysis, which will help you a lot in reviewing different scenarios while analyzing data.
Microsoft Excel Course What you
will learn from this course Complete complex tasks quickly by learning basic to advanced functions, formulas, and tricks in Microsoft Excel. From basic data entry to advanced calculation to data analysis View the full course Microsoft Excel thailand email list Shortcuts List Microsoft Excel has a large number of shortcut facilities. Using which you can do a lot of work in a very short time and as a result your productivity will increase manifold! Let’s see what are the shortcuts for Microsoft Excel.
Each shortcut will help you perform tasks quickly and easily
, which will improve the process of creating and editing your workbook. Microsoft Excel Formulas List Microsoft Excel has a large number of formula facilities. Using which you can
do a lot of data calculations, management etc. in a very short time and as a result your productivity will increase manifold! Let’s see what are the shortcuts for Microsoft Excel. Math and Trigonometry Formulas formula Example name description
05, 10, 2000) current price
Calculate the present value over a period of time FV, future value Determine the future value after a specified period of time RATE =RATE(10, -200, 1000) rate Determine the rate for a how to write an effective title specific period Database (Database Formulas) formula example name description INDEX =INDEX(A1 , 5) index Displaying a value from a cell range match Find the location of a cell SUMIFS Find the sum of the cell range according to the condition Microsoft PowerPoint Microsoft PowerPoint is a presentation creation software used to create slide shows.
It was first published in 1987
and has since become an essential tool for students, professionals, and business people. PowerPoint helps you create attractive presentations by adding text, images, videos, transitions and animations. Microsoft PowerPoint Course What you will learn by doing the course: Confidently deliver presen fans data tations in school-college, university, and corporate life by creating attractive slides. Great hacks with 3D Model, Graphics and Animation in PowerPoint.
We can divide these tasks into the following categories:
Slide creation and formatting Text and images Animations and transitions Video and Audio Slide show and presenter view sharing Presentation templates and themes Now, let’s know about them in detail. Creating and formatting slides With Microsoft PowerPoint, you can create different types of slides very easily. With it you can add text, images, animations and other media to your slides. It has options to customize slide layout,