Our advanced MS Excel course is meant for a 360° understanding of one of the most widely used MS Office tool in the world. This 6-month course, systematically segregated to cover every function, in detail, is sure to give you the much-needed enhancement and confidence to be ahead in your professional life.

The course curriculum consists of:

Microsoft Excel ─ Getting Started

(Launching Microsoft Excel)

Opening a New Workbook

Components of Microsoft Excel Window

( Ribbon, Quick Access Toolbar, Tell Me, Formula Bar, Expand Formula Bar Button, Vertical Scroll, Horizontal Scroll, Worksheet Navigation Tabs, Insert Worksheet Button, Normal View, Page Layout View, Zoom Level )

Creating a new blank workbook

Creating a new workbook using Template

Navigating in Worksheet

( Navigating into Workbook and Worksheet, Navigating between cells in worksheet, Navigating Cells on Work Sheet )

Editing in Worksheet

( Clipboard, Cut, Copy, Paste, Format Painter, Font )

Save and Save As

( Save, Save As )

Saving a workbook:

( Use of Save As )

Closing a Workbook

Opening an existing workbook

( Recent )

Pin a workbook

Print Preview & Print worksheet

( Print Worksheet, Print one or Several worksheets, Print one or Several workbooks, Print all or part of a worksheet, Print an Excel table, Print to File )

Change the Zoom Settings

( Zoom-in View, Zoom-Out View, 100%, Zoom to Selection, Zoom, Steps for Changing the Default Zoom, Changing the default Zoom settings of a Worksheet )

Working with Multiple Worksheets

( Inserting a new worksheet, Copying a worksheet, Renaming a worksheet, To move a worksheet, Changing the worksheet tab color, Deleting a worksheet, Switching between worksheets, Grouping and ungrouping worksheets, Group worksheets, Ungroup worksheets )

Home

( Alignment, Wrapping text and merging cells, To wrap text in cells, To merge cells using the Merge & Center command, To access more merge options, To center across selection, Number, Why use number formats? , Applying number formats, Using number formats correctly, Date formats Number formatting tips, Styles, Conditional Formatting, Highlight Cells Rules, Clear Rules, Top/Bottom Rules, Format as Table, Cells, Inserting, deleting, moving, and hiding, Format, Editing, AutoSum, Fill, Sort & Filter, Find & Select )

Insert

( Tables, Pivot Table, Recommended Pivot Table, Table, Illustrations, Pictures, Shapes, Icons, 3D Model, SmartArt, Screenshot )

Picture Tools – Format

( Adjust, Remove Background, Corrections,Colors, Artistic Effects, Compress Pictures, Change Picture, Reset Picture, Picture Styles, Picture Border, Picture Effects, Picture Layout, Alt Text, Arrange, Bring Forward, Send Backward, Selection Pane, Align, Group, Rotate, Size, Crop, Height, Width )

Drawing Tools – Format

( Shape Styles, Shape Fill, Shape outline, Shape Effects, WordArt Styles, Text Fill, Text Outline, Text Effects )

SmartArt Tools – Design

( Create Graphic, Add-ins, Store, My Add-ins, Bing Maps, People Graph,Charts, Recommended Chart, Column or Bar Chart, Bar Chart, Line or Area Chart, Pie or Doughnut chart, Doughnut Chart, Hierarchy Chart, Statistic Chart, Scatter or Bubble Chart, Waterfall, Stock, Surface or Radar Chart, Combo Chart, Pivot Chart, Excel Charts – Chart Elements, Axes, Axis Titles, Chart Title, Data Labels, Data Table, Error Bars, Gridlines, Legend, Trendline, Excel Charts – Chart Styles, Color, Excel Charts – Chart Filters,Values, Names, Excel Charts – Fine Tuning, Select / Deselect Chart Elements, Format Style, Format Color, Chart Filters )

Chart Tools – Design

( Add Chart Element, Quick Layout, Change Colors, Chart Styles, Switch Row/Column, Select Data, Change Chart Type, Move Chart, Excel Charts – Quick Formatting, Format Pane, Format Axis, Format Chart Title, Format Chart Area, Format Plot Area, Format Data Series, Format Data Labels, Format Data Point, Format Legend, Format Major Gridlines, Excel Charts – Aesthetic Data Labels, Data Label Positions, Format a Single Data Label, Clone Current Label, Data Labels with Effects, Shape of a Data Label, Resize a Data Label, Add a Field to a Data Label, Connecting Data Labels to Data Points, Format Leader Lines )

Chart Tools – Format

( Insert Shapes, Shape Styles, WordArt Styles, Arrange Group, Size Group, Tours, 3D Tours, Sparklines, Sparklines with Quick Analysis, Sparklines with INSERT tab, Filters, Slicer, Timeline, Links, Inserting link to a location, Inserting a link to a Webpage, Inserting a link to send an E-mail, Inserting a Link to a Location on Your Computer or Server, Text, Text Box, Header & Footer, Header & Footer Elements, Navigation, Options, Word Art, Signature Line, Object, Symbols, Page Layout, Themes, Page Setup, Scale to Fit, Sheet Options, Data, Get External Data, Data Tools )

Review

( Proofing, Spelling,Thesaurus, Accessibility, Insights, Smart Lookup, Language, Comments, Protect, Protect Sheet, Protect Workbook, Allow Edit Ranges, Ink, Start Inking )

View

( Workbook Views, Normal, Page Break Preview, Page Layout, Custom View )

Show

Zoom

( Zoom, 100%, Zoom to Selection )

Window

( New Window, Arrange All, Freeze Panes, Split, Hide, Unhide, View Side by Side, Synchronous Scrolling, Reset Window Position, Switch Windows )

Macros

( Steps to record a Macro, Deleting a Macro)

Changing the default save location

Auto Recover

Using Auto Recover

Compatibility Mode

Converting a workbook to make it compatible

File Tab

Info

( Protect workbook, Inspect Workbook, Manage Workbook, Steps for applying Browser view option-)

Share

( Share with People, E-mail )

Export

Publish

( Publish to Power BI from Excel 2016 )

Account

Feedback

Options

( General, Formulas, Proofing, Save, Language, Ease of Access, Advanced, Quick Access Toolbar, Add-Ins, Trust Center )

Help

Help & Support

( Contact Support, Feedback, Show Training, What’s New )

Community

( Community, Blog Site, Suggest a Feature )

Shortcuts for Microsoft office 2016

Navigate Worksheets

Select Cells

Juggle Rows, Columns and Cells

Edit Cell Content

Duplicate Cells, Rows & Columns

Undo, Redo & Repeat Action

Cut, Copy, Paste & Paste Special

Format Cells

Find & Replace

Formulas

Manage Workbooks

Manage Worksheet Tabs

Freeze, Split & Hide

Auto Filter

Column Width & Row Height

Navigate Multi-Cell Selections

Comments & Hyperlinks

Pivot Tables

Excel Auto Tables & Data Forms

Group Rows & Columns

The Rest