Ms Excel Advanced
Your efficiency in MS Excel can be one of the major deciding factors of your career growth, not only because it adds value to your resume, but because it helps you to be extremely efficient in your work. This is exactly the essence of e-learno’s Advanced MS Excel course; to encompass all the aspects of MS Excel, as well as to enhance the practice of applying various formulae and short cuts in daily use.
The Advanced course in MS Excel will hone your skills over the tool to a level of the experts. Our virtual instructors guide you throughout, with practical and assignment-based curriculum and in-depth coverage of each point.
Go beyond the conventional uses of Excel, once you are able to master the tool and experience for yourself how it can help you to be more efficient in your work.
Note: After subscription, a call-back will be arranged from our side to confirm the suitable day and time for starting the course.
Curriculam
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
FAQ's
We provide a wide range of courses for you to choose from. You can go through our list of courses here and see which one fits you the best. You can also talk to our expert counselors in case you still have any difficulties in choosing your course.
All transactions to eLearno are done through a secured payment gateway which is available on the website. You can opt to make payments through credit cards, debit cards or net banking. We do not accept cash or cheques/DDs .
Yes. On completion of your course, a soft copy of your certificate is mailed to you on your registered email ID.
On purchasing of a course, your user name and password is created and shared with you on your registered email ID. You can use these details to access your account from anywhere in your computer, mobile phone or tablet. For any difficulties in your log in or account, you can connect with our technical support team and they will help you resolve your problems.
You can access your account from any device you wish. However, only one log in will be available at any particular time and in the case where a new device is accessed, the previous device is automatically logged out and your session ends
We have simplified our softwares and our courses are supported by almost all devices. However, the primary requirement for accessing our courses and tutorials is having a minimum of 3G speed internet connectivity. For a seamless experience, we recommend a minimum of the following configurations:
For Windows: Windows 7 and above
For Mac: iOS 11 and above
For Android: version 4.4 (Kit Kat) and above
We have our technical team for your assistance in such cases. If your internet connection is lost or your device shuts down during your class, all you need to do is inform our technical team through call regarding the same. You can then try resuming your session as soon as possible.
Yes, you can. All you need to do is to leave a message for the counsellor and you will soon get a call back from us.
Elearno does not have any tie-ups or association with companies and we do not provide assistance in Job Placements.
In the event of unforeseen circumstances, or if you are not happy with the course, you can have a call with our counselors to discuss your feedback and we will try to resolve the issue. However, the course fee is not refundable.
Our technical team is on standby to help you solve any difficulties you may have while accessing your account. Right from assistance in log in, payment, account settings to course material and class assistance, you can connect with us and we help you solve your queries.
Anyone above the age of 14 and with an internet connection can access our courses. There is no upper age limit for the same.
All course material is available for our students once they log into their accounts. However, course material is not available for offline use or for printing.
We have restricted our access to one user per account.
There are various discounts which eLearno provides from time to time. To know the best one which fits you, you can have a word with our counsellor and they will help in making the best customized plan accordingly. Available discounts for the same will be available to you as well.
All courses are available in English language. Other languages may be made available with us shortly.
Call Us Now @
US/CANADA: 18552239012
Australia: 611300361469
UK: 448000663714
What our Users say about us
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
