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
Material Includes
- • Please: download the Excel file: “Company XYZ -- Students2” prior to attending the webinar.
- • Selected practicing files, loaded by default with Excel.
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
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 
