Książka - Kurs Programowania w PKP5

Excel 2013 course from scratch - ON-LINE version

Index: KRW-12643 EAN: 5904422341312
BOTLAND B. DERKACZ SPÓŁKA JAWNA Opinie z ekomi-pl.com

The course is designed for people who want to master all the key tools of Excel from scratches. Even if you already know the basics of the program, this course is still a good choice: it's a great occasion to summarize the already gained knowledge and to get to know the new tools and methods that will allow you to work more efficiently.

€22.28
€18.11 tax excl.

Available online!
(Check quantity)
Shipping in 24 hours
30-day returns
PayPal payment
Manufacturer: Strefa kursów

What will you learn?

  • You want to master a program that is the primary tool work for thousands of companies or institutions?
  • You nedd to know the Excel to use it in company, school, or home?
  • You need a course that will explain all the important tools of the program in the easiest way possible?
  • You are trying to learn Excel using various helps but you still have problems understanding some concepts?
  • Or maybeyou already know the basics and you want to be reminded of the most important methods of work or to get to know the new solutions to common problems?

Who is this course for?

The course is designed for people who want to master all the key tools of Excel from scratches. Even if you already know the basics of the program, this course is still a good choice: it's a great occasion to summarize the already gained knowledge and to get to know the new tools and methods that will allow you to work more efficiently.

Kurs esxcel 2013

What will I learn from this course?

With this course, you will learn Excel in literally one evening. You will receive the knowledge which is necessary for every user of the program. What you will learn, you can use in practice no matter what you do for living. What is important, the obtained knowledge can be developed in any direction.

Excel 2013 - kurs

What is included in the course?

The course contains 37 video lessons that will explain all the key tools of the program. We will start with the basic issues: we will show the main elements of the interface and we will discuss creating and saving documents. Then, we will deal with various methods of data entry. In subsequent chapters, you will learn the most important things in Excel, that is using functions and creating formulas. Then, we'll move on to discussing different methods of formatting.

Kurs ONLINE Excel

The next important topic is changing the sheet's structure. To master the technique of insertion, concealment, moving and deleting rows and columns. We'll show you also how to insert a table, picture, how to create graps, how to register the macros, how to prepare a document for printing and much more. All the materials we use, we have included in the course. Due to this, every action that is shown on the display, you can easily repeat.

What else you should know?

In the course, we work on the latest version of Excel 2013, but practically, all knowledge can be used to work on earlier versions.

Kurs excel - co warto wiedzieć

Work quickly and efficiently

Explore the interface of the Microsoft Excel 2013 so that your work could be done without obstacles.

Master the data entry

Explore methods of data entry that you can use in any situation.

Perform any calculations

With the course, you will learn to create formulas and use many functions, thanks to which, you will easily make any calculations.

The contents

1.The Basics Of Excel

  • Interface of Excel4m 58s - see a free lesson
  • The quick access toolbar 4m 08s
  • The structure of the worksheet and of the folder 3m 18s
  • Navigation in the sheet3m 18s
  • Creating the new documents2m 37s
  • Saving the documents3M 34s


2.Data entry

  • The most important ways of entering data4m 37s
  • Filling with the data series5m 31s
  • Entering the date and time,2m 55s
  • Undoing changes3M 34s
  • Add comments 3M 51s

 

3.The basics of formulas and functions

  • Creating a simple formula5m 18s
  • Autosummary 5m 15s
  • Absolute addressing4m 15s
  • Useful functions4m 55s - see a free lesson
  • Function IF3M 54s
  • Function TOTAL.IF4m 58s

4.The basics of formatting

  • Resizing the columns and rows3m 10s
  • Alignment of content3M 54s
  • The framings of the cells3M 57s
  • Cell formats6m 40s
  • Arrays 6m 15s
  • Conditional formatting6m 59s
  • Adding the graphical elements5m 11s

 

5.Editing the sheet's structure

  • Inserting and deleting the columns and rows5m 03s
  • Changing columns to rows3m 05s
  • Hiding the sheet's elements2m 54s
  • Moving and copying the data4m 45s
  • Finding and replacing the data5m 26s

 

6.Databases functions 

  • Sorting5m 53s
  • Filtering4m 48s
  • Subtotals4m 52s
  • Splitting data into columns2m 49s
  • Removing the duplicates2m 43s
  • Merging the contents of columns2m 59s

 

7.Working with sheets and documents

  • Locking the rows and columns2m 50s
  • Viewing multiple sheets3m 16s
  • Adding, deleting, moving, grouping5m 22s
  • Formulas using multiple sheets3m 15s
  • Referencing to files3m 46s
  • Splitting the screen view 3m 30s
  • Conspectus and grouping4m 05s

 

8.Graps

  • Creating a simple graph 4m 55s
  • Different types of graphs 5m 19s - see a free lesson
  • Formatting a graph 4m 16s
  • Time graphs 4m 59s

 

9.Print

  • Tab "Page layout"7m 19s

10.Macros

  • Recording a macro7m 35s
  • Running the macro 6m 03s
  • Conclusion 0m 42s

Same-day shipping

  • Crediting the payment for the order on our account on a business day before 10:00 AM means sending the goods on the same day.
  • All packages are being delivered by GLS Group courier and covered with insurance up to 1200 EUR.
  • You will receive a link to track your package and monitor the progress of delivery as soon as it is shipped.

Terms of delivery 

GLS - zone 1

Austria, Belgium, Croatia, The Czech Republic, Denmark, Germany, Netherlands, Poland, Slovakia 

  • Delivery time: 2-4 days
  • Delivery cost: from 4.18 EUR
  • Insurance: 1200 EUR
GLS - zone 2

Bulgaria, Estonia, France, Hungary, Italy, Latvia, Lithuania, Luxembourg, Portugal, Romania, San Marino, Slovenia

  • Delivery time: 2-5 days
  • Delivery cost: from 5.35 EUR
  • Insurance: 1200 EUR
GLS - zone 3

Finland, Greece, Ireland, Lichtenstein, Spain, Sweden 

  • Delivery time: 2-7 days
  • Delivery cost: from 7.67 EUR
  • Insurance: 1200 EUR

Payment methods

Card image cap
PayPal
  • Botland is a PayPal verified seller. Protect your financial information with this fast, safe and secure online payment system.

Card image cap
PayU
  • Choose easy and quick PayU e-payment method. Your financial information will stay secure.

Customers who bought this product also bought:

Basic computer course - ON-LINE version

Video course allows you to learn basic computer and Internet maintenance, it is for all people, regardless of age, who have a problem with that.
Index: KRW-09276
Index: KRW-09276
In stock, shipping 24 hours!
(Check quantity)
Regular price €11.03 Price €11.03

Products from the same category

Arduino StarterKit from scratch - with Arduino Uno module

A set of electronic components used in the video course "Arduino from scratch". The kit includes i.a.: LEDs, resistors, sensors, chips, and LCD display, the chassis of the...
Index: ARD-02596
Index: ARD-02596
In stock, shipping 24 hours!
(Check quantity)
Regular price €51.73 Price €51.73

Arduino video course - from the ground up - ON-LINE version

Video course is intended for novice Arduino users. Includes practical exercises on electronic circuits, the performance of which does not require a soldering iron. Electronic...
Index: KRW-02506
Index: KRW-02506
Available online!
(Check quantity)
Regular price €22.28 Price €22.28

Basic programming course for PLC controllers - ON-LINE version

The course is designed for people who know the basics of electrical engineering and want to master the basics of ladder language and enter the PLC world. In this course you...
Index: KRW-12702
Index: KRW-12702
Available online!
(Check quantity)
Regular price €20.03 Price €20.03

SketchUp course + V-Ray from scratch - ON-LINE version

This video course is designed for interior designers or those who are just planning to make a future for them.
Index: KRW-09614
Index: KRW-09614
Available, 24h shipping!
(Check quantity)
Regular price €31.28 Price €31.28

Video course Programming school in C language - ON-LINE version

The course is designed for beginners who want to quickly understand all the important C concepts and start creating their own programs. Classical C is a popular, versatile and...
Index: KRW-03303
Index: KRW-03303
Available
(Check quantity)
Regular price €22.28 Price €22.28

Android applications for non-programmers - ON-LINE

A video course showing the basics of creating Android applications. It does not require programming knowledge. It allows for the creation of games and programs from ready-made...
Index: KRW-08727
Index: KRW-08727
In stock, shipping 24 hours!
(Check quantity)
Regular price €17.78 Price €17.78

Android course - creating applications in practice - ON-LINE version

The course is designed for people who have finished the basic course of creating an application in Android, and want to expand their knowledge. This course describes how to,...
Index: KRW-09977
Index: KRW-09977
No scheduled product deliveries
Regular price €24.53 Price €24.53

Python programming foundations course - ON-LINE version

This course is designed for people who start programming in Python. With this course you will learn the basics of Python syntax, programming in the current version 3, the right...
Index: KRW-12225
Index: KRW-12225
Available, 24h shipping!
(Check quantity)
Regular price €20.03 Price €20.03

Java Foundation course - ON-LINE version

With this course, you will learn the most important elements of the language, you will see how to properly configure IDE and text editor, you will learn to use the basic...
Index: KRW-09288
Index: KRW-09288
In stock, shipping 24 hours!
(Check quantity)
Regular price €26.78 Price €26.78

GIMP course from scratch - ON-LINE version

A video course explaining the use of Gimp and the secrets of editing graphics. It will learn how to edit and improve images, show how to work with layers, masks, filters and...
Index: KRW-08607
Index: KRW-08607
Available, 24h shipping!
(Check quantity)
Regular price €20.03 Price €20.03

Basic computer course - ON-LINE version

Video course allows you to learn basic computer and Internet maintenance, it is for all people, regardless of age, who have a problem with that.
Index: KRW-09276
Index: KRW-09276
In stock, shipping 24 hours!
(Check quantity)
Regular price €11.03 Price €11.03

Unity course - making 2D games - ON-LINE version

A course to learn and understand the 2D game development process and build games for mobile devices using the Unity environment.
Index: KRW-09998
Index: KRW-09998
Available, 24 hours shipping!
(Check quantity)
Regular price €20.03 Price €20.03