

The truth about excel is that it is one of the most widely used, and simplest, data management tools that you may ever come across. Even today, not only students and smaller companies, but even MNCs and conglomerates make use of it on a very large scale.
E-learno’s Basic MS Excel training course gives you the power to strengthen your Excel skills and add a valuable skill-set to your resume. Step-by-step process guidance by expert MS Excel instructors and assignment-based curriculum not only focuses on the theory, but gives equal importance to the practical usage.
Explore what MS Excel can help you achieve, be it for your own business, private use or as a career building tool.
Note: After subscription, a call-back will be arranged from our side to confirm the suitable day and time for starting the course.
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 )
I received my certificate from Elearno, and it feels so good. The course which I took was challenging,as I am not a Computer savvy person but wished to do Computer Skills advance. I took one to one classes and was really glad because Mr. Ayush was really helpful and patient with me throughout the course. I enjoyed your class tremendously. I look forward to taking another class with you.
Kerry Sheppard
Customer Support Lead
I received my certificate from Elearno, and it feels so good. The course which I took was challenging,as I am not a Computer savvy person but wished to do Computer Skills advance. I took one to one classes and was really glad because Mr. Ayush was really helpful and patient with me throughout the course. I enjoyed your class tremendously. I look forward to taking another class with you.
Kerry Sheppard
Customer Support Lead
Elearno definitely provides excellent content and assignments that build on your knowledge, reinforce, and then expand. The content is so easy, creative with proper screenshots that even after class if you access it or read it you will be able to do pratical glitches where you've been stucked up very easily. Daily assignments and short pratical asssessments help you in reviving back everything you learned in the class with the tutor better.
Joyce Pittard
Therapist
The fact that the assignments are graded means you revive and do everything done in the class so that it helps you to practice. And I love assignments.. My tutor was extremely particular and use to challenge us everyday with different tasks. It kept us excuited throughout the course. I loved taking Online Classes with them.
Evelyn Huntzingre
Retired nurse
Course materials were good, the mentoring approach given in the live classroom was same as traditional one, no difference. Moreover. working with other in the group classroom was creative and fun.It was fun interacting with people from different part of the world sharing knowledge and learning. The instructor did a good job of communicating and making it a more intimate arrangement. A lot of online courses fail to deliver this enviornmenmt. and i want to congratulate Mr. Ayush for the same.
Sophia Lillis
Primary Teacher
I have taken Ms. Word Basic course with Elearno. Now i am all set to use it in real-time for my blogs and short stories. I am so excited to use its feature as i know it will reduce my work and time. I am looking forward for my next class MS Powerpoint now. Thank you Elearno!
Rachel Hollis
University Coucelor
I received my certificate from Elearno, and it feels so good. The course which I took was challenging,as I am not a Computer savvy person but wished to do Computer Skills advance. I took one to one classes and was really glad because Mr. Ayush was really helpful and patient with me throughout the course. I enjoyed your class tremendously. I look forward to taking another class with you.
Kerry Sheppard
Customer Support Lead
Elearno definitely provides excellent content and assignments that build on your knowledge, reinforce, and then expand. The content is so easy, creative with proper screenshots that even after class if you access it or read it you will be able to do pratical glitches where you've been stucked up very easily. Daily assignments and short pratical asssessments help you in reviving back everything you learned in the class with the tutor better.
Joyce Pittard
Therapist
The fact that the assignments are graded means you revive and do everything done in the class so that it helps you to practice. And I love assignments.. My tutor was extremely particular and use to challenge us everyday with different tasks. It kept us excuited throughout the course. I loved taking Online Classes with them.
Evelyn Huntzingre
Retired nurse
Course materials were good, the mentoring approach given in the live classroom was same as traditional one, no difference. Moreover. working with other in the group classroom was creative and fun.It was fun interacting with people from different part of the world sharing knowledge and learning. The instructor did a good job of communicating and making it a more intimate arrangement. A lot of online courses fail to deliver this enviornmenmt. and i want to congratulate Mr. Ayush for the same.
Sophia Lillis
Primary Teacher
I have taken Ms. Word Basic course with Elearno. Now i am all set to use it in real-time for my blogs and short stories. I am so excited to use its feature as i know it will reduce my work and time. I am looking forward for my next class MS Powerpoint now. Thank you Elearno!
Rachel Hollis
University Coucelor