In-depth Microsoft Excel and Business Data Analysis

Learn all about the Microsoft Excel and data analysis in detail.

In-depth Microsoft Excel and Business Data Analysis

Learn all about the Microsoft Excel and data analysis in detail.
18
views
Share the link to this page
Copied

About the Class

Microsoft Excel is the world's most used and versatile business analysis, reporting, and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent, and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you. This training is going to focus on making you highly proficient in the use of Excel for business data analysis, dashboard creation, and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.

The training comes with lots of practice files, my paid book (e-copy) and covers the following:

The training outline is:

Data manipulation in Excel

  • How Excel handles different data types
  • Data consistency, starting with the end in view
  • Building datasheets that can easily scale
  • Sorting
    • Cascaded sorting
    • Sorting across rows (left to right sorting, not the usual up to down sorting)
    • Sorting and Conditional Formatting to identify trends
  • Filtering
  • Data cleaning
  • Removing duplicates
  • Text-to-column
  • Grouping
  • Data validation
  • Conditional formatting
    • Data formatting
  • Using tables (and when to convert to tables)
  • Formatting for printing
  • Formatting for email
  • Data review and formatting for 3rd party use
    • Named ranges
  • Charts
  • Chart types
  • The line chart and when to use it
  • Column chart and when to use it
  • Bar chart and when to use it
  • Pie chart and its dangers
    • Combining charts; when and how
    • Dynamic Charts, using the filter
    • Best practices when making charts
    • Sparklines
    • Power map and Power view (Excel 2013 and Excel
      2016 only)
  • Pivot table, Pivot chart, and PowerPivot
  • Pivot Table
  • Default Pivot table
  • Tabular Pivot table
  • Pivot Table filtering
  • Making a very dynamic regular table from the Pivot table
  • Calculations and Formula use with Pivot table
  • Advanced Pivot Table tricks
    • Pivot Chart
  • Pivot Chart and its limitations
  • Dynamic Pivot Charts
    • PowerPivot (for Excel 2010, 2013, and 2016 only)
    • Power BI for the dynamic dashboard and analyzing millions of rows of data
  • Business data analysis
    • Linking sheets
    • Duplicating sheets (better than copy and paste)
    • Inserting sheets, labeling, and coloring the professional way
    • Freezing Panes and splitting windows
    • Conditional formatting
  • To identify patterns
  • Using formulae
  • To make extremely intelligent reports
    • Lookup functions
  •  Vlookup
  • Hookup
  • Looking up the last data or pattern in a particular row or column
  • Overcoming the limitations of Vlookup and Hlookup using index and match functions
    • Power Functions
  • IF, IFERROR, AND, OR, ISBLANK, and others in the same family
  • Text manipulative functions to make a completely automated Dashboard
  • Countifs, Sumifs, Averageifs, and others, to make dynamic summary tables
  • Match and Index to do the impossible
    • Other Functions
    • Math Functions
    • Text Functions
    • Logical
    • Others
    • Formula Auditing
    • Goal Seek, Scenario Manager, and solver
    • Excel web query
    • Most useful Excel keyboard shortcuts
  • Executive Dashboards and Reporting
  • Best Practices
  • Executive Dashboards
    • Executive Dashboards
    • Dynamic Reports
    • Determining the KPIs and tracking them
    • Strategic Insights and Analysis
    • Data Visualization
    • Having the audience/recipient in mind
    • E-mails and Excel reports
  • Excel to PowerPoint and Word
    • Linking PowerPoint/Word Charts to Excel
    • Embedding Excel sheets in PowerPoint/Word
    • Making a Powerful PowerPoint Presentation
  • Excel VBA
    • Recording Excel macros
    • Introduction to editing Macro codes

Author

Michael Olafusi

School

Michael Olafusi's School

Requirements

  • You should have to install a modern version of Microsoft Excel (Excel 2016 and above).

Class Contents

One-time Fee
$19.99
List Price:  $24.99
You save:  $5
€19.21
List Price:  €24.02
You save:  €4.80
£15.97
List Price:  £19.97
You save:  £3.99
CA$27.99
List Price:  CA$34.99
You save:  CA$7
A$30.81
List Price:  A$38.51
You save:  A$7.70
S$26.96
List Price:  S$33.71
You save:  S$6.74
HK$155.59
List Price:  HK$194.51
You save:  HK$38.91
CHF 17.77
List Price:  CHF 22.21
You save:  CHF 4.44
NOK kr222.62
List Price:  NOK kr278.30
You save:  NOK kr55.68
DKK kr143.31
List Price:  DKK kr179.16
You save:  DKK kr35.84
NZ$34.26
List Price:  NZ$42.84
You save:  NZ$8.57
د.إ73.42
List Price:  د.إ91.78
You save:  د.إ18.36
৳2,399.88
List Price:  ৳3,000.15
You save:  ৳600.27
₹1,688.52
List Price:  ₹2,110.86
You save:  ₹422.34
RM89.30
List Price:  RM111.64
You save:  RM22.33
₦33,804.68
List Price:  ₦42,260.08
You save:  ₦8,455.40
₨5,555.72
List Price:  ₨6,945.35
You save:  ₨1,389.62
฿691.55
List Price:  ฿864.52
You save:  ฿172.97
₺691.11
List Price:  ₺863.97
You save:  ₺172.86
B$116.19
List Price:  B$145.25
You save:  B$29.06
R361.64
List Price:  R452.10
You save:  R90.45
Лв37.53
List Price:  Лв46.92
You save:  Лв9.38
₩28,120.04
List Price:  ₩35,153.56
You save:  ₩7,033.52
₪74.43
List Price:  ₪93.05
You save:  ₪18.61
₱1,178.39
List Price:  ₱1,473.13
You save:  ₱294.74
¥3,088.56
List Price:  ¥3,861.09
You save:  ¥772.52
MX$409.17
List Price:  MX$511.52
You save:  MX$102.34
QR73.21
List Price:  QR91.53
You save:  QR18.31
P274.16
List Price:  P342.73
You save:  P68.57
KSh2,588.70
List Price:  KSh3,236.20
You save:  KSh647.50
E£992.98
List Price:  E£1,241.34
You save:  E£248.36
ብር2,502.60
List Price:  ብር3,128.57
You save:  ብር625.96
Kz18,244.08
List Price:  Kz22,807.39
You save:  Kz4,563.30
CLP$19,465.06
List Price:  CLP$24,333.76
You save:  CLP$4,868.70
CN¥144.91
List Price:  CN¥181.16
You save:  CN¥36.24
RD$1,210.05
List Price:  RD$1,512.72
You save:  RD$302.66
DA2,672.04
List Price:  DA3,340.39
You save:  DA668.34
FJ$45.50
List Price:  FJ$56.88
You save:  FJ$11.38
Q155.02
List Price:  Q193.79
You save:  Q38.77
GY$4,201.54
List Price:  GY$5,252.46
You save:  GY$1,050.91
ISK kr2,792
List Price:  ISK kr3,490.35
You save:  ISK kr698.35
DH200.84
List Price:  DH251.08
You save:  DH50.23
L364.61
List Price:  L455.81
You save:  L91.19
ден1,174.64
List Price:  ден1,468.45
You save:  ден293.80
MOP$161
List Price:  MOP$201.27
You save:  MOP$40.27
N$363.38
List Price:  N$454.27
You save:  N$90.89
C$735.03
List Price:  C$918.88
You save:  C$183.85
रु2,702.19
List Price:  रु3,378.08
You save:  रु675.88
S/76.28
List Price:  S/95.36
You save:  S/19.08
K80.84
List Price:  K101.06
You save:  K20.22
SAR75.05
List Price:  SAR93.83
You save:  SAR18.77
ZK553.77
List Price:  ZK692.28
You save:  ZK138.51
L95.61
List Price:  L119.52
You save:  L23.91
Kč487.79
List Price:  Kč609.80
You save:  Kč122.01
Ft7,901.07
List Price:  Ft9,877.33
You save:  Ft1,976.25
SEK kr222.50
List Price:  SEK kr278.15
You save:  SEK kr55.65
ARS$20,070.63
List Price:  ARS$25,090.80
You save:  ARS$5,020.16
Bs138.75
List Price:  Bs173.46
You save:  Bs34.70
COP$88,728.67
List Price:  COP$110,921.93
You save:  COP$22,193.26
₡10,208.85
List Price:  ₡12,762.34
You save:  ₡2,553.49
L507.49
List Price:  L634.42
You save:  L126.93
₲157,619.54
List Price:  ₲197,044.14
You save:  ₲39,424.59
$U855.78
List Price:  $U1,069.83
You save:  $U214.05
zł83.49
List Price:  zł104.37
You save:  zł20.88
Subscription
$19.99
$9.99
per month
Payment Plan
$19.99
$11.99
per month
3 payments

What's Included

Language: English
Level: All levels
Skills: Data Manipulation, Data Analysis, Data Consistency, Microsoft Excel, Microsoft
Age groups: 18-65 years
Duration: 10 hours 18 minutes
49 Videos
27 Documents
0
Saves
18
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.