About This Club
Business Intelligence & Analytics with Excel
FREE Advanced Excel Course
We are forming a community to enhance our spreadsheet skills In next couple of months, I'll be sharing tutorials and exercises in this club so whether f you want to learn from beginning or the advanced concepts....
More Info
FREE Advanced Excel Course
https://www.facebook.com/free.advanced.excel.course/
https://www.linkedin.com/company/2463855/
do not miss this opportunity This is FREE course ...
We will be starting soon....
For next batches the course FEE is expected to be around $450 . However this time the course will be absolutely FREE.
How to Errol
- 1 Join this website
- 2 Join this club
- 3 Start with your introduction in Introduction Zone
Special Instruction - We recommend Office 365 or Excel 2019 - Get ready
- What's new in this club
-
Payal joined the club -
Deborah Nanua joined the club -
Michael Asare joined the club -
Abdulwakeel Aliu joined the club -
Madeline Elbe joined the club -
Drgham joined the club -
HdB joined the club -
Anderson Lopes joined the club -
Ignacio De.Bustamante F. joined the club -
Hema sundar joined the club -
PRAVEENA NANDAKUMAR joined the club -
Karthick Ravichandran joined the club -
Salma joined the club -
OLA ww joined the club -
Chinyere .C. Okechukwu joined the club -
Halaseh joined the club -
wendell corpus joined the club -
Mujaheed Ahmed.M joined the club -
Suresh chukka joined the club -
Andrew Onyango joined the club -
Senthil Kumaran joined the club -
Sindhuri joined the club -
Tiras Murage Peterson joined the club -
Kvothe joined the club -
Epsiba Gnanavathy joined the club -
Getrude joined the club -
Vishnu desai joined the club -
Ali Raza KHI joined the club -
Nimeshi joined the club -
Gopi Raja Chinka joined the club -
Ahmed Shiyan joined the club -
Sharon Lamptey joined the club -
Chandrasekhar Gullapalli joined the club -
Talal Butt joined the club -
Chetan Ramphul joined the club -
Wasonga joined the club -
shahid.ch joined the club -
Nilesh Maruti Mohite joined the club -
Aprajita Singh joined the club -
Sapuni Adithya joined the club -
Vivek Ambade joined the club -
Medha Patki joined the club -
Arifulla joined the club -
simt joined the club -
Kanchi joined the club -
Umme Kulsum joined the club -
Waliy joined the club -
Miloš joined the club -
Sivakumar joined the club -
MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files -
-
As-Salamu Alaikum (Peace be upon you), I am Ashrafu Alam, from Chittagong, Bangladesh. I worked at a steel industries as an Accounts officer. Now I am a lecturer at Kadalpur School and College. -
Hi team, I am trying to combine two simple excel files just to learn this power query and getting this massage: DataFormat.Error: External table is not in the expected format. Details: cd5hk2xn.XLS can you help please -
-
Download Excel file
-
-
Histogram Frequency Mean Mode Median Subtotals large Small Download dataset for practice
-
This is excellent tool for files in one folder. How can we do combining data from different worksheet in new worksheet within one file ? Is it possible.? I have attached the file. I want only coloured cells from worksheet - call , miss into follow up worksheet. combining data from differennt worksheet.xlsx -
hello, I was practicing scenario one - where change cell is unit price. Had a question. If I change the value in one of the unit price, doesnt it change the summary table by itself?
-
Hello thanks for the idea. i tried this. Extracted postal code with mid( ). When i use vlookup giving reference to this extracted postal code, it gives me error. I cooy postal code and paste as value. Still it gives me an error. Its only when i type the postal code, vlookup gives me data. Is there any way around to overcome this problem. Thanks Kashmirs
-
Thanks. Will try that.
-
You need to extract postal code in a different column and then it can be applied
-
Hi Can XLOOKUP / VLOOKUP be useful for the text in the cell. I have a city and postal code in B1 cell. And based on postal code in B1 cell, I want return - package center name . I have table for postal code and center name associated with that postal code. I tried using vlookup and xlookup, but I am not getting the result. Attached is the file. Thanks Kashmira XLOOKUP.xlsx
-
-
Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
-
excellent.......tips. thanks. -
Good day All, I am new here I want to improve my use of excel please I need your guidance . Thank you. -
In 2019 or office 365 https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
-
Is TEXTJOIN feature is only in 2010 excel ?
-
Hi What function to use if I dont want every first letter of the word to be upper case. If it is paragraph want only first word , first letter to be upper case. Thanks Kashmira
-
I just started learning from your tutorial and you really explain it very patiently. Learning a lot. Since I am not familiar with pivot table, I found this turotial little difficult to understand. I had to see it 2 to 3 times to understand it.
-
Yes you can ...Start with tutorial 1 In this post we should always ask about Xlook up we have a question section for general questions
-
Can i directly start directly with advanced ms excel or is there any introductory excel course? -
I cannot see the formula and secondly this question not related to the tutorial pl ask your question https://bi-analytics.org/forum/50-your-questions/ Share the objective and formula you have applied so any 1 can chip in to help you
