Microsoft Excel Fundamentals

Excel-Fundamentals

Location: Online

Dates: tbc

Fee: € 70

This class covers the basics of Microsoft Excel, including an overview of its features and how to use them. It also teaches how to perform calculations such as sum, average, minimum, maximum, percentages, and rates. Additionally, students will learn how to create graphs and charts to visually represent data. This course is beneficial for professionals in various fields, such as business for creating sales reports, statistics for analyzing data relationships, engineering for research purposes, accounting for payroll preparation, sciences for research projects, management for organizing organizational data, individuals managing inventory, teachers for grading students, and anyone conducting research using Excel to analyze data relationships.

Who is the Coach?

Jelil Lanre Adedokun

My name is Jelil Lanre Adedokun. I am a 41 years old Nigerian and currently working as a lecturer at the Federal University of Agriculture Abeokuta. I hold a Masters degree in Electrical and Electronics Engineering, which has equipped me with extensive knowledge in this field. Apart from my teaching responsibilities, I am also actively involved in research. I have a strong command over various Microsoft packages such as Excel, Word, and PowerPoint, which enables me to effectively analyze and present data. Additionally, I possess expertise in guiding individuals on writing compelling business plans that attract the attention of potential investors, as well as crafting well-structured research reports. As an educator, I prioritize my students’ needs and employ a student-oriented teaching approach. I strive to establish a positive and supportive relationship with my students, fostering an environment conducive to learning. I am dedicated to assisting learners in achieving their goals in any subject I teach.

Schedule

Workbooks, file, worksheet, how to move about in a file, imputing text, numbers or simple formulas in a worksheet, how to fill a series, how to insert and delete worksheet, how to copy and rename worksheet, how to copy or move a sheet to another workbook, how to change worksheet tab colours, how to group worksheets, how to freeze rows and columns, how to select rows, columns and ranges, exercises.

Formatting of cells (meaning,) changing font style, font size, how to apply borders to a range of cells, how to wrap and merge texts. Functions (meaning, S, Average, Minimum, Maximum), Common error messages.

Quick analysis(Quick formatting, quick charting, quick totals, quick sparklines, quick tables), how to print a worksheet, process of charting, selection of the right chart, how to use a recommended chart, exercises.

Creating new chart from scratch, how to work with embedded chart, how to resize a chart, how to reposition a chart, how to print embedded chart, how to create a chart, how to change the type, layout and style of a chart, how to print a chart sheet, putting a chart into a worksheet, how to delete a chart, exercises.

Apply

tbc