Excel Intermediate Course

About Course

Koorsada Dhexdhexaadka ee barnaamijka Excel waxaa loogu talagalay inay ku siiso faham qoto dheer oo ku saabsan astaamaha aasaasiga ah ee barnaamijka Excel iyo sida loogu dabaqo hawlahaaga maalinlaha ah ee xafiiskaaga shaqo. Waxaad awoodi doontaa inaad abuurto, dib u eegto, xoojiso, oo aad daabacdo noocyo kala duwan oo xaashiyada barnaamijka ah adoo isticmaalaya xirfadahaaga cusub ee aad baran doonto. Waxaad baran doontaa sida loo isticmaalo barnaamijka Excel si aad u samayso jaantusyo horumarsan, xisaabinta, iyo falanqaynta xogta ee shaxyada pivotka iyo inaad ka faa’iidaysato isticmaalka agabyada barnaamijka ee durbo qaabaynta jaantusyada iyo shaxyada lagu muujiyo muuqaalada xogta. Koorsadan waxaa kale oo ay horumarinaysaa fahamkaaga hawlaha iyo isticmaalka qaacidooyinka barnaamijkan

Master the maintenance of large Microsoft Excel data sets in a list or table.
Control user input by prompting the user when a cell contains an incorrect value.
Utilize some of the lesser-known Excel functions to perform calculations on Excel lists.
Generate dynamic reports by mastering Excel PivotTables
Utilize Excel to its fullest ability by utilizing slicers to create relationships between data, generate reports from the data, and much more, elevating your Excel expertise to an entirely new level.

Course Content

Starting Excel 2016

Lesson: 1

11:46

Excel Free Templates

Manage Worksheet/Workbook

Flash Fill

Formatting Excel file

Manipulating Data in Excel

Filtering

Excel Tables

Subtotals

Introduction to Excel Charts

Intermediate Excel formulas and functions

Pivot Tables in Excel

Importing Data into Excel

Data Validation

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Mohamed Mohamud

12 months ago

It was really wonderful, I have gained a lot of excel skills.
Therefore I recommend every body to take this professional course.
Thank u Teacher.

About Course

What Will You Learn?

Course Content

Starting Excel 2016

Lesson: 1

Excel Free Templates

How to use Free Excel Templates

Manage Worksheet/Workbook

Organize your worksheet/workbooks

Move and arrange your worksheet/workbook

Flash Fill

Using the Flash Fill feature in Excel

Formatting Excel file

How to format Excel File

Manipulating Data in Excel

Sorting 1

Sorting 2

Sorting 3

Sorting 4

Sorting Days of the week

Unsorting

Filtering

Single level Filtering of data

Multi-Level Filtering in Excel

Excel Tables

Table Properties 1

Table Properties 2

Table Properties 3

Table Properties 4

Subtotals

Lesson 1

Introduction to Excel Charts

Quick analysis tool & charts to understand trends in data (i)

Quick analysis tool & charts to understand trends in data (ii)

Spark lines Charts

Intermediate Excel formulas and functions

Intermediate formulas and functions (i)

Intermediate formulas and functions (ii)

Intermediate formulas and functions (iii)

Pivot Tables in Excel

Introduction and inserting pivot table

Creating your first pivot table

Create Pivot Tables using guiding questions (i)

Create Pivot Tables using guiding questions (ii)

Introduction to slicers and using them in pivot tables

Pivot Charts

Importing Data into Excel

Import Data from workbook

Import Data from the web

Data Validation

All about Data validation

Earn A Certificate

Student Ratings & Reviews