Hi - As I've explored SORT and EXCEL customization options, I've not seen a way to go beyond 3 fields. Most likely you can concatenate fields (e.g., columns A+B) to get a few more. There might also be a way to specify a Sort Range
It's not a show-stopper for me, as I've been getting by. Still, more precision in sorting would make my analytical work of financial results easier. I'd welcome any links and ideas on how to accomplish this, as I value the expertise in these forums. Thank you
Anyone looking for an introductory tutorial on using VBA in Excel should
take a look at the new four part series at TechBookReport. The tutorial
is he http://www.techbookreport.com/tutorials/excel_vba1.html
--
TechBookReport: http://www.techbookreport.com
Hey guys,
Can any one point me towards a tutorial on how to set up meeting requests from Excel to Outlook?
I know this involves codes/scripts but I wouldn't know where to start
Cheers
Hi, I'm new to this forum. Just wanted to give a link to a basic Excel tutorial my students enjoyed. Looking over this forum, it's may be too basic. It just teaches formatting, the AutoSum button, a basic formula, etc. I don't teach anymore and I miss being 'helpful'. Maybe some of you have a youngster who's just learning Excel. I gave this lesson to 4th through 6th grades, and some of them actually wanted a second tutorial like this one. Anyway, sorry for the long post...here's the link:
http://www.associatedcontent.com/art..._tutorial.html
Anyone knows some sites where they give free excel video tutorials? Appreciate it.
I get raw data that I wish to rearrange the columns. If I place a value, let's say, in row 20 of each column by which I want the columns to be sorted/rearranged by is there a method for performing this?
Any good ones online that are like projects? I've seen ones that are
more like reference manuals, but i would like to work on ones that
simulate projects dealing ROI, P/E ratio, etc or anything in nature
like that. Thanks
Hi,
I've made an Introduction to SQL tutorial aimed at Excel users.
I would love to hear feedback on how to improve the tutorial, especially
if you are an Excel user without much existing SQL knowledge.
http://www.querycell.com/SQLIntro.html
Cheers
Sam H
I have problems with formulas & functions, and the online tutorial wasnt
helpful. I geuss i don't get the help either....
I have gotten to a point in my database where I will need to use Excel as a way to "export" an attendance sheet and then import the collected info once returned. I am wanting to find some good sites explaining some of the ways to do this (I assume most of it is VBA).
Any links/direction is appreciated!