Excel for Business Life, From Beginning to Advanced

Learn Excel, develop strategy, solve business life affairs
4.66 (54 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel for Business Life, From Beginning to Advanced
2,047
students
13 hours
content
Aug 2019
last update
$64.99
regular price

What you will learn

Excel Fundamentals

Formats, Fonts and Design

Worksheet Properties

Data Management in Excel

Data Sort

Data Sort From Left to Right

Data Filter

Table

Remove Dublicates

Custom List

Subtotal and Data Groups

Pivot Table

Pivot Table Properties and Options

User Defined Formulas in Pivot Table

Merge Pivot Tables

Excel Formulas

Structure of Excel Formulas

Text Formulas

Flash Fill

Statistical Formulas

Date and Time Formulas

SUBTOTAL Function For Filter

Lookup Functions

VLOOKUP For 2 Tables

Advanced Filter Functions

FORMULAS Menu

Advanced Excel

Data Validation

Conditional Formatting

Special Cells (GOTO SPECIAL)

External Data From Other Sources

Name Manager

Consolidation

Watch Window and Trace Cells

Excel Protection

Printer Settings

Relation of PDF and Printer

Graphics and Charts in Excel

Simple Graphs

Column Graphs

Pie Chart Graphs

Picture Graphs

Graphics into the Cells

Linear Modelling in Excel

Goal Seek

What-if Analysis / Data Table

Excel Solver

Senario Analysis

Useful Tips

Copy - Paste Options

F4 Key

Fix Headers

VIEW Menu

ComboBox

Trendline

Spin Button

Animated Charts

Scroll Bar

Draw Shapes

Fix Formulas (Details of F4 Key)

Creating Custom Menu

Watch Movie and Listen Music in Excel

Screenshots

Excel for Business Life, From Beginning to Advanced - Screenshot_01Excel for Business Life, From Beginning to Advanced - Screenshot_02Excel for Business Life, From Beginning to Advanced - Screenshot_03Excel for Business Life, From Beginning to Advanced - Screenshot_04
Related Topics
2478708
udemy ID
7/26/2019
course created date
8/22/2019
course indexed date
Bot
course submited by