Excel Advanced

Beskrivelse af kurset:

In the this Online course you will become familiar with the most important features of Excel in advanced use. You will learn how to import data from different sources and analyze it with functions, Take a look at Xlookup, Vlookup and Sumifs – functions and how to use functions inside of a function. You also learn how to use dynamically spreading references and functions and how to produce reports and analysis with Pivot-tools.

Videoindhold

Advanced tools1/8

Lektion1.1 Naming Cells 3 min
Lektion1.2 Downloads 6 min
Lektion1.3 Custom Cell Formatting 3 min
Lektion1.4 Paste Special 5 min
Lektion1.5 Go To Special 3 min

Worksheets2/8

Lektion2.1 Hiding Columns And Rows 3 min
Lektion2.2 Grouping Columns 1 min
Lektion2.3 Hiding Worksheets 4 min

Protecting your workbook3/8

Lektion3.1 Protecting The Workbook And The Worksheet 4 min
Lektion3.2 Protecting The Workbook With Mark As Final, Read-only And Password Options 3 min
Lektion3.3 Partially Protecting Your Sheet 6 min

Functions4/8

Lektion4.1 Time-functions Year, Month, Isoweeknumber, Day, Networkdays 5 min
Lektion4.2 Round And Rounddown Functions 3 min
Lektion4.3 Text-functions Left, Mid And Right 7 min
Lektion4.4 Vlookup Function 7 min
Lektion4.5 Xlookup Function 3 min

Dynamic Functions5/8

Lektion5.1 Dynamic References 3 min
Lektion5.2 Unique Function 4 min
Lektion5.3 Filter Function 5 min

Combining functions6/8

Lektion6.1 Combining Functions Sort And Unique 3 min
Lektion6.2 Combining Functions Iferror And Averageifs 7 min

Creating A Pivot Table7/8

Lektion7.1 Creating A Pivot Table 5 min
Lektion7.2 Grouping Dates In Pivot Tables 3 min
Lektion7.3 Cell Formats And Text In Pivot Tables 5 min
Lektion7.4 Pivot Tools - Sorting, Filtering, Slicers And Timelines 6 min
Lektion7.5 Pivot Table Layout - Grand Totals, Subtotals, Report Layout And Blank Rows 3 min
Lektion7.6 Pivot Table Summarize Functions 6 min
Lektion7.7 Show Values As Tools In Pivot Tables 5 min
Lektion7.8 Creating A Pivot Chart 6 min

Advanced charts8/8

Lektion8.1 Creating An Updating Combo-chart With Unique And Sumifs Functions 4 min
Lektion8.2 Creating A Sunburst Chart From A Pivot Table 6 min
Lektion8.3 Creating A Gantt-chart

Underviser:

Pertti Berg Digiskills Content Unit Manager

Eduhouse's CLO Pertti Berg. He has worked as an IT trainer and information security expert for 18 years and has completed CISSP certification in information security.