¡81% de ahorro!
OfCourse

Microsoft Excel For Business

OfCourse
Online
Precio Emagister

112 € 22 
*Precio Orientativo
Importe original en GBP:
£ 99  £ 19

Información importante

Tipología Curso
Metodología Online
Inicio Fechas a elegir
  • Curso
  • Online
  • Inicio:
    Fechas a elegir
Descripción

Microsoft Excel for Business will take your Excel to the next level, and allow you to impress your boss or keep driving your business forward. This course will provide a masterclass in advanced excel skills which will allow you to master powerful analytics tools and present data in new and exciting ways.Leading you through this course will be Chris Dutton, the founder of Excel Maven whose passion for Excel led to him to become a Certified Microsoft Excel Expert. Chris specialises in using innovative, hands-on online courses to get students up to speed and has taught thousands of students in the past seven years to use Excel like a master.This course starts with detailed instructions on how to master Excel Formulas and Functions, with sections dedicated to Lookup/Reference functions, Statistical functions, Formula based formatting, Date & Time functions and many more. Chris will then move on to how to use those functions in a creative way through Advanced Charts and Graphs.If you want to master Excel and banish those spreadsheet fears take this course today!

Información importante
¿Qué objetivos tiene esta formación?

118 lectures with 10 hours of video content
Nearly 100 downloadable PDF slides and Excel Project files to enhance your learning
Free quiz to help you consolidate your learning
Develop a mastery of basic and advanced excel skills
Learn how to master formula, functions, charts and graphs
Master functions such as SUMPRODUCT, COUNTIFS, VLOOKUP, CONCATENATE, HYPERLINK and many more!
PLUS easy keyboard shortcuts to increase your productivity and speed - both PC and Mac! 

¿Esta formación es para mí?

Anyone

Precio a usuarios Emagister:

Requisitos: None

Instalaciones (1) y fechas
Dónde se imparte y en qué fechas
Inicio Ubicación
Fechas a elegir
Online
Inicio Fechas a elegir
Ubicación
Online

¿Qué aprendes en este curso?

Excel
Options
Auditing
Microsoft Excel
Spreadsheet
IT Auditing
Syntax
Driving
Anatomy
Project
Microsoft excel training
MS Excel
Mac

Temario

Introduction to Formulas and Functions
Intro
Say hi to your fellow students!
Share your new course with your friends!
Course Structure & Outline

Excel Formulas 101
Introduction
Handout - Formulas 101
Excel Download - Fixed Relative References
The Formula Library & Auditing Tools
Basic Formula Syntax
Fixed, Relative, & Mixed References
Common Errors & the IFERROR statement
Function, CTRL & ALT Shortcuts
Handout - Mac Shortcuts
BONUS: Shortcuts for Mac Users
Creating Custom Data Validation Rules
Fixed vs. Volatile Functions

Logical Operators
Introduction
Handout - Logical Operators
Excel Download - Logical Operators
Anatomy of the IF Statement
Nested IF Statements
AND/OR Operators
NOT vs. \\"
Fixing Errors with IFERROR
Common IS Statements

Statistical Functions
Introduction
Handout - Statistical Functions
Excel Download - Statistical Functions
Basic Statistical Functions
SMALL/LARGE & RANK/PERCENTRANK
RAND() & RANDBETWEEN
The SUMPRODUCT Function
COUNTIFS/SUMIFS/AVERAGEIFS
PROJECT SHOWCASE: Building a Basic Dashboard with COUNTIFS & SUMIFS

Lookup/Reference Functions 1
Introduction
Handout - Lookup/Reference Functions
Excel Download - Lookup/Reference Functions
Working with Named Arrays
ROW/ROWS & COLUMN/COLUMNS
VLOOKUP/HLOOKUP
Joining Data with VLOOKUP
Fixing Errors with IFERROR & VLOOKUP
VLOOKUP Reference Array Options
The INDEX Function
The MATCH Function
Using INDEX & MATCH together
Combining MATCH with VLOOKUP
The OFFSET Function
PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart

Lookup/Reference Functions 2
The INDEX Function
The MATCH Function
Using INDEX & MATCH together
Combining MATCH with VLOOKUP
The OFFSET Function
PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart

Text Functions
Introduction
Handout - Text Functions
Excel Download - Text Functions
UPPER/LOWER/PROPER & TRIM
The CONCATENATE Function (&)
LEFT/MID/RIGHT & LEN
TEXT/VALUE
SEARCH/FIND
Categorizing Data with IF(ISNUMBER(SEARCH))
Combining RIGHT
Este curso está en español. Traducir al inglés