|
Login / Register

Course Details

Diploma Courses

Mastering Basics of Microsoft Excel Course | OilTrain

Certfee Diploma Courses

Institute: Certfee Diploma Courses

Certificate Type: Professional Certificate

Courses Descriptions

Learn basic Excel formulas, data sorting, conditional formatting, and budget tracking with OilTrain. Build essential spreadsheet skills for corporate productivity.

Overview of Microsoft Excel and Its Applications
0:00:00
Navigating the Excel Interface (Ribbons, Toolbars, and Worksheets)
0:00:00
Understanding Workbooks, Worksheets, Rows, Columns, and Cells
0:00:00
Basic Data Entry, Editing, and Formatting
0:00:00
Saving and Managing Excel Files
0:00:00

Introduction to Formulas and Functions
0:00:00
*Using Basic Arithmetic Operations (+, -, , /)
0:00:00
Common Functions: SUM, AVERAGE, MIN, MAX, COUNT
0:00:00
Understanding Cell References: Absolute vs. Relative
0:00:00
Introduction to Logical Functions (IF, AND, OR)
0:00:00

Formatting Cells: Numbers, Text, Dates, and Conditional Formatting
0:00:00
Sorting and Filtering Data Efficiently
0:00:00
Using Tables for Better Data Organization
0:00:00
Working with Multiple Worksheets and Linking Data
0:00:00
Data Validation and Error Handling
0:00:00

Introduction to Charts and Graphs
0:00:00
Creating and Customizing Bar, Line, and Pie Charts
0:00:00
Conditional Formatting for Better Data Insights
0:00:00
Inserting and Formatting Images, Shapes, and SmartArt
0:00:00
Printing and Sharing Excel Files Effectively
0:00:00

Essential Excel Keyboard Shortcuts
0:00:00
Intro to Freeze Panes, Split View, and Zoom Options
0:00:00
Protecting and Securing Worksheets
0:00:00
Hands-on Project: Creating a Functional Excel Spreadsheet
0:00:00

Institution

Certfee Diploma Courses
Certfee Diploma Courses

A Certfee diploma certificate boosts your CV, validates professional skills, increases job opportunities, and helps you qualify for better careers globally.

Certificate Type: Professional Certificate

0.00

0 Reviews

1 Star
(0)
2 Star
(0)
3 Star
(0)
4 Star
(0)
5 Star
(0)

Write a Review

Courses Includes:

  • Price : ₦180,000.00
  • Institute : Certfee Diploma Courses
  • Durations : 18 Hour
  • Lessons : 24
  • Students : 0
  • Language : English
  • Level : Beginners Level
  • Certifications : Yes
Enroll Now

Share On:

Related Courses

  • 0 Students
  • 30 Lessons
Diploma Courses ₦195,000.00

Generative AI & LLM Training for Beginners | OilTrain

Demystify the architecture of modern AI, master strategic prompt engineering, and integrate generative tools safely into your daily business operations. Purpose-built for non-technical managers, entrepreneurs, administrative leads, and creative professionals, this 30-lesson track clarifies how neural networks process human language. You will master tokenization basics, context windows, iterative prompting frameworks, and AI data privacy guardrails. Secure the fundamental operational blueprint needed to automate repetitive tasks and confidently pilot AI tools.

(0 Ratings)
  • 0 Students
  • 25 Lessons
Diploma Courses ₦185,000.00

Microsoft Teams Enterprise Management Course | OilTrain

Architect scalable communication ecosystems, configure governance policies, and integrate collaborative automation workflows within a Microsoft 365 enterprise environment. Tailored for operations managers, IT coordinators, HR directors, and project leads, this 25-lesson tactical course deconstructs modern workspace architecture. You will master channel permissions, cross-tenant collaborations, lifecycle management, and App integrations. Secure the administrative blueprint needed to eliminate communication silos and protect corporate data security.

(0 Ratings)
  • 0 Students
  • 24 Lessons
Diploma Courses ₦245,000.00

Snowflake Cloud Data Platform Course | OilTrain

Master cloud data warehousing architecture, configure virtual warehouses, and execute secure data sharing pipelines using the Snowflake ecosystem. Built for data analysts, database administrators, operations managers, and business intelligence leads, this 24-lesson foundational course breaks down multi-cluster shared data structures. You will master basic SQL querying within Snowflake, data storage optimization, zero-copy cloning, and cloud security governance. Secure the core technical blueprint needed to centralize corporate data and drive data-informed business decisions.

(0 Ratings)