Microsoft Excel T...
Follow
545 views | +1 today
Microsoft Excel Training
Microsoft Excel Training
Information on Microsoft Excel Training courses
Your new post is loading...
Your new post is loading...
Scooped by Progressive training
Scoop.it!

Summing Only Positive Values (Microsoft Excel)

Summing Only Positive Values (Microsoft Excel) | Microsoft Excel Training | Scoop.it
If you have a series of values and you want to get a total of just the values that meet a specific criteria, then you need to become acquainted with the SUMIF function. This tip shows how it can be used to sum just the positive values in a list. (Tips.Net)
Progressive training's insight:

Summing Only Positive Values in Microsoft Excel 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Creating an Amortization Schedule in Microsoft Excel

Creating an Amortization Schedule  in Microsoft Excel | Microsoft Excel Training | Scoop.it
An amortization schedule is a report that shows how the outstanding balance on a loan changes with payments made over time. Usually they are created for property mortgages, but could be done for any type of loan. Here are some ideas on how you can make your own amortization schedules. (Tips.Net)
more...
No comment yet.
Scooped by Progressive training
Scoop.it!

3 Hacks to Keep Data Organized in Google Sheets

3 Hacks to Keep Data Organized in Google Sheets | Microsoft Excel Training | Scoop.it
For those who live and die by Excel spreadsheets (there are LOTS of you out there), take note: Google Sheets is rapidly gaining ground on Microsoft Excel as an enterprise-grade statistical and financi...
Progressive training's insight:

3 Hacks to Keep Data Organized in Google Sheets

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Adding Diagonal Borders (Microsoft Excel)

Adding Diagonal Borders (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Borders on all sides of a cell are easy to do in Excel. You can also create diagonal borders that run right through the middle of the cell. (Tips.Net)
Progressive training's insight:

Adding Diagonal Borders (Microsoft Excel)

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Power View and Maps in Excel

Progressive training's insight:

Power View and Maps in Excel - Excel Tips & Tricks.

We offer a onsite training at your Business across #Ireland 

See our range of Courses Here: http://goo.gl/BBXRzR

 

 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

133 Best Excel Resources: Tutorials, Guides, Add-ins, Templates, & Courses | SkilledUp

133 Best Excel Resources: Tutorials, Guides, Add-ins, Templates, & Courses | SkilledUp | Microsoft Excel Training | Scoop.it
Looking to freshen up in Microsoft Excel or learn it from scratch? Well, then you are in the right place. We spent weeks sifting though the chaff to bring you the very best Excel resources from guru blog sites and tutorials to templates, add-ins, and onli
Progressive training's insight:

133 Best Excel Resources: Tutorials, Guides, Add-ins, Templates, & Courses

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Daily Dose of Excel » Blog Archive » No you CANNOT have more of the same

Daily Dose of Excel » Blog Archive » No you CANNOT have more of the same | Microsoft Excel Training | Scoop.it
Progressive training's insight:

No you CANNOT have more of the same . Excel tips

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Daily Dose of Excel » Blog Archive » Navigating and Selecting Cells via the Keyboard

Daily Dose of Excel » Blog Archive » Navigating and Selecting Cells via the Keyboard | Microsoft Excel Training | Scoop.it
Progressive training's insight:

Navigating and Selecting Cells via the Keyboard

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Adding Text Boxes to Charts (Microsoft Excel)

Adding Text Boxes to Charts (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Need to add a text box to your charting masterpiece? There are a couple of ways you can do so. (Tips.Net)
Progressive training's insight:

Adding Text Boxes to Charts

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Shortcut for Viewing Formulas (Microsoft Excel)

Shortcut for Viewing Formulas (Microsoft Excel) | Microsoft Excel Training | Scoop.it
If you need to switch between viewing formulas and viewing the results of those formulas, you'll love the keyboard shortcut introduced in this tip. It's much easier to use than the normal menu method of toggling the display. (Tips.Net)
Progressive training's insight:

Shortcut for Viewing Formulas (Microsoft Excel) 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Center Printed Excel 2010 Worksheets | Daves Computer Tips

Center Printed Excel 2010 Worksheets | Daves Computer Tips | Microsoft Excel Training | Scoop.it
Progressive training's insight:

Center Printed Excel 2010 Worksheets

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Displaying Negative Times (Microsoft Excel)

Displaying Negative Times (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Excel allows you to perform math using times as operands. If you subtract a later time from an earlier time, you should end up with a negative time. If you don't see the negative time, it could be because of the way you have Excel configured. (Tips.Net)
Progressive training's insight:

Displaying Negative Times

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Correctly Saving Delimited Files (Microsoft Excel)

Correctly Saving Delimited Files (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Delimited files are often created through Excel so that your data can be exported to other programs. If the delimited data generated by Excel isn't exactly to your liking or expectation, there are ways that you can
Progressive training's insight:

Correctly Saving Delimited Files (Microsoft Excel)

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Rounding To the Nearest Even Integer (Microsoft Excel)

Rounding To the Nearest Even Integer (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Do you need your numbers to be rounded to an even integer value? How you accomplish the task depends on the nature of the numbers you are starting with. (Tips.Net)
Progressive training's insight:

 Rounding To the Nearest Even Integer in Microsoft Excel. 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Copying Named Ranges (Microsoft Excel)

Copying Named Ranges (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Named ranges are a great tool to use in developing formula-heavy workbooks. You may want, at some point, to copy your named ranges from one workbook to another. Here's the best ways to do it. (Tips.Net)
Progressive training's insight:

Copying Named Ranges in Microsoft Excel

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

How to Quickly Enter Similar Data in an Excel 2007 Worksheet

How to Quickly Enter Similar Data in an Excel 2007 Worksheet | Microsoft Excel Training | Scoop.it
Progressive training's insight:

How to Quickly Enter Similar Data in an Excel 2007 Worksheet 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

10 Tips, Tricks, Apps, and Add-Ins to Supercharge Microsoft Excel

10 Tips, Tricks, Apps, and Add-Ins to Supercharge Microsoft Excel | Microsoft Excel Training | Scoop.it
Progressive training's insight:

10 Tips, Tricks, Apps, and Add-Ins to Supercharge Microsoft Excel.

 We offer a onsite training at your Business across #Ireland . See our range of Courses: http://goo.gl/BBXRzR

#business #excel #training

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Increasing Undo Levels (Microsoft Excel)

Increasing Undo Levels (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Each time you take some action in Excel, the action is saved in an
Progressive training's insight:

Increasing Undo Levels (Microsoft Excel)

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Typing Check Marks into Excel (Microsoft Excel)

Typing Check Marks into Excel (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Need to enter a check mark into a cell? There are a number of ways you can get the desired character, depending on the font you want to use. (Tips.Net)
Progressive training's insight:

Typing Check Marks into Excel (Microsoft Excel)

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

How to Create a Single Cell Bulleted List in Excel | Daves Computer Tips

How to Create a Single Cell Bulleted List in Excel | Daves Computer Tips | Microsoft Excel Training | Scoop.it
Progressive training's insight:

How to Create a Single Cell Bulleted List in Excel 

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Office 365 Search is now smarter about spreadsheets - Office Blogs

Office 365 Search is now smarter about spreadsheets - Office Blogs | Microsoft Excel Training | Scoop.it
Progressive training's insight:

Office 365 Search is now smarter about spreadsheets

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Daily Dose of Excel » Blog Archive » A Better AutoFilter

Daily Dose of Excel » Blog Archive » A Better AutoFilter | Microsoft Excel Training | Scoop.it
Progressive training's insight:

 A Better AutoFilter for Tables

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Automatic Row Height For Merged Cells with Text Wrap (Microsoft Excel)

Automatic Row Height For Merged Cells with Text Wrap (Microsoft Excel) | Microsoft Excel Training | Scoop.it
When you have text wrap turned on in a cell, Excel expands the height of the row as you add more text to the cell. When you merge two cells that have text wrap turned on, Excel won't adjust the row height to accommodate the text in the cell. This can, of course, cause problems. How you deal with this situation is described in this tip. (Tips.Net)
more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Importing Custom Lists (Microsoft Excel)

Importing Custom Lists (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Custom lists are handy ways to enter recurring data in a worksheet. Here's how you can import your own custom lists from a range of cells. (Tips.Net)
Progressive training's insight:

Importing Custom Lists (Microsoft Excel)

more...
No comment yet.
Scooped by Progressive training
Scoop.it!

Inserting and Copying Rows (Microsoft Excel)

Inserting and Copying Rows (Microsoft Excel) | Microsoft Excel Training | Scoop.it
Want an easy way to insert a new row in a worksheet and copy everything from the row above? (You end up with two identical rows this way.) Here's a handy macro that can do this edit in one quick step. (Tips.Net)
Progressive training's insight:

Inserting and Copying Rows (Microsoft Excel)

more...
No comment yet.