babymore87
MyBoerse.bz Pro Member
Microsoft Excel From Beginner to Confident User
Published 9/2026
Created by Ajay Anand
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All Levels | Genre: eLearning | Language: English | Duration: 60 Lectures ( 3h 23m ) | Size: 1.7 GB
Master Excel Formulas, PivotTables, XLOOKUP, Charts, and Dynamic Arrays
What you'll learn
Navigate Excel confidently and use it for real work from day one Write formulas and functions - SUM, IF, VLOOKUP, XLOOKUP, and more Analyse data instantly with PivotTables, Slicers, and PivotCharts Build charts and visualisations that communicate clearly Clean and reshape messy data using Text and Date functions Use Dynamic Arrays - FILTER, SORT, UNIQUE, SEQUENCE, and more Protect sheets, validate data input, and apply conditional formatting Work faster with keyboard shortcuts, Flash Fill, and Excel TablesRequirements
No prior Excel knowledge needed - we start from absolute zero A computer with Microsoft Excel installed - any version from Excel 2013 onwards Excel with Microsoft 365 is recommended for Dynamic Arrays (covered in the final section)Description
Short lessons. Real confidence. No fluff.
Most Excel courses are long, slow, and full of repetition. This one is different. Every video is two to three minutes long - focused, direct, and straight to the point. You watch one video, practise it, and move to the next. At your own pace.
By the end of this course, you will be able to write formulas that analyse data instantly, build PivotTables in two clicks, create professional charts, look up anything in any table using XLOOKUP, and build live dashboards with Dynamic Arrays - all with genuine confidence.
Course in Progress - Early Launch Price
This course is currently being published in stages. Sections 1 through 6 are fully available right now - over 60 videos covering Excel basics, formatting, formulas, data tools, and lookup functions. The remaining sections on Text & Date functions, Charts, PivotTables, Dynamic Arrays, and Shortcuts will be added by 25 September 2026.
Enrol now at the early launch price and get lifetime access to all videos as they are added - including everything still to come.
What is available right now
Section 1 - Getting Started with Excel (8 videos)
Section 2 - Entering & Formatting Data (10 videos)
Section 3 - Essential Formulas (12 videos)
Section 4 - More Formulas - References, Error Handling, Logic (5 videos)
Section 5 - Working with Data - Sort, Filter, Tables, Validation, Conditional Formatting (10 videos)
Section 6 - Lookup & Reference Functions - VLOOKUP, INDEX MATCH, XLOOKUP (7 videos)
Coming by 25 September 2026
Section 7 - Text & Date Functions
Section 8 - Charts & Visualisation
Section 9 - PivotTables & PivotCharts
Section 10 - Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE, XLOOKUP, XMATCH)
Section 11 - Tips, Tricks & Shortcuts
Full course topics
• Excel basics - interface, navigation, shortcuts, saving and managing files
• Entering and formatting data - number formats, Flash Fill, Paste Special, Freeze Panes
• Essential formulas - SUM, AVERAGE, COUNT, IF, SUMIF, COUNTIF, IFERROR, AND, OR, and more
• Working with data - Sort, Filter, Excel Tables, Remove Duplicates, Data Validation, Conditional Formatting
• Lookup functions - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP, XMATCH
• Text and date functions - LEFT, RIGHT, MID, TRIM, SUBSTITUTE, TEXTJOIN, TEXT, DATEDIF, EDATE
• Charts and visualisation - Column, Line, Pie, Combo charts, Sparklines, dynamic charts with Slicers
• PivotTables and PivotCharts - grouping, calculated fields, Slicers, Timelines, value settings
• Dynamic Arrays - FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY, HSTACK, VSTACK, XLOOKUP, XMATCH
• Tips, tricks and shortcuts - 20 essential shortcuts, Go To Special, Camera Tool, Watch Window and more
Who is this course for?
Complete beginners who have never used Excel, and people who have been using it for years but never properly learned it. If you open Excel and still feel unsure - this course will change that.
What makes this different?
Two to three minutes per video. Every lesson covers one thing clearly, with no filler and no going around the same point twice.
Every section comes with a practice file - built around the same real data used in the videos, so you are working on something familiar, not a disconnected exercise.
For sections where you are solving something - formulas, lookups, text functions, PivotTables, Dynamic Arrays - you get two files. The first is a starter file with the data set up but the solutions left blank, so you can try it yourself. The second is the completed file with all the answers filled in, so you can check your work and see exactly how it was done.
This two-file approach is the difference between passively watching Excel and actually learning it.
About the instructor
Ajay Anand is a seven-time Microsoft Excel MVP (2019-2026) and has been teaching Excel since 2018. He runs two YouTube channels - one in English, one in Malayalam - and his teaching style is known for being direct and practical.
Who this course is for
This course is for anyone who is new to Excel or has used it a little but never properly learned it. If you have been clicking around Excel and figuring things out as you go, this course will fill the gaps and give you a solid, organised foundation. It is also for people who know the basics but want to go further - into lookups, PivotTables, and Dynamic Arrays - without sitting through a 20-hour course to get there.Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
No Password - Links are Interchangeable
