By the end of this course, learners will be able to navigate Microsoft Excel 2019 confidently, apply professional formatting, perform accurate calculations, and analyze data using logical and conditional tools.
This Excel 2019 – Beginners Training course is designed for absolute beginners who want to build strong, practical spreadsheet skills from the ground up. Learners start by understanding the Excel interface, worksheets, and file management before progressing to formatting data for clarity and professionalism. The course then introduces mathematical operations, logical functions like IF, and essential number formatting to ensure calculations are accurate and meaningful. Finally, learners develop data analysis skills using functions such as COUNTIF, SUM, AVERAGE, MAX, MINIFS, and visual tools like conditional formatting.
What makes this course unique is its step-by-step, concept-first approach, reinforced with practice quizzes and graded assessments that ensure real skill development rather than memorization. Each lesson is aligned with clear learning objectives and real-world use cases, making it ideal for students, professionals, and anyone looking to use Excel effectively for data-driven tasks.
This module introduces beginners to Microsoft Excel 2019 by covering the interface, worksheets, file management, and essential formatting tools needed to confidently start working with spreadsheets.
涵盖的内容
10个视频4个作业
显示有关单元内容的信息
10个视频•总计46分钟
Accessing MS Excel•3分钟
MS Excel Startup Screen•2分钟
Understanding the Ribbon•3分钟
Cells in Excel•1分钟
Worksheet Essentials•3分钟
Saving the File•1分钟
Formatting Cells Part 1•8分钟
Formatting Cells Part 2•6分钟
Custom Cell Styles•6分钟
Custom Number Formatting in Excel•12分钟
4个作业•总计60分钟
Getting Comfortable with Excel•30分钟
First Steps into Excel•10分钟
Working with Worksheets and Files•10分钟
Making Data Look Professional•10分钟
Calculations and Smart Logic
第 2 单元•小时 后完成
单元详情
This module builds computational skills by teaching number formatting, mathematical operations, logical functions, and working with imported data to perform accurate calculations in Excel.
涵盖的内容
10个视频4个作业
显示有关单元内容的信息
10个视频•总计97分钟
More on Custom Number Formatting•11分钟
Custom Formats of Data Part 1•5分钟
Custom Formats of Data Part 2•9分钟
The BEDMAS Order of Mathematical Operations•9分钟
Mathematical Operations without Functions•10分钟
Mathematical Operations without Functions Continued•12分钟
IF Function•11分钟
More on IF Function•8分钟
Importing Data and Calculations•11分钟
Working with the Count Function•13分钟
4个作业•总计60分钟
Calculations and Smart Logic•30分钟
Mastering Numbers and Formats•10分钟
Doing Calculations Without Functions•10分钟
Bringing Data into Excel•10分钟
Data Analysis Made Easy
第 3 单元•小时 后完成
单元详情
This module focuses on analyzing and interpreting data using conditional functions, summary calculations, proportions, and visual tools such as conditional formatting.
涵盖的内容
10个视频4个作业
显示有关单元内容的信息
10个视频•总计83分钟
Conditional Counts - Count IF Function•5分钟
Working with the Sum Function Part 1•8分钟
Working with the Sum Function Part 2•7分钟
Finding the Average•11分钟
Conditional Average - Average IFS Function•9分钟
Finding the Maximum Value Using the MAX Function•9分钟
Finding the Maximum Value Using the MINFS Function•8分钟
Determining Proportions and Updating a Calculation•10分钟
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.