Learn Basic Excel Skills For Beginners

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data

4.5

4093

GRATIS

$49.99

Cup��n Expirado

Productividad en la oficina Microsoft

Comparte si te a gustado:

Learn Basic Excel Skills For Beginners

Publicado en 31 Mar 2021

Lo que aprenderás

Enter data in a spreadsheet

Save and open spreadsheet

Create formulas and functions

Format rows, columns, cells, and data

Align text in a cell

Adjust rows and columns

Find and replace data

Insert and delete sheets

Sort data

Add Borders and Fill Colours

Use Number Formatting

Use AutoSum

Insert Functions

Requisitos

You should be able to use a PC at a beginner level

Descripción

Microsoft Excel is a powerful tool essential for managing and presenting data

in today’s working environment. In this one day excel course,
you will gain the knowledge and skills required to create and edit worksheets, use formulas
and functions, sort and filter detail data visually, and present summary information
in a consumable and professional format.

What You Will Learn Include:

What is Office 365
Setting up Office 365
Excel 2016 user interface
Exploring the Excel Ribbon
Customizing the Quick Access Toolbar
Keeping Tabs on the Ribbon
Entering Data
Opening a new workbook
Entering Data in Excel
Basic Data entry
Entering Data with Autofill
Entering Date
Entering Time
Undo and Redo Changes
Adding Comments
Giving your worksheet a title
Saving your work
Creating Formulas and Functions
Using formulas for arithmetic tasks
Re-using Formulas
Calculating YTD Profits
Calculating Percentage Change
Using Relative and Absolute Reference
Using RANK Function
STD Function
Small and Large Functions
Median Function
Count and counta functions
Formatting
Exploring Fonts
Adjusting Column Width and Row Height
Using Alignment
Designing Borders
Formatting Numbers
Conditional Formatting
Creating Tables
Inserting Shapes

After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.

¿Para quién es este curso?

Beginners to spreadsheets and excel

Those who need a refresher to excel.

Debes tener en cuenta que los cupones duran maximo 4 dias o hasta agotar 1000 inscripciones,pero puede vencer en cualquier momento. Obten el curso con cupon haciendo clic en el siguiente boton:

(Cupón válido para las primeras 1000 inscripciones): D9A0ED928649A68C53B6

Obtener Cupón Mas Cursos

Tags: