Excel Features - Browser Plugins : Every Tester must know

Course details

This course is designed by focusing Software Testing daily stuffs and activities.

Here in this course, we cover all important excel features like Sorting, Filter etc which will be needed by each and every tester while doing daily testing stuffs.

Plugin section cover all important plugins which require to perform testing on different environment, devices etc.

Here we focus on following important excel features,

1. Hyperlink. We can link one file to another file or page.
2. Clip art. We can add images and also audio and video clips.
3. Charts. With charts, we can clearly show a product(s) evaluation to a client. For example, you can display a chart showing which product is selling more or less by month, week, and so forth.
4. Tables. Tables are created with different fields (e.g. name, age, address, roll number, and so forth). You can add a table to fill these values.
5. Functions. There are both mathematical functions (add, subtract, divide, multiply), and logical ones (average, sum, mod, product).
6. Images and backgrounds. You can incorporate images and backgrounds into each sheet.
7. Macros. Macros are used for recording events for future use.
8. Database: With the data feature, you can add any database from other sources to it.
9. Sorting and filtering. We can sort and/or filter our data so that anything redundant or repetitive can be removed more easily.
10. Data validations. This tool can help you consolidate your data. 
11. Grouping. The grouping feature helps you both to group your data and ungroup it so that you have subtotals and so forth.
12. Page layout. Themes, colors, sheets, margins, size, backgrounds, breaks, print, titles, sheets height, width, scaling, grids, headings, views, bring to front of font or back alignment, and many more are available for you to lay out your page.