ViewTube

Chapter 1. Learn Data Analysis using Excel. Step by step approach to understand IGCSE-ICT practical Cambridge curriculum.

In this video we filter data (displaying a selection of data) and also sort data ( arranging data in alphabetical order or ascending or ...

We look at the MS Excel screen. We also define a cell, sheet and a cell address. Dont forget to subscribe Email: info@eictta.com.

This video shows how to deal with errors that usually comes up when you work with .csv files. Email: info@eictta.com.

Sometimes in MS Excel, you want to format cells based on the cell values . For this, we use conditional formatting Don't forget to ...

This video looks at the IF function. Don't forget to subscribe and click the notification button Like this page on Facebook ...

This video discusses the COUNTIF function.

This video looks at formatting a spreadsheet to give it life Don't forget to subscribe and click the notification button Like this page ...

Download source files from here - https://tinyurl.com/FebMar24IGCSEICT Download the worked files from here ...

In this video you will learn about IGCSE information communication technology chapter 20 Data analysis Task 20 N,O Playlists: ...

In this video you will learn about IGCSE information communication technology chapter 20 Data analysis Activity 20H Playlists: ...

In this video you will learn about IGCSE information communication technology chapter 20 Data analysis Task 20 N,O Playlists: ...

This video looks at the SUMIF and AVERAGEIF function. It also touches a little bit on nested functions Don't forget to subscribe ...

This video looks at the basic inbuilt formulas in MS Excel (SUM, AVERAGE, MIN, MAX). Don't forget to subscribe and click the ...

IGCSE ICT Data analysis/Excel SUMIF function Task 20k.

We can use MS Excel to create charts and copy those charts to other MS application like Word and MS Powerpoint. This video ...