

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.
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
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