26 Jun 2019

Sync with a SharePoint tasks list

Sync with a new SharePoint site

These steps assume you have a project open in Project, but you haven’t made a SharePoint site for it yet.

  1. In Project, choose File > Save.
  2. Select Sync with SharePoint, and in the Sync with a list, select New SharePoint Site.
  3. In the Project name box, type a name.
  4. In the Site Address list, add the address of the SharePoint tasks list that you will sync to.
  5. Choose Save.

 

Snyc with an existing Sharepoint site

These steps assume you have a blank schedule open in Project, but all the tasks you want to sync to are on a SharePoint site somewhere.

  1. In Project, choose File > Save.
  2. In the Sync with a list, select Existing SharePoint Site.
  3. In the Site Address box, type the address of the SharePoint tasks list that you want to import.
  4. Choose Verify Site.
  5. In the Tasks List box, type or select a name for the tasks list that you want to sync with your project.
  6. Choose Save.
0 Comments
Article rating: No rating

17 Jun 2019

Essential Microsoft Office Skills to Have on Your Resume

Most hiring managers will expect a high level of proficiency in Excel, Word, and PowerPoint. You can improve your job prospects and be considered for more roles if you have the following skills:

Excel

  • Pivot tables: You can manage, sort, and analyze data in several ways if you’re able to master the art of the pivot table. Pivot tables do automatic actions like sorting and averaging to help you parse data quickly, using formulas, sorts and other functions that otherwise take hours to extract for data analysis.
     
  • Formula functions: Know the formulas for simple math calculations, and then learn commonly used skills such as how to link data from one worksheet to another, how to find information in large data sets using functions like VLOOKUP, and how to use the filter and subtotal functions to sort and present data in visually appealing formats.
     
  • Formatting: Worksheets that are formatted using consistent font sizing, brand-specific colors, and uniform spacing will be better received by colleagues and bosses. From tables to themes, Excel provides a host of formatting options you can apply to a worksheet to make it more readable and aesthetically pleasing. 

Word

  • Formatting & Page Setup: Formatting can involve things like fonts, styles, alignment, and color choices. Page setup includes things like page size, margins, borders, headers, and footers. 
     
  • Template Building & Editing: Once you create something you like you can save it as a template and reuse it again and again.
     
  • Using SmartArt & Text Boxes: A SmartArt graphics lets you quickly and easily make a visual representation of your information. A text box lets you add text anywhere in your file. For example, you can create pull quotes or sidebars that call attention to important information.

PowerPoint

  • Custom Slides & Templates: Employers want someone who can create an attractive slide from scratch. A successful candidate will be able to input new data into an existing template, manage design and layouts with master slides, and create new templates.
     
  • Animation: Adding animations to text and images can add excitement to a slide. Employers prefer a candidate who can tastefully and thoughtfully use this feature without going over the top
0 Comments
Article rating: No rating

11 Jun 2019

Employee Training from New Horizons is a Sound Investment

A business should never stand still and so nor should the development of your staff, who are the key asset in driving your business forward. Regular staff training is essential in helping this ongoing skill development.

Employee training continues to produce one of the highest returns on investment a company can make. IT training from New Horizons Minnesota yields a 4:1 return relative to costs and predicted increases in job performance.

  • More than 98% of our clients report utilizing knowledge and skills gained in New Horizons classes.
  • More than 50% of performance improvements are directly related to New Horizons training.

Visit our website at www.newhorizonsmn.com for a complete listing of courses. The list of courses is updated constantly, ensuring current titles contain up-to-the-minute information.

0 Comments
Article rating: No rating

19 Nov 2018

New Horizons Tips and Tricks - Business/Office Professionals

New Horizons Tips and Tricks - Business/Office Professionals

Specify a range within your workbook that other users may edit (Excel 365/2016)

Author: Anonym
0 Comments
Article rating: No rating

5 Nov 2018

New Horizons Tips & Tricks - Business/Office Professionals

New Horizons Tips & Tricks - Business/Office Professionals

Want to capture the moment? Know when to use TODAY, NOW, or a keyboard shortcut (Excel 2016)

Author: Anonym
0 Comments
Article rating: No rating
RSS

Theme picker