Image, Shape and SmartArt Collection

DESCRIPTION: Images, shapes and smartart can be very frustrating for newcomers especially when working with lots of images. The phrase I hear the most is “I just want to change the colour! That’s all! Why is it so hard?!?” The truth of the matter is, working with images and objects can be tricky because of all the little things you can do. The list seems endless because of all the customization options available. However, when mastered you can create beautiful pieces of art!

In this course we have 3 main sections we’ll be covering; images, shapes and smartart. With images, you’ll learn the basics of importing, resizing, styling, effects, layering and cropping. From there we’ll move onto the intermediate section where we’ll look at image corrections which allow you to control sharpness, brightness and contrast. Following will be colour adjustments, artistic effects, image compression which helps reduce Excel file size and increase performance, picture effects such as shadowing, reflections, glow, soft edges, beveling and rotation. Next comes image alignment and image grouping.

We’ll then move onto the shapes section where we cover everythig from using text boxes and shapes, custom formatting, arrows and arrow locking techniques, proportion adjustments, rotation and the quick duplication technique I like to use. In the intermediate section that follows, we’ll cover more styling, shape function controls, shape effects similar to the ones we used with images, the selection pane, layering and finally shape grouping.

Then comes smartart where I’ll show you how to create beautiful process maps, I’ll teach you how the indenting works, layout selection, colours, accents and styles. In the intermediate section I’ll show you how to adjust the shapes to suit your themes, shape effects, text effects and finally show you one of my favourite websites, ColourLovers.com

Lastly, we’ll cover some more grouping techniques which comes in very handy when handling multiple objects, shapes and images.

TARGET AUDIENCE: This course is suited for managers and those who use images and shapes a lot. Cases include, drawing process maps and creating diagrams with labels.

PROGRESS:    

DIFFICULTYBeginner/Intermediate

COURSE OUTCOMES:

  • Basics of inserting a pivot table based on existing information
  • Column heading selection
  • Grand and SubTotal implementation
  • Data Supression, Field List and Field Header Editing
  • Filtering
  • Banded Rows and Columns
  • Data Quick Styling
  • How to edit existing data and Pivot Table refresh
  • Filtering
  • Banded Rows and Columns
  • Data Quick Styling
  • How to edit existing data and Pivot Table refresh
Section 1: Images for Beginners

DESCRIPTION: A picture tells a thousand words! Images in Excel are usually underutilized or done very poorly. This is because most people don’t think of Excel as an image processor but think of it instead as purely a data processor. What they forget is that images are data!! Images can enhance the effect of your data as well as establish the feeling of the spreadsheet. Data is usually quite boring in comparison to an image and therefore the image becomes a focal point. The image will create an emotion in the reader and prepare them for the data. This is reason why images are so important in Excel and why everyone should know how to use them effectively.

DOWNLOADABLE FILES: 

 

Section 2: Images for Intermediates

DESCRIPTIONI’ve met many who hate handling images (myself included). When you get lots of images, shapes or objects, handling all of them at once or in groups can be very frustrating if you’re not familiar with the available image handling tools in Excel. This course continues on from the basics in the image beginners course which I suggest you take if you haven’t done so already. In this course I’ll teach more of the image editing functions available in Excel such as adjusting brightness, contrast, saturation, tone, colour as well as image compression for large, high-resolution images. In addition we’ll cover in detail the picture effect options such as shadowing, reflection, glow, soft edges, bevelling and 3D rotations. We’ll finish by using the image alignment and grouping functions.

DOWNLOADABLE FILES

 

Section 3: Shapes for Beginners

DESCRIPTION: Besides simply using tables all the time, Excel provides a wide range of object shapes you can use to guide the users eyes so that they can focus on specific areas. This gives a whole new dynamic to your spreadsheet as object shapes appear very differently to data tables, thus making them stand out more. In this course I’ll teach you the basics of using shapes. We’ll go through a number of different ones including textboxes, arrows, banners, callouts, flowcharts and much more.

DOWNLOADABLE FILES: 

 

Section 4: Shapes for Intermediates

DESCRIPTIONShapes are powerful tools in Excel simply because they don’t occupy cells. Instead, they overlap cells giving you another dimension of data presentation which is pleasing to the eye if done correctly. There are many customization you can apply to a single shape including rotation angle, bevels for 3D effects, shadows and reflections, textures and fills, alignments and more. In addition to the appearance control of the objects themselves is essential so you’re not wasting time trying to arrange them just right. Excel has built in functions that will allow you to manage all objects known as the selection pane. Alignments are performed by using the borders of each object. You’ll also learn how to layer objects and lastly how to use the grouping function so you can manage multiple objects as one.

DOWNLOADABLE FILES

 

Section 5: SmartArt for Beginners

DESCRIPTION: SmartArt is a fantastic way to present information in a graphical way. It allows you to create lists, process maps, life-cycle diagrams, hierarchies, relationship models, matrices and pyramids. The beauty of this function is that it’s available in all Microsoft Office products and thus this skill is transferrable. It’s so easy to do. Simply create bullet points and create hierarchies from that. SmartArt will automatically generate the image for you so you don’t have to do a thing.

DOWNLOADABLE FILES: 

 

Section 6: SmartArt for Intermediates
Section 7: Grouping and Ungrouping

DESCRIPTIONThe grouping function is a great way to minimize your spreadsheet without losing or having to delete important data. It allows you to temporarily hide rows or columns of data and provides a little switch to open it up again. It is very similar to hiding rows or columns except for the fact that a little open/close switch is provided so that you can clearly see that there is hidden data unlike the standard method of hiding. In this course you’ll learn how to apply grouping in both single and multiple levels, essentially creating hidden groups within other hidden groups. You’ll also learn one of my favourite techniques which is to use freeze panes with grouping on top allowing you more space to work in.

DOWNLOADABLE FILES: 

 

MORE BUNDLES