Above 30 Formulas & Functions in Ms-Excel

In this video we can discuss about 30 Above Excel Formulas in Excel. 1.  Mathematical Functions 2.  Statistical Functions 3.  Date & Time Functions 4.  Text Functions 5.  Count Functions 6.  Logical functions 

In this video we can discuss about Above 10 Mathematical Problems in Excel. 1. Student Marks Table 2. Working of Employee Table 3. Using Power Station 4. Discount Table 5. Financial Table  6. Using Cinema Theaters tickets 7. Traveling Agency 8. Partner Ship 9. Stock Items 10.Employee Payroll Table 11.Student Grade,Result Tables (IF Formula) 

In this video we can discuss about How to use Object Option in Excel. Object:- You can insert objects into a Microsoft Excel Sheet when you want to include information from files created in other Microsoft Office programs or in any program that supports linked objects and embedded objects.

In this video we can discuss about Scale to Fit option in Excel. Scale to fit:- You can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages.  You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages
Complete Reading

In this video we can discuss about Page Setup & Printing Option’s in our Excel Sheet. Many of the commands you’ll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including
Complete Reading

In this video we can discuss about How to use Macros in Excel Sheet. Macros are code that automate work in a program. They let you add your own tiny features and enhancements to help you accomplish exactly what you need to do, quickly with just a click of a button. In a spreadsheet tool
Complete Reading

In this video we can discuss about Show & Zoom Options in Excel Show & Zoom Groups:- Show Group on the Hide & Unhide the Grid lines, Formula bar, Heading’s Options The Zoom group on the View tab allows you to increase or decrease the size of the view of your document. It just simply
Complete Reading

In this video we can discuss about How to use Freeze Panes Options in Excel Freeze Panes:- If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

In this video we can discuss about How to Group & Ungroup the Rows & Columns.How to use the Sub Total option Excel Sheet.Group:-Select a set of rows or columns that you wish to group together.Click on the Data tab  in the Ribbon.Click on the Group button in the Outline Group.Click on Group option Hide
Complete Reading

  In this video we can discuss about How to use Pivot Table in Excel   Pivot table:- You might think of a pivot table as a user created summary table of your original spreadsheet.  You create the table by defining which fields to view and how the information should be displayed. Based on your
Complete Reading

Create Account



Log In Your Account