Consolidating workbooks


Center Benefits - Microsoft Office Courses : • Free Online Skills Assessment Tests • Corporate Venue: Onsite or at Sites Power • UAE Ministry of Education Accredited Institute • International Curriculum • Certified Instructors • Computer Labs: 1 PC for each student • Certificate of Achievement (Ministry Attestation fees apply) COURSE OUTLINES FOUNDATION LEVEL COURSE OUTLINE Getting Started With Excel 2013 Starting Excel 2013 Selecting the Blank Worksheet Template The Excel 2013 Cell Referencing System Entering Numbers and Text Default Text and Number Alignment Summing a Column of Numbers Entering a Date Worksheets and Workbooks Saving a Workbook to Your Hard Disk Closing a Workbook Creating a New Workbook Opening a Workbook Opening a Recently Used Workbook Pinning Files and Folders Switching between Workbooks Saving a Workbook Using another Name Saving a Workbook Using a Different File Type Getting Help within Excel 2013 Searching For Help The Help 'Table of Contents' Printing a Help Topic Alt Key Help Using Other Excel Templates Excel 2013 Selection Techniques Why Are Selection Techniques Important?

consolidating workbooks-18consolidating workbooks-29consolidating workbooks-40

To learn more about Templates, see: Create a template.

This is also an ideal time to set up your template with Excel tables.

Formula Speeding-up Tips VBA / Macros Optimization Tips Everything Else Share your tips Tips for Formula speeding up by Adam B of Perth I use Formula-Calculation Options-Manual to disable calculations when setting up complex inter-relating formula pages.

This stops Excel from churning through calculations every time I change a cell, saving my time. Calculation = xl Manualto speed up macros, and Application.

I just hit F9 to recalculate when I want to see the results. Status Bar = Loop Numso I can see the status of my macro and estimate how long there is left to calculate.