New Feature: Community Post Notifications

We are excited to announce a new feature for our online learning platform.
When someone creates a new post in the Community Forum you will automatically receive a notification.

And don’t worry, if you’re not excited about this, you can turn the feature off.
Why is this Exciting?
The reason we are excited is because we hope that this feature will increase engagement and participation in the community.
When you create a post, more members will see your question and have an opportunity to help you out. This means your question will get answered faster and with more options and opinions.
On the flipside, when you receive a notification of a new post, you can help your fellow Elevate members by responding.
As I always say, there are million ways to solve a problem in Excel. So don’t be afraid to answer a question even if you are not sure if it is the “best” solution. The great part about the Community Forum is that it is a collective knowledgebase where we can all learn from each other’s experiences.
How to Turn Notifications On/Off
The notifications for new posts are ON by default. So, if you like the notifications, you don’t need to anything.
You can turn them off by clicking your name in the top right-corner > Account > Notification Settings.

Scroll down to the Social Groups section and uncheck the boxes for the New post in a group you’re subscribed to option.

Then scroll down and click the Save Changes button.

Please reach out to us at [email protected] if you have any questions.
Hi everyone,
I’m not sure how this Community section works, so let me explain my problem.
I have a “master” consolidation file called “DataCons”, to which I wish to import various data items from each of many external files. DataCons contains, down its column A, the short-form name of various closed source data files, ex: INTC (on row 1). The full path and file name for INTC can easily be copied and placed in col B, row 1 on down. My intent is to create a “generic” version of the complete file name in column B of DataCons, for each row of DataCons, such that I can then reference each external file (on one per row of DataCons), and link specific cell (say C2 of source file) or range data results from the source file(s) to various columns of DataCons on those row(s) corresponding to the short-form filename (INTC, in A1). That is, all data for INTC will be placed on INTC’s row (1), columns whatever. Data for the next row’s reference file will occupy cells on the next row, etc.. And so the need arises to >copy the formula< that specifies the filename (col B) on the row for INTC, placed in column C, down to row "X", in order to be able to reference all external files and import relevant data into DataCons. Hours and hours of effort on my part have not met with success. Any help would be most appreciated – thanks.
Hi Michel,
Thanks for posting! 🙂 The Community forum link is below. If you can copy your same comment from here and post it there, the Community will be glad to jump in and help! 👍
https://learn.excelcampus.com/groups/elevate-excel-training-program/
Let us know if you have additional questions.
Have a great weekend! 🙂
P.S. You can also upload a sample file and/or screenshots there!