LibreOffice Calc

BY
Udemy

Mode

Online

Fees

₹ 1799

Quick Facts

particular details
Medium of instructions English, Portuguese
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 1,799
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Introduction

  • ambiance
  • Introduction to LibreOffice Calc - Part 1
  • Download and Install LobreOffice
  • Introduction to LibreOffice - Part 2
  • Arithmetic Operators
  • Extra - Continuous and non-continuous interval
  • BMI Formula Application - Practice 01
  • PI() function application - Practice 02
  • Fill Handle

Formulas and Functions

  • SUM & AVERAGE functions
  • MAX & LARGER Functions
  • MIN & MINOR functions
  • Study of the SE Function
  • SE Function Practice
  • SE Function (Linked)
  • COUNTIF function
  • SOMASE
  • Exemplifying in Practice CONT.SE and SOMASE
  • CONT.SES function
  • SUMIF function
  • Functions with Dates TODAY, NOW, DAY, MONTH, YEAR, WEEKDAY and DATE...
  • Explaining Relative Reference
  • Explaining the Absolute Reference
  • Applied class Relative and Absolute Reference

Formatting

  • Font Formatting and Cell Filling
  • Alignment Formatting
  • Number Formatting
  • Table Formatting - Borders
  • Conditional Formatting Part 1
  • Conditional Formatting Part 2
  • Conditional Formatting Part 3
  • Conditional Formatting Part 4
  • Conditional Formatting Part 5
  • Conditional Formatting Part 6

Dice

  • Tidy
  • AutoFiltro
  • Subtotais

Graphics

  • Introduction - Columns
  • Barras
  • Pizza
  • Area & Line
  • Bubbles
  • Network
  • Shares - High; Download And Closing
  • Actions - Opening; High; Download And Closing
  • Shares - Volume; High; Download And Closing
  • Shares - Volume; Opening, High; Download And Closing
  • Line And Column

In practice

  • Applied Practice Financial Control
  • Practice 2 - Formatting and Validation (SOMA)
  • Practice 3 - SUMIF functions
  • Practice 4 - SOMASES; TODAY; MONTH; YEAR
  • Practice 5 - SE
  • Practice 6 - Remembering SOMASES and Absolute Reference
  • Practice 7 - Charts
  • Practice 8 - Chart (USE OF VLOOKUP)

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books