Udemy - Master Excel From Novice to Expert!

seeders: 1
leechers: 51
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Master Excel From Novice to Expert!
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Getting started with Excel
    • 1. Account Information.mp4 (5.3 MB)
    • 2. Introduction to the Course.mp4 (20.1 MB)
    • 3. Excel Interface.mp4 (14.1 MB)
    • 4. Customising the Quick Access Toolbar.mp4 (20.4 MB)
    • 5. Customising Excel Ribbon.mp4 (20.9 MB)
    • 6. Common Excel Shortcut Keys.mp4 (5.2 MB)
    • 7. Workbook vs Worksheet.mp4 (4.1 MB)
    • 8. How to save an Excel File.mp4 (12.4 MB)
    10. Excel Templates
    • 1. Introduction to Excel Templates.mp4 (17.8 MB)
    • 2. Creating a Custom Template.mp4 (22.1 MB)
    11. Sorting Data
    • 1. Getting Started with Sorting Data.mp4 (15.4 MB)
    • 1.1 Practice File.xlsx (42.7 KB)
    • 2. Sorting Data.mp4 (19.0 MB)
    • 3. Multi Level Sorting.mp4 (21.2 MB)
    • 4. Custom Sorting.mp4 (19.1 MB)
    • 5. Applying Filters to Datasets.mp4 (30.9 MB)
    • 6. Converting Datasets into Tables.mp4 (46.9 MB)
    12. Data Validation
    • 1. Introduction to Data Validation.mp4 (7.0 MB)
    • 2. Data Validation Drop Down List.mp4 (11.3 MB)
    • 3. Different Types of Data Validation.mp4 (28.2 MB)
    • 4. Dynamic Drop Down List.mp4 (17.7 MB)
    • 5. Custom Error Alerts.mp4 (21.5 MB)
    13. Database Functions
    • 1. SUMIF and SUMIFS Function.mp4 (72.1 MB)
    • 2. DSUM Function.mp4 (54.9 MB)
    • 3. Benefits of using DSUM Function.mp4 (39.2 MB)
    • 4. SUBTOTAL Function.mp4 (61.9 MB)
    14. Pivot Tables
    • 1. Creating a Pivot Table.mp4 (51.3 MB)
    • 2. Modifying Excel Pivot Tables.mp4 (27.0 MB)
    • 3. More on Modifying Pivot Tables.mp4 (30.7 MB)
    • 4. Grouping and Filtering Data in Pivot Tables.mp4 (58.4 MB)
    • 5. Drilling Down feature in Excel Pivot Tables.mp4 (21.7 MB)
    • 6. Pivot Charts and Slicers.mp4 (72.9 MB)
    15. Excel's Conditional Functions
    • 1. IF() Function.mp4 (28.3 MB)
    • 2. IF() Function and AND() Function.mp4 (48.8 MB)
    • 3. IF() and OR() Function.mp4 (27.9 MB)
    • 4. Nesting Multiple IF() Functions.mp4 (32.1 MB)
    • 5. COUNTIF() Function.mp4 (24.6 MB)
    16. Excel's Lookup Functions
    • 1. VLOOKUP() Function.mp4 (66.2 MB)
    • 2. HLOOKUP() Function.mp4 (31.9 MB)
    • 3. INDEX() Function.mp4 (26.8 MB)
    • 4. MATCH() Function.mp4 (17.8 MB)
    • 5. INDEX() AND MATCH() Functions Together.mp4 (32.0 MB)
    17. Whatif Tools
    • 1. Scenario Manager.mp4 (24.7 MB)
    • 2. Goal Seek.mp4 (13.8 MB)
    18. Text Based Functions
    • 1. LEFT(), MID() and RIGHT() Function.mp4 (28.8 MB)
    • 2. CONCATENATE() Function.mp4 (13.6 MB)
    19. Auditing
    • 1. Tracing Precedents and Dependents.mp4 (19.8 MB)
    • 2. Show Formulas feature.mp4 (14.4 MB)
    • 3. Grouping Data.mp4 (27.2 MB)
    • 4. 3D referencing in Excel.mp4 (27.7 MB)
    • 5. Freeze Pans.mp4 (32.3 MB)
    2. Values, Referencing and Formulas
    • 1. Labels and Entering Data.mp4 (16.9 MB)
    • 2. Formating Date Values.mp4 (25.9 MB)
    • 3. Getting Started with Formulas.mp4 (18.2 MB)
    • 4. Fill Handle.mp4 (11.8 MB)
    • 5. Relative vs Absolute Cell Reference.mp4 (24.4 MB)
    3. Getting Started with Excel Functions
    • 1. Introduction to Excel Functions.mp4 (11.2 MB)
    • 2. More on Excel Functions.mp4 (26.4 MB)
    • 3. AVERAGE Function, MIN Function and More.mp4 (21.9 MB)
    4. Adjusting Excel Worksheets
    • 1. How to Move and Copy Data.mp4 (11.6 MB)
    • 2. Inserting and Deleting Rows and Columns.mp4 (22.8 MB)
    • 3. Adjusting Width and Height of Columns.mp4 (17.8 MB)
    • 4. Hiding and Unhiding Rows and Columns.mp4 (12.3 MB)
    • 5. How to Make a Copy, Rename and Delete a Worksheet.mp4 (12.2 MB)
    5. Protection in Excel
    • 1. Protecting Worksheets and Specific Cells.mp4 (20.1 MB)
    • 2. Protecting Workbook.mp4 (9.7 MB)
    • 3. Encrypting Excel Workbook with a Password.mp4 (11.8 MB)
    6. Formatting to Make Cells Look Good
    • 1. Formatting Cells and Fonts.mp4 (22.0 MB)
    • 2. Formatting Numbers.mp4 (11.3 MB)
    • 3. Format Painter.mp4 (10.4 MB)
    • 4. Cell Styles.mp4 (16.2 MB)
    • 5. Merging Cells.mp4 (8.5 MB)
    • 6. Introduction to Conditional Formatting.mp4 (21.0 MB)
    • 7. More on Conditional Formatting.mp4 (21.6 MB)
    7. Inserting Shapes and Images
    • 1. How to Insert Shapes and Images.mp4 (23.0 MB)
    • 2. More on Shapes.mp4 (39.3 MB)
    • 3. Smart Art.mp4 (30.0 MB)
    8. Learn to use Charts
    • 1. Introduction to Charts.mp4 (16.2 MB)
    • 2. Formatting a Chart.mp4 (13.5 MB)
    • 3. Formatting Individual Elements of a Chart.mp4 (33.9 MB)
    • 4. More on Charts.mp4 (33.0 MB)
    • 5. Moving a Chart and Introduction to Pie Charts.mp4 (49.4 MB)
    9. Printing
    • 1. Introduction to Printing Options.mp4 (25.5 MB)
    • 2. Page Layout View.mp4 (27.3 MB)
    • 3. Headers and Footers.mp4 (17.8 MB)
    • 4. Printing Specific Cells.mp4 (18.2 MB)
    • Bonus Resources.txt (0.4 KB)

Description

Master Excel From Novice to Expert!



https://DevCourseWeb.com

Published 12/2022
Created by Peer Shaheen
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 85 Lectures ( 5h 5m ) | Size: 2.1 GB

From Beginner to Highly Advanced. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft Office 365

What you'll learn
Learn the Most Useful and Common Excel Functions
Sort large amounts of data
Learn Excel Pivot Table
Insesrting Shapes and Images
Learn to use Charts
Database Functions
Protection in Excel
Data Validation
Printing Options
Learn Tips and Trick in Excel to work efficiently
Learn to build formulas with functions like VLOOKUP, HLOOKUP, MATCH, INDEX, SUMIF AND MORE
SO MUCH MORE!!!

Requirements
No background knowledge required



Download torrent
2.1 GB
seeders:1
leechers:51
Udemy - Master Excel From Novice to Expert!
Loading...