• views: 100
• date: 27 September 2023
• posted by: voska89

In this course you will learn about the basic Excel skills all the way to the advanced tools and functions.
Learn how to use cells, the ribbon and work with rows and columns. Work with charts, tables, shapes and use filtering and formatting.
Learn Formulas for functions such as sum, sumif, countif, average, index, match, and more.
Learn how to sort information on tables or on different sheets.
Learn how to use and edit shapes and edit imported pictures.
Learn multiple shortcuts and how to review your work.
Instructions will be spoken and there will also be text on screen for each step.
Requirements
Know how to open Excel and the basics of using a computer. The course will even show you how to open a new workbook in Excel.
Description
Learn about the basics, such as opening a new workbook, using the ribbon and using cells and sheets.
Learn the commonly used formulas and functions to solve mathematical problems and figure out values.
Learn how to use Tables, Pivot Tables, filtering information and formatting cells.
Learn about Text tools, colors, gradients and effects.
Learn how to use the Data Tools.
Learn how to insert shapes and images and add effects to them and change colors.
Learn how to create and use Charts.
Learn how to use Concatenate, Consolidate, Flash fill and make drop down lists.
Learn how to use What if Analysis tools (Data tables, Goal seek and Scenario Manager)
Learn how to create a timeline.
Learn how to use the Query feature.
Learn about reviewing your work and using basic features like zoom and checking spelling.
Learn shortcuts that allow you to do work quicker.
Includes 10 Practice Assignments and Quizzes.
Course is in English with English text instructions on screen during videos.
Who this course is for
Beginner and Intermediate Excel users. Those who want to learn about using spreadsheets to store and edit information.
Homepage

https://www.udemy.com/course/microsoft-excel-2016-basic-and-advanced-skills-and-tools

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.