Learn the basics and some advanced features of Ms Excel in this short tutorial series. The course would cover tabs and groups, editing and formatting data, copying, and filling and advanced filling tricks, creating a custom view, comparing two sheets, logical tests, if and nested if functions, date and text functions, basic formulas, trignometric and statistical functions, look up tables, protecting sheets and workbooks, filters, basic and advanced tables, charts and pivot tables, data validation and ends with an overview of shortcuts
Overview
Syllabus
MS Excel - Introduction - Beginner's Guide.
MS Excel - Basics.
MS Excel - Create & Close Files.
MS Excel - Tabs & Groups.
MS Excel - Editing Data.
MS Excel - Formatting.
MS Excel - Characteristics of Cell.
MS Excel - Cell Reference.
MS Excel - Speak Cells.
MS Excel - Text to Columns.
MS Excel - Comments.
MS Excel - Copying and Filling - Tricks.
MS Excel - Advanced Fill.
MS Excel - Fill Series.
MS Excel - Flash Fill.
MS Excel - Viewing Worksheets.
MS Excel - Custom View.
MS Excel - Adjusting worksheet.
MS Excel - Working with Worksheets.
MS Excel - Compare Two Sheets.
MS Excel - View Files Side by Side.
MS Excel - Logical Test.
MS Excel - IF Function.
MS Excel - Nested IF.
MS Excel - AND Function.
MS Excel - Not and If Error.
MS Excel - Auditing Tools.
MS Excel - Text Functions.
MS Excel - Date Functions Part 1.
MS Excel - Date Functions Part 2.
MS Excel - Date Functions Part 3.
MS Excel - Name Range.
MS Excel - Name Range with Formulas.
MS Excel - Basic Formulas.
MS Excel - Count Functions.
MS Excel - Statistical Functions.
MS Excel - Maths & Trigonometry.
MS Excel - Vlookup in Excel Video Tutorials.
MS Excel - VLookup Approximate Match.
MS Excel - VLookup with Trim.
MS Excel - H-Lookup.
MS Excel - VLookup Rules.
MS Excel - Lookup Function.
MS Excel - Lookup Full Record.
MS Excel - Index Function.
MS Excel - Match Function.
MS Excel - Protect Cells.
MS Excel - Protect Sheet.
MS Excel - Protect File.
MS Excel - Protect Workbook.
MS Excel - Hyperlink to Sheet.
MS Excel - Hyperlink to File.
MS Excel - Hyperlink to Webpage.
MS Excel - Hyperlink to Update.
MS Excel - Print Page Setup & Print Data Tips.
MS Excel - Header & Footer.
MS Excel - Data Sorting.
MS Excel - Advanced Filters.
MS Excel - Filtering Data.
MS Excel - Basic Table.
MS Excel - Advanced Table.
MS Excel - Subtotal.
MS Excel - Column Chart.
MS Excel - Design a Column Chart Part:1.
MS Excel - Design a Column Chart Part:2.
MS Excel - Pie, Bar, Column & Line Chart.
MS Excel - XY Scatter Chart.
MS Excel - Spark Line Chart.
MS Excel - Pivot Chart.
MS Excel - Pivot Table Example 1 Video Tutorials.
MS Excel - Pivot Table Example 2.
MS Excel - Pivot Table Example 3.
MS Excel - Pivot Table Grouping.
MS Excel - Pivot Table Slice.
MS Excel - Pivot Table Timeline.
MS Excel - Consolidation.
MS Excel - Consolidation Extended.
MS Excel - Conditional Formatting Part 1.
MS Excel - Conditional Formatting Part 2.
MS Excel - Advanced Conditional Formatting.
MS Excel - Data Validation.
MS Excel - Data Validation Error Alert.
MS Excel - Dependent Dropdown List.
MS Excel - Import Live Data From Web to Excel.
MS Excel - Insert Objects.
MS Excel - Create Objects.
MS Excel - Shortcuts Ctrl+A to Ctrl+Z.
MS Excel - Shortcuts Alt+A to Alt+Z.
MS Excel - Shortcuts Alt + Single Key.
MS Excel - Shortcuts F1 to F12.
MS Excel - Shortcuts Single Key.
MS Excel - Shortcuts Shift+F1 to Shift+F12.
MS Excel - Shortcuts Shift+Single Key.
MS Excel - Shortcuts Ctrl+F1 to Ctrl+F12.
MS Excel - Shortcuts Ctrl + Special Characters.
MS Excel - Shortcuts Ctrl+Single Key.
MS Excel - Shortcuts Ctrl+Shift+A To Ctrl+Shift+Z.
MS Excel - Shortcuts Ctrl + Shift + Special Characters.
MS Excel - Shortcuts Ctrl + Shift + Single Key.
MS Excel - Shortcuts Ctrl+Shift+F1 to Ctrl+Shift+F12.
MS Excel - Shortcuts Alt+F1 to Alt+F12.
Tutorix Simply Easy Learning Steps.
Tutorix Brings Simply Easy Learning.
Taught by
Tutorials Point (India) Ltd.
Reviews
4.8 rating, based on 4 Class Central reviews
-
Professor have a very good knowledge about the ms excel . Professor has a good way to talk .Having great experience from learning him.
-
This is the best course ever
I have learned a lot even though some videos weren't easy for my understanding.
Excel can actually be used for a lot
Calculations, graphical representation of data and many more -
Best experience, It was totally amazing to be in his class, to feel the Super High-Energy and to be inspired by his brilliant work. The knowledge he shares is an eye-opener for me and for all other teachers. I really feel proud, happy and honored to know him and to work with him for Jase is truly a GREAT TEACHER and LEADER.”
-
very good platform to learn from scratch.
very interactive, innovative and friendly videos,
easy to learn and practice,
excellent faculty and very helpfull