Tutorialspoint
Freedom Sales | Secure your Future with Latest Skills | Get 10% OFF on checkout, Use CODE "FREEDOM"
Sales End on 17th August

Unleash the Power of Microsoft Excel

Unleash the Power of Microsoft Excel - Simply Easy Learning

Tutorialspoint

    • Video
      MS Excel Online Training
      • MS Excel - Basics
        • Course Resources
        • Excel - Introduction 01:23 Preview
        • Excel - Basics 07:02 Preview
        • Excel - Create & Close Files 01:59 Preview
        • Excel - Tabs & Groups 04:28
        • Excel - Editing Data 09:48
        • Excel - Formatting 11:22
        • Excel - Characteristics Of Cell 01:14
        • Excel - Cell Reference 08:12
        • Excel - Speak Cells 04:27
        • Excel - Text To Columns 06:48
        • Excel - Comments 03:02
      • Excel - Filling
        • Excel - Copying & Filling 07:21
        • Excel - Fill Series 02:22
        • Excel - Advanced Fill 05:28 Preview
        • Excel - Flash Fill 04:32
      • MS Excel - Filling
        • Excel - Viewing Worksheets 06:49
        • Excel - Custom View 03:15
        • Excel - Adjusting Worksheet 10:10
        • Excel - Working With Worksheets 08:36
        • Excel - Compare Two Sheets 03:09 Preview
        • Excel - View Files Side By Side 05:00
      • MS Excel - Logical Functions
        • Excel - Logical Test 02:20
        • Excel - IF Function 07:14
        • Excel - Nested if 02:38
        • Excel - AND Function 03:02
        • Excel - Not And If Error 02:07
        • Excel - Auditing Tools 06:30
      • MS Excel - Functions & Formulas
        • Excel - Text Functions 09:48
        • Excel - Date Functions Part 1 06:41
        • Excel - Date Functions Part 2 06:16
        • Excel - Date Functions Part 3 03:37
        • Excel - Name Range 05:39
        • Excel - Name Range With Formulas 07:26
        • Excel - Basic Formulas 06:27
        • Excel - Count Functions 07:18
        • Excel - Statistical Functions 09:33
        • Excel - Maths & Trigonometry 11:08
      • MS Excel - Lookup
        • Excel - VLookup With Exact Match 06:37
        • Excel - VLookup Approximate Match 04:14
        • Excel - VLookup With Trim 04:27
        • Excel - H-Lookup 01:44
        • Excel - VLookup Rules 02:34
        • Excel - Lookup Function 07:25
        • Excel - Lookup Full Record 02:00
        • Excel - Index Function 02:38
        • Excel - Match Function 01:14
      • MS Excel - Protection
        • Excel - Protect Cells 04:31
        • Excel - Protect Sheet 03:12
        • Excel - Protect File 02:01
        • Excel - Protect Workbook 01:19
      • MS Excel - Hyperlink
        • Excel - Hyperlink To Sheet 01:45
        • Excel - Hyperlink To File 02:07
        • Excel - Hyperlink To Webpage 04:31
        • Excel - Hyperlink To Update 02:27
      • MS Excel - Page Setup
        • Excel - Print Page Setup 13:51
        • Excel - Header & Footer 08:49
      • MS Excel - Sort & Filters
        • Excel - Data Sorting 09:04
        • Excel - Advanced Filters 07:40
        • Excel - Filtering Data 07:09
      • MS Excel - Tables & Subtotal
        • Excel - Basic Table 05:45
        • Excel - Advanced Table 06:29
        • Excel - Subtotal 04:09
      • MS Excel - Charts
        • Excel - Column Chart 06:42
        • Excel - Design A Column Chart Part:1 04:13
        • Excel - Design A Column Chart Part:2 16:17
        • Excel - Pie, Bar, Column & Line Chart 08:55
        • Excel - XY Chart 16:24
        • Excel - Spark Line Chart 06:46
        • Excel - Pivot Chart 04:38
      • MS Excel - Pivot Tables
        • Excel - Pivot Table Example 1 15:04
        • Excel - Pivot Table Example 2 06:38
        • Excel - Pivot Table Example 3 05:41
        • Excel - Pivot Table Grouping 04:44
        • Excel - Pivot Table Slice 09:37
        • Excel - Pivot Table Timeline 05:43
      • MS Excel - Consolidate
        • Excel - Consolidation 08:56
        • Excel - Consolidation Extended 05:00
      • MS Excel - Conditional Formatting
        • Excel - Conditional Formatting Part 1 10:41
        • Excel - Conditional Formatting Part 2 05:54
        • Excel - Advanced Conditional Formatting 05:19
      • MS Excel - Data Validation
        • Excel - Data Validation 11:01
        • Excel - Data Validation Error Alert 06:08
        • Excel - Dependent Dropdown List 04:49
      • MS Excel - Importing Data
        • Excel - Import Live Data From Web 09:20
      • MS Excel - Objects
        • Excel - Insert Objects 05:16
        • Excel - Create Objects 04:19
      • MS Excel - Shortcuts
        • Excel - Shortcuts Ctrl+A To Ctrl+Z 12:16
        • Excel - Shortcuts Alt+A To Alt+Z 06:20
        • Excel - Shortcuts Alt + Single Key 07:04
        • Excel - Shortcuts F1 To F12 11:00
        • Excel - Shortcuts Single Key 03:44
        • Excel - Shortcuts Shift+F1 To Shift+F12 06:03
        • Excel - Shortcuts Shift+Single Key 01:58
        • Excel - Shortcuts Ctrl+F1 To Ctrl+F12 04:43
        • Excel - Shortcuts Ctrl + Special Characters 07:10
        • Excel - Shortcuts Ctrl+Single Key 05:49
        • Shortcuts Ctrl+Shift+A To Ctrl+Shift+Z 05:21
        • Shortcuts Ctrl + Shift + Special Characters 03:32
        • Excel - Shortcuts Ctrl + Shift + Single Key 05:17
        • Shortcuts Ctrl+Shift+F1 To Ctrl+Shift+F12 04:11
        • Excel - Shortcuts Alt+F1 To Alt+F12 02:16
    • Video
      Advanced Excel
      • Introduction
        • Introduction to the course and your tutor 02:51 Preview
      • Goal seek
        • Goal seek and "what-if" analysis 06:36 Preview
        • Creating A Chart 04:23
        • Loan Mortgage Analysis 02:05
        • Changing Interest Rates 02:42 Preview
        • Projecting figures using a Data Table 04:13
        • Two Input Data Table 04:41
      • Pivot Tables
        • Using Pivot Tables 09:38
        • Changing the Layout of a Pivot Table 01:53
        • Filtering Fields 02:15
        • Format Report 05:51
        • Creating a Chart from a Pivot Table 06:04
      • Extended Graphics
        • Extended Graphics 04:54
        • Combination Charts 09:06
      • Final words
        • Answers - final spreadsheet 01:03
        • File Resources
    • Video
      Excel Simplified - 101 Tips
      • Introduction
      • Data
        • Enter numbers and fractions 05:00
        • Dates and Times 07:46
        • Name Cells and Ranges 03:45
        • Validate Data entry using a pick list 07:34 Preview
        • Extend a series of dates with autofill 04:18
        • Add a symbol or special character 03:56
        • Compare multiple spreadsheets using freeze panels 06:08
        • Hide rows 04:24
        • Keyboard 09:58
        • Speak Cells 03:48
        • Find and replace data 10:35
      • Formulas and Functions
        • Add values 03:08 Preview
        • Function wizard 06:07
        • Formulas with comments 04:32 Preview
        • OneNote 05:43
        • Define a constant 04:01
        • Apply names in functions 04:23
        • Figure out the best loan terms 04:23
        • Internal Rates of Return 04:16
        • Nth largest value 03:53
        • Large, Small, Max, Min 04:38
        • Conditional formula 02:59
        • Conditional formula with names 03:58
        • Count If 02:02
        • Conditional sum 02:53
        • Inner calculator 02:32 Preview
        • Square Roots 03:06
        • Calculate the duration between two times 04:07
        • Calculate days between two dates 04:28
      • Copying Data, Formats etc.
        • Copy a range 03:01
        • Transpose a row into a column 01:40 Preview
        • Copy styles to another workbook 07:29
        • Chart formatting 07:14
        • Paste special and copying worksheets 06:26
        • Track changes while Editing 06:03
      • Lists
        • Enter list data using a form 04:39
        • Searching through a data list 04:15
        • Import a word list into excel 04:36
        • Sort a list 01:58
        • Filter a list 02:37
        • Sort by multiple criteria 02:58
        • Find averages in a sorted group 05:07
        • Filter by multiple criteria 03:07 Preview
        • Remove duplicate records from a list 03:03
        • Count filtered records 06:51
        • Filter by multiple criteria in the same column 06:03
        • Chart a filtered list 02:24
        • Look up information in a List 05:08
      • Data Patterns
        • Create a PivotTable 05:29
        • Modify a PivotTable and layout 02:53
        • Find the average of a field 03:57
        • Create a calculated field 01:55
        • Hide rows and columns in a PivotTable 01:59
        • AutoFormat a PivotTable 01:14
        • Create a PivotChart 03:01
        • Turning on the Data Analysis function so that statistical information can be run 02:27
        • Describe Data with Statistics 02:59
        • Discover associations within your data 03:30
        • Product Numbers 01:46
        • What-if analysis 05:11
        • Goal seek 06:20
      • Creating Charts
        • Create a Chart 05:42
        • Modify Chart details 04:02
        • Change the Chart Type 03:36
        • Add a Trendline to a Chart 06:19
        • Remove Chart Data 01:53
        • Add chart data 02:05
        • Missing chart data 04:14
        • Error bars 03:55
        • Pull a slice from a Pie Chart 03:04
        • Label slices of a Pie Chart 04:01
        • Histogram 06:21
        • Paste a chart into Word 03:26
        • Amending a chart in Word 02:04
        • Paste-link a Chart into Word 04:40
      • Worksheets
        • Format Numbers as Percentages 03:41
        • Format Currencies in Currency and Accounting Formats 03:24
        • Format Column Headings 05:07
        • Format Quickly with Format painter 02:25 Preview
        • Insert a background image into your worksheet 02:48
        • Create a Transparent image 03:08
      • Saving and Printing Worksheets
        • Save a workbook as a Template 06:50
        • Save a workbook as an XML spreadsheet 05:02
        • Print multiple cell ranges on One Page 03:04
        • Page set up, header, footer, margins - 1 page printing 04:24
        • Print multiple areas of a workbook 07:56
        • Print multiple worksheets of a workbook 01:19
        • Repeat Headings of a Row or Column 07:11
        • Print functions to show calculations & comments 07:19
      • Extending Excel
        • Hyperlink a worksheet to another office document 02:48
        • Embed a chart within PowerPoint 05:46
        • Publish an Interactive Workbook 05:05
        • Importing data from a Web Site or Access Database 02:26
        • Import a Worksheet into Access 08:56
        • Use Excel Data To Create Labels In Word 09:50
      • Customizing Excel
        • Launch a specific Workbook when Excel Opens 03:38
        • Save Time by Creating a Custom View 03:20
        • Create a Custom Number Format 06:11
        • Changing Text to Columns 05:28
        • Create a Macro to Format Numbers 06:47
    • Video
      Must Know Excel Formulas and Functions
      • Full Course
        • Preview 00:42 Preview
        • Full Course 54:54
    • Video
      Excel - A Step by Step Complete Course
      • The Excel 2016 Introduction
        • Introduction 02:57 Preview
        • Tabs of ribbon 06:45 Preview
        • Ribbon User Interface 09:11
        • Entering the values 08:20
        • find replace & search 06:20
      • The Excel 2016 - User Experience
        • Entering data 09:08 Preview
        • Customizing quick access toolbox 09:29 Preview
        • Surfing work area 09:39
        • Formula bar 07:15
        • Keyboard keys 06:02
        • Entering date time 04:45
        • Fabricating formulas 08:15
        • Formula Flub-ups 10:36
        • Autofill 06:53
        • Inserting functions 03:56
        • Autofill & flashfill 07:02
        • Finding totals 05:27
        • Saving excel file 04:15
      • To Make it all Look Pretty
        • Selecting cells 07:34 Preview
        • Format as table 06:50
        • Custom table style & cell formatting 08:56
        • Number formats 09:28
        • Rows & columns 06:17
        • Fonts & alignment 04:25
        • Formatting via quick analysis tool 04:24
      • Going Through Changes
        • Opening workbooks 09:06 Preview
        • Drag & drop & copying 07:04
        • Find work book files 04:07
        • Cut & paste 07:13
        • Paste from clipboard task pane 06:50
        • Deleting & inserting stuff 08:01
        • Spelling errors 04:35
      • Printing the Sheets
        • Preview pages & print screen 05:32
        • Page setup 05:44
        • Header & footer 06:21
      • Maintaining the Worksheet
        • Page break problems & print formulas 04:34 Preview
        • Zooming In and Out 09:16
        • Managing comments 04:13
        • Range name 08:55
        • Controlling recalculation & protection 04:44
      • Maintaining Multiple Works
        • Juggling multiple worksheets 05:06
        • Opening windows 03:20
        • Shifting sheets 07:14
      • What-If Analysis
        • Goal seek & scenario 09:00
        • One & two variable data table 04:46
      • Charts & Graphics
        • Charts 08:27
        • Adding graphics 10:01
      • Pivot Tables
        • Pivot Tables 05:51
      • Data Lists
        • Creating data list 05:13
        • Sorting filtering 01:52
      • Advanced
        • Addins 06:52
        • Hyperlinks 04:07
        • Macros 07:05
        • Sharing sheets 07:45
        • Slicers & timelines 04:19
    • Video
      Power Pivot - Big Data Analysis Made Easy
      • Introduction
      • Power Pivot - from Basic to Intermediate
        • Power Pivot - An Intro 05:54
        • "Relationship building" - no DAX formulas needed! 04:21
        • Integrating all tables into 1 pivot table - no DAX formulas needed! 04:28
        • Table Naming Conventions 01:36 Preview
        • Dashboard - no DAX formulas needed! 02:13
        • Extra: Create Relationship "not" from Power Pivot, but from Excel! 03:47
      • Power Pivot - DAX Formulas in Data Analysis
        • Task No. 1 using DAX formulas - Matching price with product ID 03:39
        • Task No. 2 using DAX formulas - Adding up all sales 03:42
        • Task No. 3 using DAX formulas - Getting YTD sales and prior year’s sales 05:05 Preview
        • Task No. 4 using DAX formulas - Comparing to prior year’s sales 06:57
        • Dashboard reporting measures - Put it all together! 04:16
      • Power Pivot - 7 Best Practices
        • First 3 Best Practices 05:01
        • 4 more best Practices 02:44
      • Conclusion
        • Takeaways 01:09
        • Next Course and Q&A 00:51
      • Supporting Materials
        • Supporting Materials
    • Video
      Microsoft Excel 365 - from basic to advanced
      • Introduction
      • The basics of Excel
        • Working with Excel files 05:58 Preview
        • Ribbon Menu and Quick Access Toolbar 09:31 Preview
        • UI theme, Background and Options 03:26
        • The basics of inputting data 05:17
        • Data types 05:07
        • Contextual menus 03:36
        • Data structure 05:39
        • Navigation 08:27
      • Working with data
        • Editing data and AutoFill 07:13 Preview
        • Creating custom AutoFill 05:39
        • Undo, Redo, Save, and Save-as 07:34
        • The basics of Formula 07:26
        • Introduction to Function, SUM and AVERAGE 10:31
        • XLOOKUP function 05:20
        • Cut, Copy, and Paste 07:59
      • Cell references
        • Cell reference range 06:49
        • Relative vs Absolute References 07:41
        • Mixed reference and the ROUND function 07:09
        • External Worksheet reference 05:11
        • External Workbook Reference 08:41
        • Named reference 09:23
      • Data presentation
        • Formatting basics in Excel 06:18
        • Number formatting and Format Painter 08:47
        • Custom formatting 09:54
        • Basic date formatting 05:58
        • Advanced date formatting 07:55
        • Text formatting 06:09
        • Text color 07:34
        • Fill color 07:58
        • Border line settings 08:57
        • Border styles and colors 04:34
        • Column and row sizes 07:15
        • Text position and orientation 03:11
        • Cell Styles 09:02
      • Managing table structure
        • Organizing table structure 07:11
        • Hiding columns and rows 05:44
        • Merging and splitting cells 07:27 Preview
      • Graphics and Charts
        • Inserting images 06:36 Preview
        • Insert versus Link 04:17
        • Transformation and snapping 04:45
        • Managing visual objects in Excel 08:00
        • Transparency and Cropping 08:30
        • Shape objects basics 07:19
        • Lock Drawing, Modifiers, and Alignment 08:55
        • Editing Shapes 08:35
        • Text box 10:22
        • Effects and Styles 06:27
        • Grouping 03:53
        • SmartArt in Excel 09:31
        • Creating Charts in Excel 07:39
        • Managing chart objects and data 08:59
        • Chart design customization 08:12
        • Sparkline 08:01 Preview
      • Advanced data processing
        • Paste types 10:21
        • Notes and Comments 10:43
        • Find 08:04
        • Replace 06:38
        • Sorting data 07:30 Preview
        • Filters 07:55
        • Freeze panes 03:14
      • Table and PivotTable
        • Excel table basics 08:05
        • Advanced Excel table 09:01
        • PivotTable basics 09:35
        • PivotTable Field, Filter, and Slicer 07:15
        • PivotTable design 06:53
        • Connecting Excel table to PivotTable 06:38
      • Conditional formatting
        • Conditional formatting basics 09:23
        • Conditional custom formatting 05:17
        • Advanced conditional rules 08:52
        • Rule stacking 04:51
        • Conditional formatting with graphics 09:58
        • Active cell in Excel 03:44
        • Conditional formatting with formulas 09:27
      • Printing and exporting
        • Basic printing techniques 10:26 Preview
        • Selective printing 09:51
        • Adding a Header or Footer 09:03 Preview
        • Header or Footer content and size 10:11
        • Managing Headers and Footers 03:15
        • Scale to fit 05:25
        • Sheet options 09:07
        • Locking data in Excel 07:51
        • Protecting Excel files 06:38 Preview
        • Print to PDF and XPS 09:56
        • Exporting with Insert Object 06:55
        • Exporting with Copy and Paste 07:57
    • eBook
      Excel Tutorial
  • Description

    Overview:

    Hands on Excel Training from Beginner to Advance Level, Course Includes Next Level Excel Skills, Workbooks, Exercises, Functionality, 101 Excel Tips and Tricks, Audit Data Using Pivot Tables, Charts, Analysis Functions, Macros, Data Analysis and Automation, Insights about DAX Formulas, Microsoft Excel 365 and Much More.


    • 8 Modules
    • 462+ Lectures
    • 38+ Hrs HD Videos
    • Course Designed by Industry Experts
    • Up-to-Date Curriculum
    • eBook
    • Full Lifetime Access
    • 30 Days Refund Policy
    • Certificate on Completion


    About Premium Pack:

    Welcome to our Excel Premium Pack. It has been designed in such a way that will grant you access to analyze data at any level by using Microsoft Excel. Whether you are beginner or advanced level professional, help you to create spreadsheets and perform advanced level data analysis with functions , Microsoft 365, formulas, charts, macros, DAX formulas, tips and tricks and much more.


    Scope of Microsoft Excel:

    • As of 2021, Possessing Microsoft Excel skills has become one of the most must-have strengths irrespective of professions.
    • Job roles that advance excel holds for you: MIS Executive, Project Managers or coordinators, Market Research Analysts, Digital Marketers.
    • As of 2021, Above professionals can earn as much as $192,000 a year!

    Goals

    • The basic of using Excel.
    • Get an hand-on experience on how to use Excel Formulas And Functions.
    • Design attractive data presentation utilizing various formatting and graphic techniques
    • You will Explore SmartArt, Pivot Tables & Charts Including Slicers, Data Grouping & Analysis and Tracing Errors.
    • Learn about Advanced Excel skills such as using DAX formulas, also known as Data Analysis Expressions
    • How to connect data from different sources before feeding them into 1 single pivot table
    • You will get to know Relationship mapping, Power Pivot Table and way of doing VLOOKUP()
    • Learn about the best practices in Power Pivot modeling
    • Building the ultimate dashboard in Power BI that utilizes DAX formulas and much more

    Prerequist

    • Basic Computer Fundamentals & Terminologies
    • No other knowledge is required, as each step is explained fully in the course.
    • Will to become an expert in excel
Unleash the Power of Microsoft Excel
This Prime Pack Includes :

38 hours

7 Video Courses

1 eBooks

Lifetime Access
Preview

Preview