Ultimate Microsoft Excel Course: Beginner to Excel Expert

سرفصل های دوره

Master Excel with this Complete Excel Course. Learn Everything Right Now (Workbooks and Real-World Exercises included).

01 - Introduction

001 Introduction to the Ultimate Excel Course

002 Download your Exercise Files.html

002 ultimate-excel-course-practise-files.zip

02 - Working with Large Worksheets

001 Keeping your Headings Visible as you Scroll

002 Splitting a Worksheet to Reference Two Different Areas

003 Hiding and Unhiding Columns

004 Sorting a Large List - Including a Super Shortcut

005 Filtering a List - One of the Most Useful Excel Skills you will EVER Need

03 - 5 Essential Tricks for Printing Spreadsheets

001 Scaling a Print to Fit onto Fewer Pages

002 Repeating your Headers Across Multiple Pages

003 Printing a Selected Range and Setting a Print Area

004 Aligning a Print on a Page

005 Using Page Breaks to Logically Break Up a Print

04 - Getting Started with Excel Formulas

001 Introduction to Formulas - Writing your First Excel Formulas

002 The Order of Calculation - BODMAS

003 Calculating Percentages

004 Unleash the Power of Excel Functions

005 Referencing other Sheets and Workbooks

006 Calculating Date Difference including Working Days Only

007 Understand Absolute Cell Addresses

008 The COUNTIF Function - An Incredibly Useful Function

009 Exercise 1 Writing Formulas.html

010 Exercise 2 Absolute References.html

011 Exercise 3 Using Functions.html

012 Exercise 4 Calculating Percentage IncreaseDecrease.html

05 - Logical Functions The Decision Making Formulas of Excel

001 IF Function 1 - Testing if a Value is Larger than a Specific Value

002 IF Function 2 - Testing if a Cell Contains Certain Text

003 IF Function 3 - Tracking Due Dates by Testing if they are Overdue

004 Using Multiple IF Functions - Nested IFs

005 AND and OR Functions for Testing Multiple Conditions

006 The IFS Function - No More Nested IFs

007 The SWITCH Function - Another Alternative to Complex Nested IFs

008 Exercise Logical Functions.html

06 - Conditional Formatting - Make your Data Come to Life

001 Create your First Conditional Formatting Rules

002 Managing Multiple Rules and Dealing with Conflicts

003 Conditional Formatting to Highlight Expired and Due Dates

004 Applying Data Bars to Compare Values or Show Progress

005 Create a Heat Map using Colour Scales

006 Using Icon Sets to Show Monthly Comparisons

007 Applying Conditional Formatting to the Entire Row

008 Testing Multiple Conditions with the AND Function

009 Exercise Working with Conditional Formatting.html

07 - Dynamic Array Functions - Formulas Have Changed

001 Introduction to Dynamic Arrays

002 The UNIQUE Function

003 The SORT Function - Sort Formula Results Automatically

004 The SORTBY Function - Sort by Any Column

005 The FILTER Function - Lookup and Return Multiple Values

006 The SEQUENCE Function

08 - Lookup Functions - The Powerful VLOOKUP Function and beyond

001 The VLOOKUP Function Explained

002 Using VLOOKUP for a Range Lookup

003 Advanced VLOOKUP with a Dynamic Column Index Number

004 Handling Error Messages with Lookup Formulas

005 A Versatile Lookup Formula - The INDEX and MATCH Combo

006 Two Way Lookup using INDEX and MATCH

007 Return Non-Adjacent Columns in an Array with INDEX and MATCH

008 XLOOKUP Function - The Successor to VLOOKUP and HLOOKUP

009 Multi-Column Lookup with XLOOKUP

010 Two-Way Lookup with XLOOKUP

011 Exercise Using the VLOOKUP Function.html

09 - Validating and Protecting Excel Data

001 Validate the Number of Characters

002 Create Date Validation Rules

003 Drop Down Lists for Easy Data Entry

004 Dependent Lists to Break up Large Lists

005 Create Custom Data Validation Messages

006 Encrypt a File from Unauthorised Access

007 Protect the Structure of a Workbook

008 Protect the Data on a Worksheet

009 Exercise Validating Data Entry.html

10 - Advanced Formulas for Analysing Data

001 Using SUMIF, COUNTIF and AVERAGEIF

002 Summing the Values between Two Dates

003 An Advanced Sum Formula with SUMPRODUCT

004 Summing Values by a Specific Weekday - SUMPRODUCT Example 2

005 The Secret AGGREGATE Function

006 An Advanced Array Example of AGGREGATE

007 Exercise Analysing Data with Formulas.html

11 - Charts - Simple and Effective Data Presentation

001 Creating your First Charts

002 Adding and Removing Chart Elements

003 Formatting Charts

004 Modify the Chart Axis

005 Save Time with Chart Templates

006 Combo Charts - Two Chart Types in One Chart

007 Chart Filters

008 Interactive Charts Change Chart Data with a Drop Down List

009 Using Cell Values for Chart Labels

010 Conditional Formatting with Charts

011 Using Sparklines for Quick Data Insights

012 Exercise Working with Charts.html

12 - Manipulating Text in Excel

001 Splitting Text across Multiple Columns

002 The CONCAT and CONCATENATE Functions

003 The TEXTJOIN Function

004 Extracting Text from a cell

005 Using the MID and FIND Functions Together

006 The VALUE Function

007 The SUBSTITUTE Function to Fix a Common Dependent List Problem

008 The Awesome Flash Fill Tool

009 Exercise Text to Columns.html

010 Exercise Extracting Data with Text Functions.html

13 - Formatting your Data Ranges as Tables for Easier Management

001 Formatting your Data Range as a Table

002 Exploring the Benefits of using Tables

003 Creating your own Table Style

004 Formulas using a Tables Structured References

005 Converting a Table back to a Normal Range

006 Exercise Managing Data with Tables.html

14 - Master PivotTables for Powerful Analysis and Reporting

001 Creating a PivotTable

002 Changing the Values Function

003 Formatting Values the Efficient Way

004 Creating a PivotTable Style

005 Sorting PivotTable Fields

006 Grouping Data in a PivotTable

007 Showing Values as a Percentage, Difference From and Ranking

008 Conditional Formatting with PivotTables

009 Filtering PivotTable Data

010 Refreshing a PivotTable

011 Creating a PivotChart

012 Using Slicers for Interactive PivotTables

013 Using the Timeline Slicer

014 Exercise Using PivotTables.html

015 Exercise 2 Using PivotTables.html

15 - Getting and Transforming Data with Power Query

001 What is Power Query

002 Installing the Power Query Add-In - Excel 2010 and Excel 2013 Only.html

003 Transforming Messy Data on a Worksheet - First Example of Power Query Magic

004 The Incredible Unpivot Feature of Power Query - Real Game Changer

005 Working with International Dates and Number Formats

006 Merge Queries - A VLOOKUP Alternative

007 Merge Queries - Exploring other Join Types

008 Combine and Append Multiple Worksheets into One

009 Importing Multiple Files from a Folder into One List - Incredibly Useful

010 Importing Data from the Web

011 Exercise Import & Transform Text File.html

012 Exercise Import Data from the Web.html

16 - Working with the Data Model and PowerPivot

001 Introduction to the Data Model and PowerPivot

002 Adding Tables to the Data Model and Creating Relationships between Tables

003 Creating a PivotTable from the Data Model

004 Enabling the PowerPivot Add-In

005 Exploring the PowerPivot Window

006 Introduction to DAX - Calculated Columns

007 Introduction to DAX - Measures

17 - Introduction to Macros and VBA

001 Recording your First Macro

002 Assigning your Macro to a Toolbar Button

003 Customising the Ribbon to Add your Macro Buttons

004 Editing your Macro Code 1

005 Using Relative References when Recording a Macro

006 Saving a Workbook Containing a Macro

007 Editing your Macro Code 2

008 Adding a Button to the Worksheet to Run your Macro

18 - Getting Started with Writing VBA

001 Introducing the Visual Basic Editor

002 Writing your First Macro

003 Cleaning Recorded Code

004 Working with Method Arguments

005 Referencing Cells, Worksheets and Workbooks in VBA

006 Errors in VBA

007 Exercise Recording & Editing Macros.html

008 Exercise Answer Recording & Editing Macros

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy