Excel for Beginners — Basic Most Used Techniques & Features

Ahmad-Portfoilo-Photo
Ahmad Musa
Last Update July 12, 2021
5.0 /5
(3)

About This Course

This course is a sort of a Crash course.

The class designed for beginners. Low to Mid, assuming that you don’t have any Excel experience. The focus objective & goal is to demonstrate the basic most used techniques & features of Excel.

Learning Objectives

At the end of this 1 hour webinar, you will be able to perform:
• Basic Cells Formatting
• Sorting and Filtering of Data
• Using Basic Excel Functions
• Conditional Formatting & Starting with Charts Creation

Requirements

  • • No any course prerequisite
  • • Importantly: to have a PC or a Laptop loaded with Excel 365 or Excel 2016.

Target Audience

  • • FP&A Analysts
  • • Capital Market Analysts
  • • Junior Accountants
  • • Strategic Planning Analysts
  • • MIS & Data Science Students

Zoom Live Meetings

Excel for Beginners u2014 Basic Most Used Techniques & Features Expired

The video conference has expired

Please contact your instructor for further information

Curriculum

1h 15m

Getting Started

a journey of a thousand miles begins with a single step." This is the starting point. With this topic, we will explore what is Excel, its usages & applications. To start Excel & navigate the tool bar. Also, demonstrating how to create & edit workbooks & worksheets.

Basic Cells Formatting

With this we will add a touch of art to the Excel cells. To generate visually appealing sheets that are easy to understand & follow. To explore the most used & famous formatting features: font formatting , number formatting, date & time formatting & finally how to add & edit boarders.

Sorting and Filtering of Data

An amazing agile techniques. We will learn how to sort the data into alphabetical, numerical or date order. Also, move a bit more advanced to explore using multiple & custom sorting. Finally, with a focused look at the data, a quick technique to filter only the data you want to show.

Using Basic Excel Functions

To explore the most widely used & useful Excel Functions. This includes, but not limited to: • Using & editing the (SUM) function • Using & editing the (AVERAGE) function • Using & editing the (MAX) function • Using & editing the (MIN) function And some more…

Conditional Formatting & Starting with Charts Creation

To explore the quickest way for data visualization, by using the conditional formatting, including: color scales & icon sets. Then to move to a bit advanced way of data visualization by using Excel charts. We will explore the following: • Exploring most useable chart types • How to insert a chart to visualize a data set • Choosing the best chart type & change

Your Instructors

Ahmad Musa

Excel & Financial Planning Guru

5.0/5
1 Course
3 Reviews
31 Students
I have 25 years of experience within the Banking industry, and Financial Institutions (7 years in IT & 18 years in Finance). I'm demonstrating the following: • Sound experience in the analytical skills for the Banking Products’ specifications & profitability for both Islamic & Conventional Banking, • Advanced level of Management Accounting & Management Information Systems (MIS), along with Budgeting, Financial Planning and Business Planning. • Advanced level of Excel, and other MS-Office applications. Experienced level in producing Business & Strategy Presentations using PowerPoint.
See more

Student Feedback

5.0
3 Ratings
100%
0%
0%
0%
0%

Reviews (3)

Very useful and helpful!

👍🏻

Good ...

Write a review

Free
Level
Beginner
Duration 1.3 hour
Language
English

Material Includes

  • • Please: download the Excel file: “Company XYZ -- Students2” prior to attending the webinar.
  • • Selected practicing files, loaded by default with Excel.

Enrolment validity: Lifetime

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Wishlist 0
Open wishlist page Continue shopping