Excel 2007 Training

Back to Culture & Humanities  Back To Edmond Home Page

1- Getting started with Excel (Open Exercise file)

11- Why use a spreadsheet?    Play Video

12- What’s changed in excel 2007? Play Video

13- The Ribbon.    Play Video

14- The Microsoft Office Button. Play Video

2- Setting up excel 2007 (Open Exercise file)

21- What’s on the Ribbon. Play Video

22- Making your way around the Ribbon. Play Video

23- Customizing the Ribbon. Play Video

24- Customizing the Microsoft Office Button. Play Video

3- Modifying Worksheets (Open Exercise file)

   31- Opening old Worksheets.    Play Video

   32- Adding and deleting Worksheets. Play Video

   33- Inserting and Deleting cells. Play Video

   34- Freezing Areas of a Worksheet. Play Video

4- Basic Formatting (Open Exercise file)

    41- Width and Height.    Play Video

   42- Numeric Formats.    Play Video

   43- Alignment of Data.    Play Video

   44- Playing with Fonts. Play Video

   45- Auto Filter. Play Video

   46- Formatting as a Table.    Play Video

5- Advanced Formatting (Open Exercise file)

    51- Removing Duplicates. Play Video

   52- What is Conditional Formatting? Play Video

   53- Working with Conditional Formatting. Play Video

   54- Managing Conditional Formatting Rule References.    Play Video

   55- Converting text to columns.    Play Video

   56- Data validation.    Play Video

6- Using templates , styles and AutoFormat (Open Exercise file)

   61- Templates. Play Video

   62- Styles. Play Video

   63- Auto format. Play Video

7- Managin lists in Excel (Open Exercise file)

   71- What happened to Excel Lists? Introducing Excel Tables.    Play Video

   72- Converting Text to Columns. Play Video

   73- Sorting and Grouping. Play Video

   74- Creating a Summary Report.    Play Video

8- Reviewing Worksheets (Open Exercise file)

   81- Proofing your Work. Play Video

   82- Providing comments on Worksheets.    Play Video

9- Sharing Worksheets (Open Exercise file)

   91- Protecting and Sharing a Worksheet.    Play Video

   92- Allowing others to Edit ranges.    Play Video

   93- Track Changes.    Play Video

10- Printing Workbooks (Open Exercise file)

   101- Preparing to Print. Play Video

   102- Print Preview.    Play Video

   103- The page layout tab.    Play Video

   104- Page breaks. Play Video

   105- The page layout view.    Play Video

   106- Headers and footers.    Play Video

11- Enhancing worksheets (Open Exercise file)

   111- Adding themes to your worksheet.    Play Video

   112- Page setup options.    Play Video

   113- Scale to fit.    Play Video

   114- Worksheet options.    Play Video

   115- Inserting images. Play Video

12- Manipulating screen display (Open Exercise file)

121- Workbook views.    Play Video

   122- Hiding and zooming.    Play Video

   123- Windows panes.    Play Video

   124- More screen options.    Play Video

13- Create & edit templates (Open Exercise file)

   131- Create & edit templates. Play Video

14- Importing data (Open Exercise file)

    141- Importing from access.    Play Video

   142- Using the import wizard for text files.    Play Video

15- Finding and replacing data (Open Exercise file)

   151- The find and select button.    Play Video

   152- Find and replace.    Play Video

   153- Removing dublicates.    Play Video

16- Working with formulas (Open Exercise file)

   161- What are formulas?    Play Video

   162- Order of operations.    Play Video

   163- Relative and absolute referencing.    Play Video

   164- The new format tab.    Play Video

17- Working with basic functions (Open Exercise file)

    171- What are functions? Play Video

   172- Autosum. Play Video

   173- Minimum. Play Video

   174- Trim.    Play Video

   175- Left. Play Video

18- working with advanced functions (Open Exercise file)

   181- Concatenation.    Play Video

   182- Sumif. Play Video

   183- Lookup.    Play Video

   184- what-if analysis.    Play Video

19- charts (Open Exercise file)

   191- Why create a chart?    Play Video

   192- Creating your chart.    Play Video

   193- Modifying your chart.    Play Video

   194- Laying out your chart.    Play Video

20- Pivot tables (Open Exercise file)

   201- What are pivottable reports and pivotchart reports? Play Video

   202- Creating a pivottable.    Play Video

   203- Laying your pivottable.    Play Video

   204- Designing your pivottable. Play Video

   205- Creating a pivotchart. Play Video

21- Working with macros (Open Exercise file)

   211- Why use macros?    Play Video

   212- Creating a macro.    Play Video

   213- Macro security.    Play Video

22- Workflow in Excel 2007 (Open Exercise file)

   221- Reviewing a workflow in Excel.    Play Video

Back To Top

Back to Culture & Humanities  Back To Edmond Home Page

Copyright © Edmond Hakmeh 2009. All Rights Reserved