Health in All Policies (HiAP)

California Health in All Policies Task Force

More information about the California Health in All Policies Task Force is available at http://www.sgc.ca.gov/hiap.

Health in All Policies Resources

Health in All Policies: A Guide for State and Local Governments

Health in All Policies: A Guide for State and Local Governments was created by the Public Health Institute, the California Department of Public Health, and the American Public Health Association in response to growing interest in using collaborative approaches to improve population health by embedding health considerations into decision-making processes across a broad array of sectors. The Guide draws heavily on the experiences of the California Health in All Policies Task Force and incorporates information from the published and gray literature and interviews with people across the country.

The guide was developed through funding from the American Public Health Association and The California Endowment.

Visit the Public Health Institute website to download Health in All Policies: A Guide for State and Local Governments.

Health in All Policies: Improving Health Through Intersectoral Collaboration

In this discussion paper, which was prepared for the Institute of Medicine Roundtable on Population Health Promotion, Dr. Linda Rudolph and colleagues explain the need for Health in All Policies approaches to confront complex and current health challenges in the population and provide an overview of California's pioneering experience with cross-sectoral collaboration to address the social determinants of health. The paper includes an analysis of key challenges and opportunities likely to arise when communities undertake health in all policies efforts.
Visit the Institute of Medicine website to download a Health in All Policies: Improving Health Through Intersectoral Collaboration.

Contact Information

Health in All Policies
California Department of Public Health
Office of Health Equity
P.O. Box 997377, MS 0022
Sacramento, CA 95899-7413
hiap@cdph.ca.gov

Office of Health Equity Quick Links Office of Health Equity - Home Page

Contact the Office of Health Equity Contact the Office of Health Equity

This Test Can Read Your Mind in 6 Steps. Seriously, It's 100% Accurate

What Should You Stop Doing To Make Your Life Better?

Training courses for Office 365 for business

All users

Get to know Office 365


Watch these videos to become familiar with Office 365 and how to read email, share documents, and more.

Download | Watch online

Share or publish your Office 365 calendar

Share or publish your calendar so others can view your appointments and meetings.

Download | Watch online

Training courses for Visio 2013

Beginner

Shapes, stencils, and templates in Visio 2013

Shapes, stencils, and templates are the main building blocks of Visio 2013. Mastering them is the key to making meaningful diagrams for almost every purpose.

Download |  Watch online

Training courses for SharePoint 2013

Beginner

Create and manage a blog to share information

This course teaches you how to create and manage a SharePoint blog. Topics include basic tasks such as creating a blog, using categories, and modifying post layouts. Also learn how to set unique permissions for a blog, and also in lists and libraries within a blog.

Download | Quick Reference Card

Create and set up a list

This video-based training course teaches you how to create SharePoint lists using built-in apps, create and edit views of the lists, share lists with others, and set alerts so you can be notified automatically when lists change.

Download | Quick Reference Card

Customize your public website

With Office 2013, or an Office 365 subscription that includes Office 2013 applications, you can sync your OneDrive for Business and other SharePoint libraries to your computer. You can then work with your library files directly in your file system, and have access to your files when you’re offline. This training course shows you how.

Download

Follow content

Following documents and SharePoint sites makes it easy for you to stay abreast of newsfeed activity. There’s no need to search for files to check their update status because you automatically receive notifications in your newsfeed whenever updates occur. This course shows you how to follow documents in OneDrive for Business or a SharePoint library and keep track of SharePoint web sites that interest you.

Download | Quick Reference Card

Introduction to document libraries

This course teaches you how to perform common tasks in a document library. Topics include ways to use a document library, uploading and editing files, and checking file version history.

Download | Quick Reference Card

Post to the newsfeed

The newsfeed is a micro blog where you and people in your organization share ideas and information. Newsfeed posts can include a variety of features, such as pictures, videos, links and tags.

Download | Quick Reference Card

Start using a list

A SharePoint list is a handy tool for sharing contacts, calendar appointments, tasks, or data with team members and site visitors, and provides the underlying structure for organizing information on your site. This course explains the basics and shows you how to work with SharePoint lists.

Download | Quick Reference Card

Sync libraries using OneDrive for Business

With Office 2013, or an Office 365 subscription that includes Office 2013 applications, you can sync your OneDrive for Business and other SharePoint libraries to your computer. You can then work with your library files directly in your file system, and have access to your files when you’re offline. This training course shows you how.

Download | Quick Reference Card

Update profile and privacy settings

A user profile is one of the social features of SharePoint Online that enables employees to easily collaborate and share knowledge. The profile contains information you’d expect to find such as name, department, and areas of expertise. But it contains contact and personal information you might want to include as well. This course teaches you how to edit your profile so you can provide all the salient details you want your co-workers to know. You’ll also learn how to update profile and newsfeed privacy settings so you can identify those details you’d prefer to keep private.

Download | Quick Reference Card

Training courses for Publisher 2013

Intermediate

Make the switch to Publisher 2013

Get started making the switch to Publisher 2013. Learn how to select a template, use the ribbon, save publications as templates, find your templates after you save them, and use images.

Download | Watch online

Training courses for Project 2013

Beginner

Get started with Project

In this 15 minute webinar, you’ll learn the very basics: adding tasks and linking tasks. You’ll also learn how to add holidays to the project calendar so that you can plan for days off.

Watch online

Assigning resources in Project

In this webinar, we'll assign people to tasks and use the Resource Sheet to track people in your project. Plus, we'll learn how to add vacation days--and adjust the project accordingly so that we make our deadline.
Watch online

Create a timeline in Project

This webinar will get your project ready for kickoff. You’ll learn how to make milestones, summary tasks, and subtasks. Plus, we’ll show you how to create a graphical timeline you can share with stakeholders.

Watch online

Tracking progress in Project

This webinar tutorial will show you how to track progress once a project starts. We’ll show you how to mark tasks complete, and we’ll run some reports that can give you an idea of what’s on time and what’s not. We’ll also explain a couple of key concepts on the way too: critical tasks and baselines.

Watch online

Training courses for OneNote 2013

Beginner

Create your first OneNote 2013 notebook

Watch these videos to learn how to use OneNote 2013. Get started with the new version to see how to do everyday tasks.

Download | Watch online

Using Tables in OneNote

See some of the new table features in OneNote 2013, including how to add, format and sort a table and how to convert a table to an Excel spreadsheet.

Download | Watch online

Training courses for Lync 2013

Beginner

Set up Lync 2013

Learn how to get started sending IMs, making calls, setting up and attending meetings, and generally working more efficiently than ever using Lync 2013.

For Lync 2013:    Download | Watch online

For Lync 2013 for Office 365:    Download | Watch online

Presence, IM, and Contacts

Learn how to get started sending IMs, making calls, setting up and attending meetings, and generally working more efficiently than ever using Lync 2013.

For Lync 2013:    Download | Watch online

For Lync 2013 for Office 365:    Download | Watch online

Make Audio and Video Calls

View these short videos to see how to use Lync 2013 to make audio and video calls.

For Lync 2013:    Download | Watch online

For Lync 2013 for Office 365:    Download | Watch online

Training courses for Outlook 2013

Beginner

Add and use contacts

Organize and keep track of people you know with Outlook contacts, which work like a personal address book.

Download | Watch online

Calendar basics

Watch these videos to get familiar with the calendar in Outlook 2013. You can keep things simple, or use Outlook to manage complex meetings and schedules.

Download | Watch online

Fonts, hyperlinks, and spell check

Change fonts for email messages that you send, forward, or reply to. Add hyperlinks, and adjust settings for the spelling and grammar checkers and AutoCorrect.

Download | Watch online

Recall and replace sent messages

You send an email message, and then you start to have second thoughts. In Outlook 2013, you can recall or replace email that you've sent. Or you can resend an email to try to repair the damage. Here's how it works.

Download | Watch online

Send automatic replies when you’re out of the office

Set up automatic replies, set a time range, use rules to manage your inbox while you’re out, and create different out-of-office messages for different groups, with or without a Microsoft Exchange account.
Download | Watch online

Send and open attachments

You can use attachments to include one or more files on any email you create. Open or save attachments with the program associated with the attachment file type.

Download | Watch online

The ins and outs of BCC

If you want to hide the names and addresses of recipients in an email, you can use Bcc, which stands for “blind carbon copy”. Here's how it works.

Download | Watch online

Use Instant Search to find Calendar items

Use Instant Search to find things in your Outlook Calendar fast, and learn about scope and more ways to refine your search.

Download | Watch online

Use Instant Search to find contacts

Use Instant Search to find people in your personal contact lists fast, and learn about scope and more ways to refine your search.

Download | Watch online

Use Instant Search to find messages and text

Use instant search to find email messages containing text that you specify, or that meet criteria such as sender, recipient, or time sent.

Download | Watch online

Training courses for PowerPoint 2013

Beginner

Apply and change a theme

You created slides for your presentation, and now you’re thinking about slide design: the background design, font styles, colors, and layouts. You want the slides to have a bit more visual pop. How do you get that? With themes. Themes provide a complete slide design for your presentation.

Download | Watch online

Apply transitions between slides

Slide transitions are the effects that occur when you move from one slide to the next during an on-screen presentation. Here’s how to work with them.

Download | Watch online

Create your first PowerPoint 2013 presentation

Watch these videos to learn how to use PowerPoint 2013. Get started with the new version to see how to do everyday tasks.

Download | Watch online

Highlight text and change fonts

Highlight text, user your mouse as a laser pointer when presenting, and change fonts in part or all of your PowerPoint 2013 presentation.

Download | Watch online

Print slides, notes, or handouts

You’ve finished creating your presentation, and now you want to print handouts for your audience. PowerPoint gives you several choices: you can print full page slides, multiple slides per page, or slides with your presenter notes or room for the audience to take notes next to the slides. If you want richer formatting, you can use Word to edit content, apply styles, and then print.

Download | Watch online

Use Presenter view

Watch these videos to learn how to use Presenter view in PowerPoint 2013 to separate what you see from what your audience sees.

Download | Watch online

Training courses for Word 2013

Beginner

Create your first Word 2013 document

Watch these videos to learn how to use Word 2013. Get started with the new version to see how to do everyday tasks.

Download | Watch online

Custom margins in Word 2013

Watch these tutorial videos to learn how to set a custom margin, and a default margin in Word 2013. Plus, learn how to change the margins of your headers and footers.

Download | Watch online

Introduction to Tables of Contents (TOCs)

You create a table of contents (TOC) by applying heading styles — for example, Heading 1, Heading 2, and Heading 3 — to the text that you want to include in the table of contents. Word 2013 searches for those headings and then inserts the table of contents into your document. Then you can automatically update your TOC if you make changes in your document.

Download | Watch online

Top tips for working in Word Online

Here are the top tips to help you get the most out of Word Online. Learn how to get started, save your work to OneDrive, add and review comments, edit, and print.

Download | Watch online

Track changes

Track changes records every edit without making anything permanent. You can move, copy, delete and insert text, change formatting, even change pictures and insert objects. And the person who sent you the document can see the changes you made and decide whether to accept or reject them. Or you can do the same when others make changes to your document.

Download | Watch online

Work with word counts in your document

Watch this video to learn how to track the word count in your document as you work. And if you need to print your document, learn how to insert and update the word count in to the body of your document.

Download | Watch online

Training courses for Excel 2013

For Beginner

Add numbers in Excel 2013

Watch these videos to see how Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).

Download | Watch online

Basic math in Excel

Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.

Download | Watch online

Create a chart

Charts provide a visual representation of your data, making it easier to analyze. Each type of chart highlights data differently. And some charts can’t be used with some types of data.

Download | Watch online

Create your first Excel 2013 workbook

Watch these videos to learn how to use Excel 2013. Get started with the new version to see how to do everyday tasks.

Download | Watch online

Freeze or lock panes

You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it's always visible. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.

Download | Watch online

Top tips for working in Excel Online

Use Excel Online to change the formatting of numbers and text to help make your information stand out. And see 3 ways to quickly add numbers, too.

Download | Watch online

Understand and use cell references

One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell's location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.

Download | Watch online

Use AutoFill and Flash Fill

Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be, and going through the entire list manually to correct it is daunting. In this case, Flash Fill (a new feature in Excel 2013) can do the work for you. AutoFill and Flash Fill are tremendous time savers, and in this course, we’ll cover them in more detail.

Download | Watch online

See all characters in font set

1. Enter =CHAR(ROW()) in row 1
1. =ROW() return the row you're in. =ROW() entered in cell G23 returns 23.
2. =CHAR(97) returns the 97th character in the character set for that font, usually a lowercase "a" (picture fonts like Wingdings or Webdings return something else).
2. Fill down to row 255.
3. Easy to see things like ●, ¢, £:

4. When you see that "●" is in row 149, you can then know that holding Alt while typing 0149 on the numeric keypad will create this character as soon as you let go of the Alt key! And this holds true for all of Office, not just Excel! You can copy/paste special characters for the character(s) you want, and you can then copy the resulting character from the formula bar.

 TOP OF PAGE

Tip 74: Bringing the selection into view

It's possible you've selected some areas of cells and the scrolled away so you can't see it any more. CTRL/Backspace brings that selection into view, and shift/Backspace brings selection into view as well but reduces the selection to the active cell. So, if this is the before picture:

Then shift/backspace will simply have cell B3 selected.

Selecting a random sample of data

If you have a database with many records and you want to take a random sample of that data, here are a few techniques you can use.

One way to get a random sample is to use a computed criteria and advanced filter.

Suppose you want to take a random 10% of the data. Enter the formula as shown in C2 (keep C1 blank). By entering the formula = RAND()<0.1, every time this worksheet calculates, the =RAND() will return another random number. So RAND()<0.1 will return true, about 10% of the time.

(Rand() returns a random value between 0 and 1, not including 1).

Using the Advanced button from the Data tab: [Excel 2003:Date|Filter|Advanced Filter]

You can filter like this:

and that will create a random selection:

This will be different each time. You may notice that there are only 9 items shown not 10, and that's because the values RAND returns are random! It's best to use this on larger databases!

A second way to select a random 10% of your data is to still use the RAND function, but not use filtering. Look at this:

Cells B2 thru B101 contain = RAND(). All you need do is select A2:B101 and sort by column B! Take just the first 10 items, and you have your random 10% of the database!

Formatting comments

When most people create a comment (Review Tab, New Comment, or Shift/F2), [Excel2003:Insert|Comment], they accept the shape and color and just enter the information they want. So most comments look something like this:

But how about a comment like this?

Or even this: (It's me!)

Here's how you can do it:

When you first create a comment, the cursor is right after whatever you typed. You need to select the comment itself, not the text inside. So, select the border of the comment.

You need the "Change Shape" tool. This can be placed on the Quick Access toolbar: [Excel 2003: View|Toolbars| Drawing|Draw Menu|Change AutoShape]

When the comment is selected by the border, click the new Change Shape tool.

From that, you can select basic shapes, block arrows, flowcharts, stars and banners, or callouts, each of which has yet another set of shapes to choose from. Shown here is the Cloud callout:

Once you have the new shape, (cloud, here), right-click the border once again, and choose Format comment as shown, if you wish to format this comment even further:

That will bring up yet another dialog, from which you can choose Fill Effects:

From this dialog box you can select the Picture tab and import any picture (I chose me!).

As you saw before.

Using Pictographs

Anything in the clipboard can be pasted onto a chart

Clicking on the coins, copy (ctrl/c), click on a series, Home/paste (or ctrl/v):

Right-click on the series, use Format Data Series:

Click these options: [Excel 2003:Patterns tab|Fill Effects]

There are 3 format options:

1. Stretch (default)
2. Stack
3. Stack and scale to

If we select Stack, we see:

If we select Stack and scale, we can enter a number into the Unit/Picture box. Again, this is something you can experiment with.

You also may have noticed these options in this dialog:

• Gradient fill
• Picture or texture fill
• And others

Here's the gradient option selected and the Preset colors dropdown:

The new chart:

On the picture tab there was a button to select a picture−you can use any picture you have on your computer! You can experiment with the other tabs as well.

Change dates like 20050923 to one Excel can "understand"

Suppose you are looking at a worksheet which contains dates which can't be formatted as "real" dates because of their structure:

Select the date(s), and use Data tab, Text-to-Columns, [Excel2003:Data|Text to Columns]

Which brings up the Text-to-Columns wizard:

Even though the dates are fixed width, in this case you can simply click "Next" twice.

In step 3 of wizard Select Date, YMD:

If you click Finish now, the result will replace the dates. You can select another destination cell:

Here's the result:

Double Click Format Painter

Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It's quite a time-saver.

Tab Between Worksheets

Jumping from worksheet to worksheet doesn't mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PGDN. And conversely change to the worksheet to the left by entering CTRL + PGUP.

Copy a Pattern of Numbers or Even Dates

Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells. Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!

Adjust Width of One or Multiple Columns

It's easy to adjust a column to the width of its content and get rid of those useless ##### entries. Click on the column's header, move your cursor to the right side of the header and double click when it turns into a plus sign.

Add or Delete Columns Keyboard Shortcut

Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL + ‘-‘ (minus key) will delete the column your cursor is in and CTRL + SHIFT + ‘=' (equal key) will add a new column. From an earlier tip, think about CTRL + ‘+' (plus sign).

Repeat a Formula to Multiple Cells

Never type out the same formula over and over in new cells again. This trick populates all of the cells in a column with the same formula, but adjusts to use the data specific to each row.

Create the formula you need in the first cell. Then move your cursor to the lower right corner of that cell and, when it turns into a plus sign, double click to copy that formula into the rest of the cells in that column. Each cell in the column will show the results of the formula using the data in that row.

Jump to the Start or End of a Column Keyboard Shortcut

You are thousands of rows deep into your data set and need to get to the first or last cell. Scrolling is OK but the quickest way is to use the keyboard shortcut CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.



When you combine this shortcut with the SHIFT key, you'll select a continuous block of cells from your original starting point.

Display Formulas with CTRL + `

When you're troubleshooting misbehaving numbers first look at the formulas. Display the formula used in a cell by hitting just two keys: Ctrl + ` (known as the acute accent key) – this key is furthest to the left on the row with the number keys. When shifted it is the tilde (~).

Logic for Number Formatting Keyboard Shortcuts

At times keyboard shortcuts seem random, but there is logic behind them. Let's break an example down. To format a number as a currency the shortcut is CRTL + SHIFT + 4.

Both the SHIFT and 4 keys seem random, but they're intentionally used because SHIFT + 4 is the dollar sign ($). Therefore if we want to format as a currency, it's simply: CTRL + ‘$' (where the dollar sign is SHIFT + 4). The same is true for formatting a number as a percent.

Automatically SUM() with ALT + =

Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=' (equals key) to add up the numbers in every cell above.