Advance Excel

The View tab in MS Excel provides various options for customizing the way your worksheet is displayed on the screen. Here are the options available in the View tab:   1. Workbook Views: This option allows you to switch between different workbook views, such as Normal, Page Layout, and Page Break Preview. 2. Show: This […]

The Page Layout group in Excel contains various options to control the appearance and layout of your worksheet when printed. Here are the options available in the Page Layout group:   1. Themes: This option allows you to apply a theme to your worksheet, which changes the color scheme, font style, and effects. 2. Page

The Insert tab group in Microsoft Excel contains various options to insert different types of objects and elements into a worksheet. Here are the options available in the Insert tab group:   1. Tables: This option allows you to insert a table into the worksheet, where you can store and organize data. 2. Illustrations: This

The “Home” tab is one of the primary tabs in Microsoft Excel that provides access to some of the most commonly used features and functions. Here are some of the groups and options available in the “Home” tab:   1. Clipboard group: The Clipboard group provides options for cutting, copying, and pasting cells or text. 2.

The File tab in Microsoft Excel provides access to various options for managing Excel files, including opening, saving, printing, and sharing files. Here are some of the most commonly used features of the File tab. 1. New: Create a new Excel workbook. 2. Open: Open an existing Excel workbook. 3. Save: Save the current Excel workbook.