Advanced Excel Tutorial - Learn Excel with Advanced Functions

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size3.6 GB
  • Uploaded BySKYDnadna
  • Downloads295
  • Last checkedMar. 26th '21
  • Date uploadedMar. 24th '21
  • Seeders 1
  • Leechers2
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : DFF316728094A648C405937B91898DF154C00DBA

COURSE HIGHLIGHTS
27 Videos
10+ Hours of Content
10+ Supplementary Study Materials
INTRODUCTION
Microsoft Excel is perhaps the most important software program being used today. It has become a necessity in both business and professional life, irrespective of the role the hierarchy, the business function or the industry. This course has been designed in such a way so as to enable the students to gain a complete understanding on the advanced excel concepts and apply such concepts to their relevant role and business.

Advanced Excel Tutorial covers both fundamental as well as advanced excel concepts. It ensures that the participants not only understand these concepts with the help of well designed examples but also develop the thought process so that they can apply the learning in their day to day education or professional life.

OBJECTIVE
This program will enable the students:
To gain knowledge on basic as well as advanced excel concepts and functions
To understand the practical application of the basic as well as advanced excel concepts
To develop their thought process in such a way so as to apply their learnings in their educational or professional life
BENEFITS
Excel is all about increasing productivity and efficiency.

There are many things which are currently done either manually or using basic excel feature. But there are more efficient and smart ways to do it, which will not only save time but also increase productivity.

This course aims to provide the learners with a comprehensive knowledge bank on the basic as well as advanced excel concepts as well as their practical applications with the help of examples.

This series of recorded video lectures will allow the students and other professionals to learn at their own pace.

After successful completion of the course , the students will receive a “Certificate of Completion”

TOPICS COVERED
An introduction to MS Excel
Basic Formatting
Numeric, Logical, Text, Data , Date and Finance Function
Lookup, Array and Pivot Table
Circ Ref & Formatting, Naming Cells or Array and Paste Special
Go To Excel Linkage, Custom Format and Excel Protection
Charts
INTENDED PARTICIPANTS
Anyone using or planning to use calculators or other calculating devices
Graduate or Post Graduate Students from any streams
Working Professionals from any department specially Finance, HR, Marketing ,Operations, Supply Chain
Business people or self-employed professionals especially CAs, Consultants or any other stream where data is inevitable

Files:

Advanced Excel Tutorial Online 10.Circ Ref & Conditional Formatting Unit 1 Circ Ref & Conditional Formatting 4323
  • Advanced Excel Tutorial Online.ts (301.2 MB)
Unit 2 Circ Ref & Conditional Formatting
  • 84115880_circ_ref_conditional_formatting.xlsx (47.7 KB)
2.Basic Formatting Unit 1 Basic Formating 1155
  • Advanced Excel Tutorial Online.ts (61.9 MB)
3.Text Function Unit 1 Text Function 3131
  • Advanced Excel Tutorial Online.ts (61.9 MB)
4.Numeric Function Unit 1 Numeric Function 2448
  • Advanced Excel Tutorial Online.ts (115.1 MB)
Unit 2 Numeric Function
  • 590738058_numeric_function.xlsx (10.2 KB)
5.Logical Function Unit 1 Logical Function 3231
  • Advanced Excel Tutorial Online.ts (184.2 MB)
Unit 2 Logical Function II 1551
  • Advanced Excel Tutorial Online_2.ts (90.9 MB)
Unit 3 Logical Function I
  • 894155559_logical_function.xlsx (13.7 KB)
Unit 4 Logica Function II
  • 348578307_logical_function_ii.xlsx (49.7 KB)
6.Lookup Unit 1 Lookup I 3408
  • Advanced Excel Tutorial Online.ts (52.5 MB)
Unit 2 Lookup II 3320
  • Advanced Excel Tutorial Online.ts (198.1 MB)
Unit 3 Lookup Functions
  • 2025365867_lookup_functions.xlsx (70.9 KB)
7.Array Unit 1 Array I 3556
  • Advanced Excel Tutorial Online.ts (208.8 MB)
Unit 2 Array II 2247
  • Advanced Excel Tutorial Online.ts (116.7 MB)
Unit 3 Array Function
  • 448324506_array_function.xlsx (47.5 KB)
8.Data Function Unit 1 Data Function I 3401
  • Advanced Excel Tutorial Online.ts (116.7 MB)
Unit 2 Data Function II 2259
  • Advanced Excel Tutorial Online.ts (148.9 MB)
Unit 3 Data Function III 3516
  • Advanced Excel Tutorial Online.ts (241.4 MB)
Unit 4 Data Function IV 2045
  • Advanced Excel Tutorial Online.ts (132.6 MB)
Unit 5 Data Function
  • 2087050904_data_function.xlsx (64.2 KB)
9.Pivot Table Unit 1 Pivot Table 2713
  • Advanced Excel Tutorial Online.ts (233.1 MB)
Unit 2 Pivot Table
  • 1032570549_pivot_table.xlsx (57.7 KB)
1.Introduction Unit 1 Introduction to Excel 0232
  • Advanced Excel Tutorial Online.ts (10.0 MB)
11. Numeric Cell or Array Unit 1 Naming Cell or Arrays 2757
  • Advanced Excel Tutorial Online.ts (174.5 MB)
Unit 2 Name Function
  • 1634144226_name_fun.xlsx (50.1 KB)
12.Paste Special Unit 1 Passing Special 1929
  • Advanced Excel Tutorial Online_2.ts (129.3 MB)
13.Go To & Excel Linkage Unit 1 Go To & Excel Linkage 2446
  • Advanced Excel Tutorial Online_2.ts (129.3 MB)
Unit 2 Go To & Excel Linkage
  • 1138256295_go_to.xlsx (44.9 KB)
Unit 3 Sample Data Edit Links I
  • 1355384963_sample_data_editlinks_1.xlsx (11.4 KB)
Unit 4 Sample Data Edit Links II
  • 1942657333_sample_data_editlinks_2.xlsx (9.4 KB)
14.Custome Format Unit 1 Custom Format I 1146
  • Advanced Excel Tutorial Online.ts (66.6 MB)
Unit 2 Custom Format II 1842
  • Advanced Excel Tutorial Online.ts (66.6 MB)
Unit 3 Custom Format Number
  • 1652642417_custom_format_number.xlsx (41.0 KB)
15.Data Function Unit 1 Date Function I 0725
  • Advanced Excel Tutorial Online.ts (44.4 MB)
Unit 2 Date Function II 1445
  • Advanced Excel Tutorial Online_2.ts (88.5 MB)
Unit 3 Date Function
  • 1170898377_date_function.xlsx (44.6 KB)
16.Finance Function Unit 1 Finance Function 3314
  • Advanced Excel Tutorial Online.ts (195.1 MB)
Unit 2 Finance
  • 638994687_finance.xlsx (59.2 KB)
17.Excel Protection Unit 1 Excel Protection 1233
  • Advanced Excel Tutorial Online_2.ts (82.8 MB)
Unit 2 Protecting Cells I
  • 938525848_protecing_cellsi.xlsx (42.9 KB)
Unit 3 Protecting Cells II
  • 1638466262_protecing_cellsii.xlsx (42.5 KB)
18.Chart Unit 1 Chart I 3553
  • Advanced Excel Tutorial Online.ts (249.1 MB)
Unit 2 Chart II 2714
  • Advanced Excel Tutorial Online_2.ts (182.2 MB)
Unit 3 Chart
  • 1697148586_chart.xlsx (78.8 KB)

Code:

  • udp://open.stealth.si:80/announce
  • udp://tracker.dler.org:6969/announce
  • https://tracker.nanoha.org:443/announce
  • https://tracker.sloppyta.co:443/announce
  • https://tracker.nitrix.me:443/announce
  • https://tracker.tamersunion.org:443/announce
  • https://tracker.imgoingto.icu:443/announce
  • udp://tracker.shkinev.me:6969/announce
  • udp://ln.mtahost.co:6969/announce
  • udp://mail.realliferpg.de:6969/announce
  • udp://movies.zsw.ca:6969/announce
  • udp://bubu.mapfactor.com:6969/announce
  • http://ns3107607.ip-54-36-126.eu:6969/announce
  • http://rt.tace.ru:80/announce
  • udp://code2chicken.nl:6969/announce
  • udp://t2.leech.ie:1337/announce
  • udp://t1.leech.ie:1337/announce
  • udp://us-tracker.publictracker.xyz:6969/announce
  • udp://tracker.0x.tf:6969/announce
  • udp://tracker.altrosky.nl:6969/announce
  • https://tracker.lilithraws.cf:443/announce
  • udp://app.icon256.com:8000/announce
  • udp://tracker.zerobytes.xyz:1337/announce
  • udp://www.torrent.eu.org:451/announce
  • udp://vibe.sleepyinternetfun.xyz:1738/announce
  • udp://tracker.torrent.eu.org:451/announce
  • http://trk.publictracker.xyz:6969/announce
  • udp://fasttracker.foreverpirates.co:6969/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://newtoncity.org:6969/announce
  • udp://fe.dealclub.de:6969/announce
  • https://tracker.coalition.space:443/announce
  • udp://torrentclub.online:54123/announce
  • https://bt.nfshost.com:443/announce
  • udp://free.publictracker.xyz:6969/announce
  • http://vps02.net.orel.ru:80/announce
  • udp://retracker.netbynet.ru:2710/announce
  • udp://valakas.rollo.dnsabr.com:2710/announce
  • udp://opentracker.i2p.rocks:6969/announce
  • udp://tracker.v6speed.org:6969/announce
  • udp://47.ip-51-68-199.eu:6969/announce
  • udp://free-tracker.zooki.xyz:6969/announce
  • http://bt.okmp3.ru:2710/announce
  • udp://opentor.org:2710/announce
  • udp://engplus.ru:6969/announce
  • udp://inferno.demonoid.is:3391/announce
  • http://tracker.files.fm:6969/announce
  • udp://nagios.tks.sumy.ua:80/announce
  • udp://edu.uifr.ru:6969/announce
  • udp://tracker1.bt.moack.co.kr:80/announce
  • udp://peru.subventas.com:53/announce
  • udp://tracker.cyberia.is:6969/announce
  • http://tracker.noobsubs.net:80/announce
  • udp://mts.tvbit.co:6969/announce
  • udp://bt2.archive.org:6969/announce
  • udp://t3.leech.ie:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://bt1.archive.org:6969/announce
  • udp://tracker.army:6969/announce
  • udp://tracker2.dler.org:80/announce
  • udp://line-net.ru:6969/announce
  • udp://daveking.com:6969/announce
  • udp://tracker.theoks.net:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://discord.heihachi.pw:6969/announce
  • udp://open.publictracker.xyz:6969/announce
  • http://t.nyaatracker.com:80/announce
  • udp://udp-tracker.shittyurl.org:6969/announce
  • http://tracker.bt4g.com:2095/announce
  • udp://cdn-1.gamecoast.org:6969/announce
  • http://openbittorrent.com:80/announce
  • udp://retracker.lanta-net.ru:2710/announce
  • http://t.overflow.biz:6969/announce
  • https://1337.abcvg.info:443/announce
  • http://ipv4announce.sktorrent.eu:6969/announce
  • http://tracker-cdn.moeking.me:2095/announce
  • udp://public.tracker.vraphim.com:6969/announce
  • udp://tracker.moeking.me:6969/announce
  • http://h4.trakx.nibba.trade:80/announce
  • https://tracker.iriseden.eu:443/announce
  • https://trakx.herokuapp.com:443/announce
  • udp://public.publictracker.xyz:6969/announce