Microsoft Excel

Microsoft Excel course is offered by Gautam Buddha Computer Training Institute. Microsoft Excel is a powerful spreadsheet software with a wide range of features and options.

Gautam Buddha Computer Training Institute aims at serving the people of the country by making them competent & strong enough to face the running life of the upcoming technologies.

Content:

• File Tab (Backstage View):
• New, Open, Save, Save As, Print, Share, Export, Close
• Account, Options, and Exit
• Home Tab:
• Clipboard: Cut, Copy, Paste
• Font: Font type, size, bold, italic, underline
• Alignment: Text alignment, orientation
• Number: Number formats, currency, percentage
• Styles: Cell styles, conditional formatting
• Cells: Insert, delete, format, hide, and more
• Insert Tab:
• Tables, Illustrations (Pictures, Shapes, etc.), Charts, Sparklines, Filter
• Page Layout Tab:
• Themes, Page Setup (Margins, Orientation, Size), Print Area, Print Titles, Sheet Options
• Formulas Tab:
• Insert Functions, Defined Names, Formula Auditing, Calculation options
• Advance Formula (VLOOKUP and HLOOKUP, XLOOKUP, INDEX and MATCH, IFERROR, SUMIFS and COUNTIFS, SUMPRODUCT, INDIRECT, SUM, AVERAGE, MINIMUM, MAXIMUM, OFFSET, TEXTJOIN, IF, AND, OR, SUMPRODUCT, AVERAGEIFS, CHOOSE, DATEDIF Etc.)
• Data Tab:
• Get Data (Import External Data), Sort, Filter, Data Tools, Outline, What-If Analysis
• Review Tab:
• Proofing: Spelling, Research, Thesaurus
• Language: Language settings, Translate
• Comments, Changes, Compare
• View Tab:
• Workbook Views, Show/Hide (Gridlines, Formula Bar, Headings), Zoom
• Macros, Window, Switch Windows, View Side by Side, Arrange All
• Developer Tab:
• Tools for creating and working with macros, form controls, add-ins
• Add-ins Tab:
• Additional tools and features based on installed add-ins.
• Ribbon Display Options:
• Allows you to customize the appearance of the ribbon.
• Status Bar:
• At the bottom, shows various information like sum, average, count, etc., depending on the selection.
• PivotTable Tools (Analyze and Design):
• Additional options and features for working with PivotTables.
• Chart Tools (Design and Format):
• Additional options and features for working with charts.