Got a quick question or comment?
Send us enquiry.
Enter your details and we will call you back to discuss your requirements
Got a quick question or comment?
Send us enquiry.
Enter your details and we will call you back to discuss your requirements
Who Should Attend the Course?
Users with a basic understanding of Microsoft Excel 2010 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. Delegates are required to bring with them there own laptop with the Software already installed.
Course Outline
Advanced File Tasks
• Using Windows Explorer within Excel • Saving your Files • Using File Management Tools, Part One • Using File Management Tools, Part Two
Working with Functions and Formulas
• Using Formulas in Excel • Exploring Excel Functions • Using Functions in Excel • Working with Names and Ranges • Working with Array Formulas
Managing Tables
• Working with Tables • Working with Records and Fields • Working with Tables and Filters • Using Excel as a Database
Adding the Finishing Touches
• Research Tools • Using Themes • Adding Text Boxes • Inserting Pictures and ClipArt • Editing Pictures
Showing Data as a Graphic
• Inserting SmartArt • Formatting SmartArt • Adding Symbols, Equations, and Shapes • Sparklines • Editing Sparklines
The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.
Describes and shows what has been updated within the Microsoft suite for Excel, Word, PowerPoint, Access & Project for 2007 & 2010
Please arrive at the venue for 08:45am
Click Microsoft OFFICE button, click relevant OPTIONS button. Within OPTIONS click RESOURCES to find your version.
Click the FILE tab. In BACKSTAGE view, click HELP. Within PRODUCT ACTIVATED, find your version.
We do not currently have a video for this topic
There hasn't been any testimonials submitted to this topic