Microsoft Office Tutorials and References
In Depth Information
Managing Large Amounts of Data
4. Click OK. Figure 11-40 shows only those
records with dates in 2010.
Data filtered by date.
Years and quarters always start in January of
the calendar year.
Splitting Data into Multiple
In Chapter 9, you discovered how you can combine
columns using the Excel CONCATENATE function.
So if you had a first name (Mary) in column A and a
last name (Jones) in column B, you created a
formula that resulted in firstname lastname (Mary Jones).
Sometimes, you want to break the data down
instead of combining it. If you have a column with
Mary Jones in it but you really need a column with
the first name and another column with the last
name, you can have Excel do this task for you.
Available date filters.
2. Select a date filter. If you select a Common
filter, you see the Custom AutoFilter dialog
box. If you selected a dynamic filter, Excel
immediately applies the filter.
Look at Figure 11-41. You see data with a
combined first and last name. The following steps show
you how to break that into two separate columns:
To filter by a date range, select Between.
3. In the box on the right, enter a date or time
or, optionally, click the Calendar button to
select a date.