Excel for Business Analysis

Jul

Teacher SkillsPropel Instructor
Categories Training Courses
Students 29 (Registered)
Review

(0 Review)

Who Should Attend?

Business Analysts, Business System Analysts and individuals who wish to upscale their proficiency in excel.

Prerequisites

None

Course Duration:

2-3 days

Learning Options

All our delivery channels: E-Propel, C-Propel and V-Propel Learning Platforms

Can I cancel my training? Yes, you can before the first day of the training. Your training fee after deducting administrative fee will be refunded.

Learning Outcome

At the end of this course, you will learn:

The strategies to succeed on your role as business analyst
Ability to effectively engage users, domain knowledge experts and other stakeholders on your projects
How to identify and specify requirements
How to quickly and efficiently analyze data
How to make meaning of your data and improve your reporting
To prepare and make you comfortable with data generally
To communicate in a way that is easily understood using data

Course Content

Total learning: 39 lessons Time: 3 weeks

Excel - Basics of Excel 0/24
- Lecture1.1
  
  Rows & Columns
- Lecture1.2
  
  Excel – Copy & Paste
- Lecture1.3
  
  Excel – Find & Replace
- Lecture1.4
  
  Excel – Spell Check Excel
- Lecture1.5
  
  Excel – Zoom In-Out Excel
- Lecture1.6
  
  Excel – Pivot Charts
- Lecture1.7
  
  Excel – Keyboard Shortcuts
- Lecture1.8
  
  Excel – Setting Colors
- Lecture1.9
  
  Excel – Text Alignments Excel
- Lecture1.10
  
  Excel – Merge & Wrap
- Lecture1.11
  
  Excel – Borders and Shades
- Lecture1.12
  
  Excel – Apply Formatting
- Lecture1.13
  
  Excel – Formatting Worksheets
- Lecture1.14
  
  Excel – Sheet Options
- Lecture1.15
  
  Excel – Adjust Margins
- Lecture1.16
  
  Excel – Page Orientation
- Lecture1.17
  
  Excel – Header and Footer
- Lecture1.18
  
  Excel – Insert Page Breaks
- Lecture1.19
  
  Excel – Explore Window
- Lecture1.20
  
  Excel – Backstage
- Lecture1.21
  
  Excel – Entering Values
- Lecture1.22
  
  Excel – Move Around
- Lecture1.23
  
  Excel – Save Workbook
- Lecture1.24
  
  Excel – Create Worksheet
Excel - Create Worksheet 0/15
- Lecture2.1
  
  Excel – IF functions
- Lecture2.2
  
  Excel – Pivot Charts
- Lecture2.3
  
  Excel – Macros
- Lecture2.4
  
  Excel – Excel Formatting
- Lecture2.5
  
  Excel- Vlookup and other look up types
- Lecture2.6
  
  Excel- VBA
- Lecture2.7
  
  Excel- Data Validation
- Lecture2.8
  
  Excel- Data Tables
- Lecture2.9
  
  Excel- Simple Chats
- Lecture2.10
  
  Excel- Freeze Panes
- Lecture2.11
  
  Excel- Graphics Excel – Using Styles
- Lecture2.12
  
  Excel – Using Themes
- Lecture2.13
  
  Excel – Using Templates
- Lecture2.14
  
  Excel- Concatenate
- Lecture2.15
  
  Excel- CELL, LEFT, MID and RIGHT functions