Excel kurs gratis

This video covers two detailed examples of creating dynamic charts from scratch.

Example 1 – Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.

Example 2 – Creating a dynamic chart that plots the data on a scatter chart based on the column you select.

Internet och registrering krävs (Microsoft-konto). These videos can not be downloaded.

However, this FREE Excel training is available to watch as many times as you want.

Which version of Excel is used to create this course?

I have used the Excel 2013 to record these videos.

Almost everything covered in this free course will work for all the Excel versions (2007, 2010, 2013, 2016, 2019, and even Excel 365).

There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013)

Who is the instructor of this Excel training?

My name is Sumit Bansal and I am your instructor throughout this FREE online Excel training.

I have practically been in a relationship with Excel since 2007.

Vill du automatisera Excel, gå kursen i VBA-makron, lär dig Python för Excel eller använd Office Scripts.

Google Kalkylark

Google Kalkylark (Sheets) är en onlinetjänst som täcker många av Excels grundläggande funktioner och verktyg, men långt i från alla - i synnerhet saknas många avancerade pivottabellfunktioner och stöd för tabeller. This training is completely free and covers most of the Excel topics you need to get started and become a pro.

You get to watch each and every lesson absolutely free (and as many times as you want).

All you need is a decent internet connection.

Can I download the videos?

No, you can only watch the videos online.

Den har de flesta av funktionerna och en del av verktygen från standard-Excel. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.

MODULE 6 – PIVOT TABLE

Lesson 24 – Overview of Excel Pivot Table

⬇️ Click here to download the example Excel file

In this video of this Free training, I will show you how to create and use Pivot Tables in Excel. 

The video covers the following topics:

• Introduction to Pivot Tables
• Creating a Pivot Table in Excel
• Formatting the Pivot Table
• Grouping data in an Excel Pivot table
• Calculated Field/Items in Pivot Table
• Pivot Table Slicers
• Pivot Charts

Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks.

Kan automatiseras med VBA-makron (bara delar av VBA), samt Libreoffice Basic och Python.

Staroffice Calc

Staroffice Calc är ett kalkylprogram som liknar äldre versioner av Microsoft Excel och kan köras på alla plattformar som stöder Java.

Apache Open Office Calc

Apache Open Office Calc är ett kalkylprogram som liknar äldre versioner av Microsoft Excel och kan köras på alla plattformar som stöder Java.

In case you want to learn more, click here to check out all my Pivot Table tutorials.

This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section.

Related Excel Articles:

MODULE 6 – EXCEL EXTRAS

Lesson 25 – Protection in Excel

In this video of this Free Excel training, I will show you how you can lock cells or protect worksheets and workbooks in Excel.

You can protect cells, worksheets, and workbooks in Excel with a password (or without one).

Därför har vi skapat en plattform med dig som användare i fokus. Now you can run this code and Excel will automatically follow all the steps you showed it.

If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn.

This video lesson covers the following VBA topics:

• How to record a macro in Excel
• Absolute and Relative Cell References
• Introduction to the Visual Basic Editor.

Related Excel Articles:

• Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit)
• Working with Worksheets using Excel VBA
• Using Workbook Object in Excel VBA (Open, Close, Save, Set)
• Understanding Excel VBA Data Types (Variables and Constants)
• Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples)
• If Then Else Statement in Excel VBA (explained with examples)
• For Next Loop in Excel VBA – A Beginner’s Guide with Examples
• How to Assign a Macro to a Button in Excel

ABOUT THE INSTRUCTOR

I am Sumit Bansal, your instructor for this Excel Training.

Kan automatiseras med Google Apps Script-makron.

I kurserna belyser vi viktiga skillnader mellan Excel och de andra programvarorna.

 Lär dig mer med våra Excel-, VBA- och automatiseringskurser – börja i dag! And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.

It covers the following topics:

• Excel Chart Types
• Chart Editing
• Formatting Chart Elements
• Combination Charts
• Handling Gaps in Charts

Related Excel Articles:

Lesson 22 – 10 Advanced Excel Charting Examples

⬇️ Click here to download the example Excel file

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.

The following advanced charts are covered in this video:

Related Excel Articles:

Lesson 23 – Dynamic Charts in Excel

⬇️ Click here to download the example Excel file

In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.

Dynamic charts allow you to change the chart based on user selection.

Kan automatiseras med Apache Open Office Basic.

OnlyOffice

OnlyOffice är kostnadsfritt och öppen källkod och finns för desktop, molnet och mobilen.