MS Advance Excel Course

The Review tab in Microsoft Excel provides a range of tools and features for reviewing, proofreading, and protecting data in spreadsheets. Some of the key features of the Review tab include:   1. Spelling & Grammar: This feature allows you to check the spelling and grammar of the text in your worksheet. 2. Thesaurus: This feature allows you to find synonyms for words in your worksheet. 3. Translate: This feature allows you to translate text in your worksheet into different languages. 4. Comments: This feature allows you to add comments to cells in your worksheet to provide context or additional information. 5. Track Changes: This feature allows you to track changes made to the data in your worksheet and accept or reject those changes. 6. Protect Workbook: This feature allows you to protect your workbook by setting a password to prevent unauthorized access or changes. 7. Protect Sheet: This feature allows you to protect specific sheets in your workbook by setting a password or restricting certain actions, such as editing cells or formatting. Overall, the Review tab in Excel is a useful set of tools for proofreading, reviewing, and protecting data in your spreadsheet. Whether you’re collaborating with others or working on sensitive data, these features can help ensure the accuracy and security of your work.

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 option allows you to show or hide various elements in your worksheet, such as gridlines, headings, and formulas. 3. Zoom: This option allows you to adjust the zoom level for your worksheet. 4. Window: This option allows you to control how multiple workbooks are displayed on your screen, such as arranging them side-by-side or cascading them. 5. Macros: This option allows you to record, run, and edit macros in your worksheet. 6. View Options: This option allows you to customize the way your worksheet is displayed, such as by showing or hiding the ruler, formula bar, and status bar. 7. Freeze Panes: This option allows you to freeze rows or columns in your worksheet so that they remain visible as you scroll through the rest of the data. 8. Arrange All: This option allows you to arrange all open workbooks on your screen in various ways, such as by tiling them horizontally or vertically. 9. New Window: This option allows you to open a new window for your current workbook, which can be useful for comparing or referencing different parts of the data.

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 Setup: This option allows you to customize the page settings for your worksheet, such as orientation, paper size, margins, and print area. 3. Scale to Fit: This option allows you to adjust the scaling of your worksheet to fit on a specific number of pages or to a specific percentage. 4. Sheet Options: This option allows you to control the visibility of gridlines, headings, and other elements in your worksheet. 5. Arrange: This option allows you to arrange and align objects in your worksheet, such as pictures, shapes, and text boxes.   1. Page Setup: The Page Setup group in the Layout tab of Excel contains various options to customize the page settings for your worksheet, such as orientation, paper size, margins, and print area. Here are the options available in the Page Setup group: 1. Margins: This option allows you to set the margins for your worksheet, such as top, bottom, left, and right margins. 2. Orientation: This option allows you to set the page orientation to either portrait or landscape. 3. Size: This option allows you to select the paper size for your worksheet, such as letter, legal, A4, etc. 4. Print Area: This option allows you to specify the range of cells that you want to print on the page. 5. Breaks: This option allows you to insert or remove page breaks in your worksheet to control the page layout when printed. 6. Background: This option allows you to add a background color or image to your worksheet. 7. Print Titles: This option allows you to specify rows or columns to repeat on each printed page.   2. Sheet Options The Sheet Options group in the Layout tab of Excel allows you to control the visibility of various elements in your worksheet. Here are the options available in the Sheet Options group: 1. Gridlines: This option allows you to show or hide gridlines on your worksheet. 2. Headings: This option allows you to show or hide row and column headings on your worksheet. 3. Show/Hide: This option allows you to show or hide specific elements in your worksheet, such as comments, chart data, and objects.

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 option allows you to insert various types of illustrations, such as pictures, shapes, icons, and 3D models. 3. Add-ins: This option allows you to insert add-ins into the worksheet, which are small programs that add new features or functionalities to Excel. 4. Charts: This option allows you to insert different types of charts, such as column, line, pie, bar, and area charts, to visualize data. 5. Sparklines: This option allows you to insert sparklines, which are small charts that fit into a cell and show trends and patterns in data. 6. Filters: This option allows you to insert filters into a table, which can help you sort, filter, and analyze data quickly. 7. Hyperlinks: This option allows you to insert hyperlinks into the worksheet, which can link to web pages, email addresses, or other documents. 8. Text: This option allows you to insert different types of text boxes, headers, and footers into the worksheet, which can add context and information to the data. 9. Symbols: This option allows you to insert symbols and special characters into the worksheet, such as copyright symbols, currency symbols, and mathematical operators.   1 Tables Group The Tables group in the Insert tab of Microsoft Excel contains various options to create and format tables in your worksheet. Here are the options available in the Tables group: 1. Table: This option allows you to create a table from selected cells in the worksheet. When you create a table, Excel automatically applies formatting and styles to the data, and you can easily sort, filter, and analyze the data. 2. Recommended Pivot Table: This option allows you to create a chart based on the data in your table. Excel provides several recommended chart types based on the data and the purpose of the chart, and you can customize the chart as per your needs. 3. PivotTable: This option allows you to create a PivotTable from the data in your table. A PivotTable is a powerful tool that allows you to summarize, analyze, and explore large amounts of data from different perspectives.   2 Illustrations Group The Illustrations group in the Insert tab of Microsoft Excel contains various options to add and format different types of illustrations in your worksheet. Here are the options available in the Illustrations group: 1. Pictures: This option allows you to insert a picture from your computer or an online source into the worksheet. You can also format the picture by adjusting its size, shape, border, and effects. 2. Online Pictures: This option allows you to search for and insert pictures from online sources, such as Bing, Facebook, or OneDrive. You can also filter the search results by type, size, color, and license. 3. Shapes: This option allows you to insert various types of shapes, such as rectangles, circles, arrows, and stars, into the worksheet. You can also format the shape by adjusting its size, color, border, and effects. 4. SmartArt: This option allows you to insert SmartArt graphics into the worksheet. SmartArt is a collection of predefined diagrams and flowcharts that can be customized by adding or removing shapes, text, and colors. 5. Screenshot: This option allows you to capture and insert a screenshot of a selected area or window into the worksheet. You can also crop, resize, and format the screenshot.   3 Charts Group The Charts group in the Insert tab of Microsoft Excel contains various options to create and format different types of charts in your worksheet. Here are the options available in the Charts group: 1. Column: This option allows you to create a column chart that shows the comparison of values across categories. 2. Line: This option allows you to create a line chart that shows the trend of values over time. 3. Pie: This option allows you to create a pie chart that shows the proportion of each value to the total. 4. Bar: This option allows you to create a bar chart that shows the comparison of values across categories. 5. PivotChart: This option allows you to create a chart based on a PivotTable. A PivotChart is a chart that is linked to a PivotTable and updates automatically as the PivotTable data changes. 6. Recommended Charts: This option allows you to create a chart based on the data in your worksheet. Excel provides several recommended chart types based on the data and the purpose of the chart, and you can customize the chart as per your needs.   Sparklines group The Sparklines group in the Insert tab of Microsoft Excel contains various options to create and format sparklines, which are small charts that show trends and patterns in your data. Here are the options available in the Sparklines group: 1. Line: This option allows you to create a sparkline that shows the trend of values over time. 2. Column: This option allows you to create a sparkline that shows the comparison of values across categories. 3. Win/Loss: This option allows you to create a sparkline that shows the positive and negative changes in values over time.

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. Font group: The Font group provides options for formatting text, such as changing the font, font size, font color, bold, italic, underline, and more. 3. Alignment group: The Alignment group provides options for aligning text and values within cells, such as horizontal and vertical alignment, text wrapping, and merging cells. 4. Number group: The Number group provides options for formatting numbers in cells, such as currency, percentage, and date formats. 5. Styles group: The Styles group provides options for applying predefined cell styles or creating custom styles. 6. Cells group: The Cells group provides options for inserting, deleting, and formatting cells, rows, and columns. 7. Editing group: The Editing group provides options for editing cell content, such as clearing contents, filling cells, finding and replacing text, and sorting data. 8. Find & Select group: The Find & Select group provides options for searching for specific content within a worksheet or selecting cells based on specific criteria.   Overall, the “Home” tab in Excel provides quick access to many of the most commonly used features and functions, and can help streamline your workflow when working with spreadsheets.   1. Clipboard group The “Clipboard” group in the “Home” tab of Microsoft Excel provides options for managing the content of the Windows Clipboard, which is a temporary storage area used for copying and pasting data. 1. Cut: This button allows you to cut selected cells or text from the worksheet and store it in the Clipboard. 2. Copy: This button allows you to copy selected cells or text from the worksheet and store it in the Clipboard. 3. Paste: This button allows you to paste content from the Clipboard into the worksheet. You can choose from a range of paste options, such as pasting the content with or without formatting, or pasting only specific parts of the content. 4. Paste Special: This button allows you to paste content from the Clipboard using various special options. For example, you can paste only the values, formulas, or formatting from the copied content, or transpose rows and columns. 5. Format Painter: This button allows you to copy the formatting of a cell or range of cells and apply it to another cell or range of cells.   2. Font Group The “Font” group in the “Home” tab of Microsoft Excel provides options for formatting the appearance of text within cells. Here are some of the main options available in the Font group: 1. Font Name: This drop-down menu allows you to select the font face for the selected cells. Excel comes with a range of fonts, and you can also install additional fonts on your computer. 2. Font Size: This drop-down menu allows you to select the font size for the selected cells. You can choose from a range of predefined font sizes, or enter a custom size. 3. Bold, Italic, Underline: These buttons allow you to apply bold, italic, or underline formatting to the selected text. You can also use keyboard shortcuts (such as Ctrl+B for bold) to apply these formatting options. 4. Font Color: This drop-down menu allows you to select the color for the selected text. You can choose from a range of predefined colors, or use the “More Colors” option to select a custom color. 5. Fill Color: This drop-down menu allows you to select the background color for the selected cells. You can choose from a range of predefined colors, or use the “More Colors” option to select a custom color. 6. Borders: These buttons allow you to apply borders to the selected cells. You can choose from a range of border styles and colors, and you can also customize the border options by clicking the “Borders” drop-down menu.   3. Alignment Group The “Alignment” group in the “Home” tab of Microsoft Excel provides options for aligning the content of cells within the worksheet. Here are some of the main options available in the Alignment group: 1. Horizontal Alignment: This drop-down menu allows you to set the horizontal alignment of the content within the selected cells. You can choose from options such as left, center, right, justify, and distribute. 2. Vertical Alignment: This drop-down menu allows you to set the vertical alignment of the content within the selected cells. You can choose from options such as top, center, bottom, and justify. 3. Orientation: This button allows you to change the orientation of the content within the selected cells, such as rotating it at an angle or flipping it vertically or horizontally. 4. Indent: This button allows you to indent the content within the selected cells, which can be useful for creating a hierarchical structure within a worksheet. 5. Merge & Center: This button allows you to merge multiple cells into a single cell and center the content within the merged cell. 6. Wrap Text: This button allows you to wrap text within a cell, which means that the text will be displayed on multiple lines within the same cell instead of being cut off.   4 Number Group The “Number” group in the “Home” tab of Microsoft Excel provides options for formatting numeric data within cells. Here are some of the main options available in the Number group: 1. Number Format: This drop-down menu allows you to select a predefined number format for the selected cells. You can choose from a range of formats, such as General, Currency, Accounting, Percentage, and Date. 2. Increase – Decrease Decimal: These buttons allow you to increase or decrease the number of decimal places displayed in the selected cells. 3. Comma Style: This button applies a predefined number format that displays comma separators for thousands and a fixed number of decimal places. 4. Percent Style: This button applies a predefined number format that displays values as percentages.   5 Styles Group The “Styles” group in the “Home” tab

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. 4. Save As: Save the current Excel workbook with a new name or in a different location. 5. Print: Print the current Excel workbook or customize print settings. 6. Share: Share the current Excel workbook with others. 7. Export: Export the current Excel workbook to a different format, such as a PDF or CSV file. 8. Options: Access Excel settings and customization options. 9. Account: Manage your Microsoft account and subscription options. 10. Close: Close the current Excel workbook. The File tab also provides access to recent files and displays information about the current Excel workbook, such as the file name, author, and properties.   1. How Open an existing Excel workbook To open a file in Microsoft Excel, follow these steps: 1. Launch Microsoft Excel on your computer. 2. Click on the File tab at the top left corner of the screen. 3. Select “Open” from the options listed on the left-hand side of the screen. 4. Navigate to the location where the file is saved using the file explorer window. 5. Click on the file you want to open to select it. 6. Click on the “Open” button at the bottom right corner of the screen. Alternatively, you can also double-click on the file in the file explorer window to open it directly in Microsoft Excel. 2. Save To save the current Excel workbook, follow these steps: 1. Click on the File tab at the top left corner of the screen. 2. Click on the “Save” option on the left-hand side of the screen. 3. If the file is being saved for the first time, the “Save As” dialog box will appear. Choose the location where you want to save the file, and give it a name. 4. If the file has already been saved previously, it will be saved automatically with the same name and in the same location. 5. Alternatively, you can use the keyboard shortcut “Ctrl+S” to quickly save the current Excel workbook. 3. Save As: To save an Excel file with a new name or in a different location, you can use the “Save As” option in Microsoft Excel. Here are the steps: 1. Open the Excel file you want to save as. 2. Click on the File tab at the top left corner of the screen. 3. Select “Save As” from the options listed on the left-hand side of the screen. 4. In the “Save As” dialog box, choose the location where you want to save the file. 5. In the “File name” field, type a new name for the file, if desired. 6. Choose the file format you want to use from the “Save as type” dropdown menu. Note: Excel files are typically saved as .xlsx or .xlsm files. 7. Click on the “Save” button at the bottom right corner of the screen to save the file with the new name and/or in the new location. Alternatively, you can also use the keyboard shortcut “Ctrl+Shift+S” to quickly access the “Save As” dialog box. 4. Print To print a Microsoft Excel worksheet or workbook, follow these steps: 1. Open the Excel worksheet or workbook you want to print. 2. Click on the File tab at the top left corner of the screen. 3. Select the “Print” option on the left-hand side of the screen. 4. The Print pane will appear on the right-hand side of the screen. 5. Choose your desired printer from the drop-down menu. 6. Choose the number of copies you want to print. 7. Choose the pages you want to print under the “Settings” section. 8. Set any other print options, such as the paper size and orientation, margins, and page layout. 9. Click on the “Print” button to print the worksheet or workbook. Alternatively, you can use the keyboard shortcut “Ctrl+P” to quickly access the Print pane. 5. Share The “Share” option in the File tab of Microsoft Excel allows you to share your Excel workbook with other people. Here are the steps to use this feature: 1. Open the Excel workbook you want to share. 2. Click on the File tab at the top left corner of the screen. 3. Select the “Share” option on the left-hand side of the screen. 4. The Share pane will appear on the right-hand side of the screen. 5. Choose how you want to share the file. You can share via email, OneDrive, SharePoint, or other online storage services. 6. Enter the email addresses of the people you want to share the file with. 7. Add a message, if desired. 8. Choose the permission level you want to grant to the people you are sharing with, such as “Can edit” or “Can view”. 9. Click on the “Share” button to send the sharing invitation. 6. Export The “Export” option in the File tab of Microsoft Excel allows you to save your workbook in a different format or file type. Here are the steps to use this feature: 1. Open the Excel workbook you want to export. 2. Click on the File tab at the top left corner of the screen. 3. Select the “Export” option on the left-hand side of the screen. 4. Choose the file type you want to export the workbook as, such as PDF, CSV, or XPS. 5. Choose the location where you want to save the exported file. 6. Give the exported file a name, if desired. 7. Click on the “Export” button to export the workbook in the selected file type. Alternatively, you can also use the “Save As” option to save the workbook in a different file format or type. This option provides more file types than the “Export” option, and you can also