Consolidating multiple excel workbooks

Technical : 7 PDUs Business & Strategic : 4 PDUs Read more ...

For more on the Project Management Institute and a full list of courses approved for PDUs.

consolidating multiple excel workbooks-51

They can combine formulas with conditional formatting to highlight data that meets almost any condition.

Introduction 5 Tips on CF Highlighting Duplicates More There is no use if all your analysis is buried in a massive spreadsheet.

Advanced: Collaborate with others using workbooks; Audit worksheets; Work with multiple workbooks; Import & export data; Use Excel with the web; Structure workbooks with XML.

On completion of this course that includes practical exercises, the participant will be issued with an Adapt IT Certificate of Completion.

For example: highlighting top 10 customers, below average performing employees etc.