YoVDO

MS-Excel

Offered By: YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Pivot Tables Courses Data Validation Courses Data Formatting Courses VLOOKUP Courses

Course Description

Overview

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


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.

Related Courses

Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Case Study: Net Revenue Management in Excel
DataCamp
Case Study: Net Revenue Management in Google Sheets
DataCamp
Data Analysis in Excel
DataCamp
Data Analysis in Google Sheets
DataCamp