Excel Basics

Beskrivelse af kurset:

In Excel basics training you will learn how to use Excel effectively in everyday use. Training starts for a beginning and it gives good tips for effective and correct use of Excel. Participant will learn how to format tables effectively and how to create visual Excel tables and charts. Basic calculation, use of a basic functions and information how to input data correctly in Excel are also included in this course. This training is for users who are just starting to use Excel or for those who wants to enhance their Excel skills.

Videoindhold

Files and applications1/9

Lektion1.1 Excel file formats 3 min
Lektion1.2 Downloads 5 min
Lektion1.3 Application overview 5 min

Cells and Content2/9

Lektion2.1 Formula bar and cell content 6 min
Lektion2.2 Selecting cells 5 min
Lektion2.3 Add, modify and erase data in cells 4 min
Lektion2.4 Find and Replace 4 min

Databases3/9

Lektion3.1 The three important rules of a database 2 min
Lektion3.2 Sorting 4 min
Lektion3.3 Custom sort 4 min
Lektion3.4 Filtering data 2 min
Lektion3.5 Freeze panes feature 7 min

Editing content4/9

Lektion4.1 Copy, cut and paste 2 min
Lektion4.2 Move and copy data with your mouse 4 min
Lektion4.3 Paste options aka Paste Special 3 min
Lektion4.4 Pasting a link 5 min
Lektion4.5 Auto fill feature 3 min
Lektion4.6 Copying formats with Format painter and Autofill 4 min
Lektion4.7 Clearing and removing cells 4 min
Lektion4.8 Flash fill 6 min

Cell formatting5/9

Lektion5.1 Formatting large numbers and decimals 3 min
Lektion5.2 Currency formats 3 min
Lektion5.3 Percentage format 6 min
Lektion5.4 Date format and how Excel understands dates 6 min
Lektion5.5 Time and duration formats and how Excel understands time 5 min
Lektion5.6 Text format and the problem with adding numeric codes 2 min

Font features6/9

Lektion6.1 Font features 4 min
Lektion6.2 Cell alignment, Wrap text and Merge and center 4 min
Lektion6.3 Cell colors and borders 2 min
Lektion6.4 Cell Styles 4 min
Lektion6.5 Database colors with Format as Table 6 min

Calculation and Functions7/9

Lektion7.1 Basic reference calculation 2 min
Lektion7.2 Copying calculations with the autofill 4 min
Lektion7.3 Basic error codes 8 min
Lektion7.4 Relative and absolute cell references 6 min
Lektion7.5 Creating functions 5 min
Lektion7.6 Using quick functions 5 min
Lektion7.7 If-function 8 min
Lektion7.8 The SumIf and SumIfs -functions 6 min
Lektion7.9 References between worksheets and workbooks 4 min

Charts and visualizations8/9

Lektion8.1 Creating a chart 4 min
Lektion8.2 Chart styles and colors 5 min
Lektion8.3 Filtering and adding data to a chart 3 min
Lektion8.4 Sparkline graphs 4 min
Lektion8.5 Conditional formatting 2 min
Lektion8.6 Quick analysis tools 5 min

Dynamic Tables and DAX9/9

Lektion9.1 Dynamic Tables with the Format as Table feature 6 min
Lektion9.2 Slicers 3 min
Lektion9.3 Total row 4 min
Lektion9.4 Basic DAX calculation 6 min
Lektion9.5 DAX Functions - Sum and Subtotal 6 min
Lektion9.6 DAX Functions - SumIf and SumIfs

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.