+- Forum Rockoldies (https://rockoldies.net/forum)
+-- Forum: Fotobearbeitung - Photoshop (https://rockoldies.net/forum/forumdisplay.php?fid=16)
+--- Forum: E-Learning, Tutorials (https://rockoldies.net/forum/forumdisplay.php?fid=18)
+--- Thema: Microsoft Excel Masterclass - Introduction to Advanced (/showthread.php?tid=28474)
Microsoft Excel Masterclass - Introduction to Advanced - Panter - 18.06.2021
![[Bild: vb9kgeb4uo4hvcbjuna7hlojit.jpg]](https://abload.de/img/vb9kgeb4uo4hvcbjuna7hlojit.jpg)
Microsoft Excel Masterclass - Introduction to Advanced
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.5 GB | Duration: 13h 9m
Master Excel Spreadsheets and Become An Expert At Charts, Tables, Formulas and Functions. Get Started today!
What you'll learn
Master Microsoft Excel from Beginner to Advanced.
Take your spreadsheet skills from ZERO to PRO with Charts, Tables, Formulas, Functions and many more.
Learn how to automatically link cells to streamline and revolutionise your workflow in Excel.
Get LIFETIME access to Excel tutorials taught by a professional trainer with 10+ years of Excel experience.
Create dynamic spreadsheets by mastering Excel's most popular features.
Create professional looking charts from your own computer.
Description
__________
Course Overview:
Are you looking to build your skills in using Microsoft Excel?
This course gives you a deep understanding of how to use some of the most popular features and functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions.
In this course we will cover Excel Introduction, Intermediate, Advanced and Formulas and Functions. Most lectures are 7 - 14 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 10 years throughout the UK.
__________
Excel Introduction Outline:
The Excel Environment
Select and Highlighting Cells
Entering Information
Formatting Information
Modifying Information - Wrap Text and Merging Cells
Inserting/Deleting Columns and Rows
Save, Save As and Open
Find Opening and Closing Excel
Creating and Copying Formulas
Using BODMAS in Formulas
Absolute Cell Referencing
Using Functions - SUM, IF, COUNT, AVERAGE
AutoSum Features
Difference between Excel manual and automated calculations
Creating and Formatting Charts
Inserting, Moving and Deleting Worksheets
Grouping Worksheets
AutoFill Feature
Linking formulas between Worksheets
Freeze Panes
Print Area and Print Preview
__________
Excel Intermediate Outline
Paste special features
Charts and Formatting Charts
Conditional Formatting and Conditional Formulas
Security (adding protection)
Sub totalling information
Filtering and advanced filtering
Named cells, ranges and using names in formulas
Database functions
Linking formulas & functions
Mixed reference formulas
Auditing Formulas
Freeze Panes
Printing using freeze panes and Print Area
__________
Excel Advanced Outline
Advanced Charts and Linking Charts to Other Applications
Scenarios
Data Tables
Goal Seek
Data Validation
Pivot Tables
Formulas & Functions
Consolidated Formulas
Date Formulas and Functions
Referencing Formulas
Error Functions
Logical Functions (IF, AND, OR)
Nested Functions (IF, AND, OR)
Lookup Functions (VLookup, HLookup)
Mathematical Functions (Sumif, Sumifs)
Statistical Functions (Countif, Countifs, Averageif, Averageifs,
Countblank)
Text Functions (Trim, Left, Right, Mid, Concatenate)
__________
Excel Formulas and Functions Outline
Creating Date Formulas
Now
Day
Month
Year
Vlookup
Hlookup
Match and Index
IFError
IF
And
or
Not
IF, AND, OR
IF & Vlookup
IF & Sumif
Sumif
Sumifs
Countif
Countifs
Averageif
Averageifs
Countblank
DSum
DAdverage
DMax
DMin
Trim
Left
Right
Mid
Concatenate
__________
Excel Advanced Filtering and Pivot Tables
Multi Filters
Filtering by Colour
Custom Filters
Criteria Filtering (i.e. Greater Than, Less Than, Between, Not Equal To)
Multi Criteria Filtering (Advanced Filter)
Multi Criteria Filtering "In Place" and "Copy of another Location"
Designing and Creating a Pivot Table
Modifying a Pivot Table Layout
Updating a Pivot Table and using Pivot Table options
Managing Pivot Table Totals and Sub Totals
Grouping Pivot Table Data
Creating a Pivot Table using External Data
Filtering Pivot Tables using Slicers and Timelines
Pivot Table "Dashboards" using Slicers
Creating Multiple Pivot Tables on the same sheet
Consolidating Pivot Table Data
Pivot Table calculations
Pivot Table Report pages
Linking using the GETPIVOTDATA function
Creating Pivot Charts and Modifying Pivot Charts
Filtering Pivot Charts
__________
Excel Data Visualised and Data Formatting
Highlight Cell Values i.e. Find Duplicates
Top and Bottom Rules
Data Bars
Colour Scales
Icon Sets
Sum Function
Average Function
And / OR Functions
Formulas and Cell Referencing
Conditional Formatting Date Formulas
Now Function
Managing and Deleting Conditional Formatting Rules
Conditional Formatting and Data Validation
Conditional Formatting and Paste Special
Adding Conditional Formatting settings to empty cells
Conditional Formatting and Linked Data
Adding Sparklines
Formatting and Modifying Sparklines
Whether you're looking for a quick overview on some of Excel's most popular features trying to diversify your Excel skill set, or hoping to step up your spreadsheet game in a major way, you've come to the right place. In today's increasingly data-driven world, Excel makes it easy and intuitive to keep track of data sets. Enrol today and start your journey to becoming a Excel master!
See you there!
-Richard Walters (Microsoft Excel Trainer)
Who this course is for:
ANYONE who works with Excel on a regular basis (even if you've never used it before!)
Excel users who have basic skills but would like to become more proficient in using spreadsheets.
Students looking for a comprehensive, engaging, and highly interactive approach to training.
Homepage
Code:
https://anonymz.com/?https://www.udemy.com/course/microsoft-excel-masterclass-introduction-to-advanced/![[Bild: 011vlookupandhlookupsaykco.jpg]](https://abload.de/img/011vlookupandhlookupsaykco.jpg)