There is a lot that MS Excel can be used for. Data management, Statistics, Inventory keeping, Forecasting & Analysis, Finance handling and Business intelligence are just a few of its uses. The tools and shortcuts required to master this tool are embedded in the course structure. With this 6 month course, you can be ensured of mastering the basics of MS Excel.

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,Charts: Recommended Chart, Column or Bar Chart, Excel Charts – Chart Elements, Excel Charts – Chart Styles, Color, Excel Charts – Chart Filters, Values, Names, 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 )

Review

( Proofing, Spelling, Thesaurus, Accessibility, Insights, Smart Lookup, Language, Comments, 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, Inspect Workbook, Manage Workbook, Share, Share with People, E-mail, Export, 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, Manage Workbooks, Manage Worksheet Tabs, Navigate Multi-Cell Selections, Comments & Hyperlinks )