Introduction to Microsoft Excel
Skill Level
Basic
6 hrs
Duration
English
Language
Overview
This course is tailored for participants who perform regular analysis on business information like product/service performance, operational expenses, payroll/wage processing, bank reconciliations, tracking employees’ info, etc. and expect exceptional figures and trends to be easily spotted as a basis for decisions (e.g. overdue invoices, sales over target, missing/repeated records etc.)
Completing this course will help you:
- Data cleansing techniques
- Prepping your data for analysis
- Data mining and analysis techniques
- Visual presentation of data (charts and pre built conditional formatting)
Course Prerequisites
No prerequisite
Learning Path
Learn and understand the Excel environment: Quick Access Tools, The Ribbon, and recent updates to the app.
$ – to create robust formulas (relative, absolute, and mixed references).
- Some key functions to generate summaries–SUM, AVERAGE, COUNT, COUNTA, ROUND
- Find the highest and least values from a list –MAX, MIN
- Use of Logical Functions – IF
- Sorting & Filtering data
- Find & Replace
- Freezing panes to show important data while scrolling
- Adding comments
- Text-to-column feature
- Applying borders, color & number formats
- Save time using the Format painter to replicate formatting
- Remove gridlines
- Reporting using Excel tables
- Grouping Feature in Excel
- Fill in blanks
- Visible cells only
- CTRL+B
- CTRL+Z
- CTRL+Y
- CTRL+U
- CTRL+T
- CTRL+1
- Formats
- Formula
- Value
- Transpose
- Selecting right chart
- Creating & formatting/customizing chart elements to make it more effective –bar, column, line, pie/doughnut
- Charts best practices
- Prepare worksheet for printing (margins, page breaks, print area, printing headings on each page)
What people are saying
“I was looking for a Social Media Course to expand my career horizon. A friend of mine suggested to learn from Steve’s online courses and it really worked for me.”
“A fantastic and very engaging course. All of the information offered by Steve was completely practical, relevant and presented in an easy, digestible and interesting way.”
“This course was a breakthrough in my knowledge of digital marketing. The content is comprehensive and of great quality, engaging and interactive.”
Previous
Next