Please click here to chat with a certified trainer
Microsoft Excel courses logo

 

MS Excel courses

 


 

 

  • Excel Level 1 Course
  • Excel Level 2 Course
  • Excel Level 3 Course

Course Date  City Course Times    Cost  
July        
25 Jul Glasgow 9AM - 4PM    £195 Book
August        
02 Aug London Bridge 9AM - 4PM    £195 Book
03 Aug Bristol 9AM - 4PM    £195 Book
09 Aug Cardiff 9AM - 4PM    £195 Book
09 Aug London Bridge 9AM - 4PM    £195 Book
15 Aug Leeds - City Centre 9AM - 4PM    £195 Book
23 Aug Glasgow 9AM - 4PM    £195 Book
23 Aug London Bridge 9AM - 4PM    £195 Book
29 Aug Bristol 9AM - 4PM    £195 Book
September        
04 Sep London Bridge 9AM - 4PM    £195 Book
07 Sep Leeds - City Centre 9AM - 4PM    £195 Book
13 Sep Cardiff 9AM - 4PM    £195 Book
14 Sep Bristol 9AM - 4PM    £195 Book
21 Sep London Bridge 9AM - 4PM    £195 Book
26 Sep Bristol 9AM - 4PM    £195 Book
28 Sep Glasgow 9AM - 4PM    £195 Book
October        
04 Oct London Bridge 9AM - 4PM    £195 Book
11 Oct Leeds - City Centre 9AM - 4PM    £195 Book
12 Oct Bristol 9AM - 4PM    £195 Book
17 Oct Cardiff 9AM - 4PM    £195 Book
30 Oct London Bridge 9AM - 4PM    £195 Book
31 Oct Glasgow 9AM - 4PM    £195 Book
November        
02 Nov Bristol 9AM - 4PM    £195 Book
13 Nov Leeds - City Centre 9AM - 4PM    £195 Book
14 Nov Cardiff 9AM - 4PM    £195 Book
22 Nov Glasgow 9AM - 4PM    £195 Book
30 Nov Bristol 9AM - 4PM    £195 Book

Course Date  City Course Times    Cost  
       
03 Aug Bristol 9AM - 4PM    £195 Book
29 Aug Bristol 9AM - 4PM    £195 Book
14 Sep Bristol 9AM - 4PM    £195 Book
26 Sep Bristol 9AM - 4PM    £195 Book
12 Oct Bristol 9AM - 4PM    £195 Book
02 Nov Bristol 9AM - 4PM    £195 Book
30 Nov Bristol 9AM - 4PM    £195 Book
       
09 Aug Cardiff 9AM - 4PM    £195 Book
13 Sep Cardiff 9AM - 4PM    £195 Book
17 Oct Cardiff 9AM - 4PM    £195 Book
14 Nov Cardiff 9AM - 4PM    £195 Book
       
25 Jul Glasgow 9AM - 4PM    £195 Book
23 Aug Glasgow 9AM - 4PM    £195 Book
28 Sep Glasgow 9AM - 4PM    £195 Book
31 Oct Glasgow 9AM - 4PM    £195 Book
22 Nov Glasgow 9AM - 4PM    £195 Book
       
15 Aug Leeds - City Centre 9AM - 4PM    £195 Book
07 Sep Leeds - City Centre 9AM - 4PM    £195 Book
11 Oct Leeds - City Centre 9AM - 4PM    £195 Book
13 Nov Leeds - City Centre 9AM - 4PM    £195 Book
       
02 Aug London Bridge 9AM - 4PM    £195 Book
09 Aug London Bridge 9AM - 4PM    £195 Book
23 Aug London Bridge 9AM - 4PM    £195 Book
04 Sep London Bridge 9AM - 4PM    £195 Book
21 Sep London Bridge 9AM - 4PM    £195 Book
04 Oct London Bridge 9AM - 4PM    £195 Book
30 Oct London Bridge 9AM - 4PM    £195 Book

Excel Level 1 Course

Learning to use Microsoft Excel has never been this simple. Our course quickly and thoroughly walk you step-by-step through all aspects Excel offers. This training course begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

Excel Level 1 Course

Unit 1 : Getting started

  • Spreadsheet terminology
  • Discussing spreadsheet basics
  • The Excel environment
  • Examining Excel window components
  • Getting help
  • Getting help with using Excel
  • Navigating a worksheet
  • Navigating a worksheet

Unit 2 : Entering and editing data

  • Entering and editing text and values
  • Entering text and values
  • Editing cell contents
  • Using AutoFill to fill a series
  • Entering and editing formulas
  • Creating a basic formula
  • Entering cell references with the mouse
  • Editing a formula
  • Working with pictures
  • Inserting and modifying a picture
  • Saving and updating workbooks
  • Saving a new workbook
  • Saving a worksheet as a PDF file
  • Editing and updating a workbook

Unit 3 : Modifying a worksheet

  • Moving and copying data
  • Moving data in a worksheet
  • Copying data in a worksheet
  • Moving and copying data by using drag-and-drop
  • Using the Clipboard task pane
  • Moving and copying formulas
  • Moving a formula
  • Copying a formula
  • Using AutoFill to copy a formula
  • Absolute and relative references
  • Observing the limitations of relative references
  • Applying absolute references
  • Inserting and deleting ranges, rows, and columns
  • Inserting a range of cells
  • Inserting rows
  • Deleting a range of cells

Unit 4 : Functions

  • Entering functions
  • Entering a SUM function
  • Using the mouse to enter a function argument
  • Inserting a function
  • AutoSum
  • Using AutoSum
  • Other common functions
  • Using AVERAGE
  • Using MIN
  • Using MAX
  • Using COUNT and COUNTA

Unit 5 : Formatting

  • Topic A : Text formatting
  • A - 1 : Formatting text
  • A - 2 : Formatting a non-contiguous range
  • A - 3 : Using the Format Cells dialog box to format text
  • Topic B : Row and column formatting
  • B - 1 : Changing column width and row height
  • B - 2 : Applying colour to a row
  • B - 3 : Setting alignment
  • B - 4 : Applying borders to cell ranges
  • B - 5 : Using the border-drawing pencil
  • B - 6 : Using the Paste Special option
  • B - 7 : Removing a border
  • Topic C : Number formatting
  • C - 1 : Using the Number group to format numbers
  • C - 2 : Exploring the Number tab
  • Topic D : Conditional formatting
  • D - 1 : Creating a conditional format
  • D - 2 : Editing and deleting a conditional format
  • Topic E : Additional formatting options
  • E - 1 : Copying formats
  • E - 2 : Using AutoFill to copy a format
  • E - 3 : Applying cell and table styles
  • E - 4 : Using Find and Replace to change formatting

Unit 6 : Printing

  • Topic A : Preparing to print
  • A - 1 : Checking spelling in a worksheet
  • A - 2 : Finding and replacing text
  • A - 3 : Previewing a worksheet
  • Topic B : Page Setup options
  • B - 1 : Setting page orientation and scaling
  • B - 2 : Adjusting margins
  • B - 3 : Creating headers and footers
  • Topic C : Printing worksheets
  • C - 1 : Printing a selected range

Unit 7 : Charts

  • Topic A : Chart basics
  • A - 1 : Creating a chart
  • A - 2 : Moving a chart within a workbook
  • A - 3 : Examining chart elements
  • A - 4 : Creating and editing a pie chart
  • Topic B : Formatting charts
  • B - 1 : Applying chart types and chart styles
  • B - 2 : Modifying chart elements

Unit 8 : Managing large workbooks

  • Topic A : Viewing large worksheets
  • A - 1 : Locking rows and columns
  • A - 2 : Splitting a worksheet into panes
  • A - 3 : Hiding and unhiding columns and worksheets
  • A - 4 : Minimising the Ribbon
  • Topic B : Printing large worksheets
  • B - 1 : Setting print titles
  • B - 2 : Adjusting page breaks
  • Topic C : Working with multiple worksheets
  • C - 1 : Navigating between worksheets
  • C - 2 : Naming worksheets and colouring tabs
  • C - 3 : Working with multiple worksheets
  • C - 4 : Previewing and printing multiple worksheets

Course Date  City Course Times    Cost  
July        
27 Jul Bristol 9AM - 4PM    £195 Book
27 Jul London Bridge 9AM - 4PM    £195 Book
August        
03 Aug Cardiff 9AM - 4PM    £195 Book
08 Aug Leeds - City Centre 9AM - 4PM    £195 Book
10 Aug Glasgow 9AM - 4PM    £195 Book
10 Aug London Bridge 9AM - 4PM    £195 Book
22 Aug Bristol 9AM - 4PM    £195 Book
22 Aug London Bridge 9AM - 4PM    £195 Book
29 Aug Cardiff 9AM - 4PM    £195 Book
29 Aug Glasgow 9AM - 4PM    £195 Book
September        
05 Sep London Bridge 9AM - 4PM    £195 Book
12 Sep Leeds - City Centre 9AM - 4PM    £195 Book
15 Sep Cardiff 9AM - 4PM    £195 Book
20 Sep Glasgow 9AM - 4PM    £195 Book
21 Sep London Bridge 9AM - 4PM    £195 Book
28 Sep Bristol 9AM - 4PM    £195 Book
October        
03 Oct Cardiff 9AM - 4PM    £195 Book
05 Oct London Bridge 9AM - 4PM    £195 Book
17 Oct Leeds - City Centre 9AM - 4PM    £195 Book
18 Oct Glasgow 9AM - 4PM    £195 Book
20 Oct Cardiff 9AM - 4PM    £195 Book
27 Oct Bristol 9AM - 4PM    £195 Book
31 Oct London Bridge 9AM - 4PM    £195 Book
November        
08 Nov Cardiff 9AM - 4PM    £195 Book
08 Nov Glasgow 9AM - 4PM    £195 Book
13 Nov Leeds - City Centre 9AM - 4PM    £195 Book
24 Nov Bristol 9AM - 4PM    £195 Book
28 Nov Cardiff 9AM - 4PM    £195 Book
28 Nov Glasgow 9AM - 4PM    £195 Book
December        
04 Dec Leeds - City Centre 9AM - 4PM    £195 Book
05 Dec Bristol 9AM - 4PM    £195 Book
14 Dec Glasgow 9AM - 4PM    £195 Book

Course Date  City Course Times    Cost  
       
27 Jul Bristol 9AM - 4PM    £195 Book
22 Aug Bristol 9AM - 4PM    £195 Book
28 Sep Bristol 9AM - 4PM    £195 Book
27 Oct Bristol 9AM - 4PM    £195 Book
24 Nov Bristol 9AM - 4PM    £195 Book
05 Dec Bristol 9AM - 4PM    £195 Book
       
03 Aug Cardiff 9AM - 4PM    £195 Book
29 Aug Cardiff 9AM - 4PM    £195 Book
15 Sep Cardiff 9AM - 4PM    £195 Book
03 Oct Cardiff 9AM - 4PM    £195 Book
20 Oct Cardiff 9AM - 4PM    £195 Book
08 Nov Cardiff 9AM - 4PM    £195 Book
28 Nov Cardiff 9AM - 4PM    £195 Book
       
10 Aug Glasgow 9AM - 4PM    £195 Book
29 Aug Glasgow 9AM - 4PM    £195 Book
20 Sep Glasgow 9AM - 4PM    £195 Book
18 Oct Glasgow 9AM - 4PM    £195 Book
08 Nov Glasgow 9AM - 4PM    £195 Book
28 Nov Glasgow 9AM - 4PM    £195 Book
14 Dec Glasgow 9AM - 4PM    £195 Book
       
08 Aug Leeds - City Centre 9AM - 4PM    £195 Book
12 Sep Leeds - City Centre 9AM - 4PM    £195 Book
17 Oct Leeds - City Centre 9AM - 4PM    £195 Book
13 Nov Leeds - City Centre 9AM - 4PM    £195 Book
04 Dec Leeds - City Centre 9AM - 4PM    £195 Book
       
27 Jul London Bridge 9AM - 4PM    £195 Book
10 Aug London Bridge 9AM - 4PM    £195 Book
22 Aug London Bridge 9AM - 4PM    £195 Book
05 Sep London Bridge 9AM - 4PM    £195 Book
21 Sep London Bridge 9AM - 4PM    £195 Book
05 Oct London Bridge 9AM - 4PM    £195 Book
31 Oct London Bridge 9AM - 4PM    £195 Book

Excel Level 2 Course

In Microsoft Office Excel Beginners, you created edited, formatted and printed basic spreadsheets. You now have to streamline repetitive tasks and display spreadsheet in more visually effective ways. In this course you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics and formulas

Excel Level 2 Course

Unit 1 : Using multiple worksheets and workbooks

  • Topic A : Using multiple workbooks
  • A - 1 : Switching between workbooks
  • A - 2 : Copying a worksheet to another workbook
  • Topic B : Linking worksheets with 3-D formulas
  • B - 1 : Creating 3-D formulas
  • B - 2 : Adding a Watch window
  • Topic C : Linking workbooks
  • C - 1 : Examining external links in a worksheet
  • C - 2 : Creating external links in a worksheet
  • C - 3 : Editing links
  • Topic D : Managing workbooks
  • D - 1 : Creating a workspace

Unit 2 : Advanced formatting

  • Topic A : Using special number formats
  • A - 1 : Applying special formats
  • A - 2 : Controlling the display of zero values
  • A - 3 : Creating custom formats
  • Topic B : Using functions to format text
  • B - 1 : Using PROPER, UPPER, and LOWER
  • B - 2 : Using SUBSTITUTE
  • Topic C : Working with styles
  • C - 1 : Creating and applying styles
  • C - 2 : Modifying styles
  • Topic D : Working with themes
  • D - 1 : Changing to a different theme
  • D - 2 : Saving new colors and themes
  • Topic E : Other advanced formatting
  • E - 1 : Merging cells
  • E - 2 : Changing the orientation of text in a cell
  • E - 3 : Splitting cells
  • E - 4 : Transposing data during a paste
  • E - 5 : Adding and deleting backgrounds
  • E - 6 : Adding a watermark

Unit 3 : Outlining and subtotals

  • Topic A : Outlining and consolidating data
  • A - 1 : Creating an outline
  • A - 2 : Using the Consolidate command
  • Topic B : Creating subtotals
  • B - 1 : Creating subtotals in a list
  • B - 2 : Using multiple subtotal functions

Unit 4 : Cell and range names

  • Topic A : Creating and using names
  • A - 1 : Naming and selecting ranges
  • A - 2 : Using names in formulas
  • A - 3 : Using the Create from Selection command
  • A - 4 : Applying names to existing formulas
  • Topic B : Managing names
  • B - 1 : Modifying and deleting named ranges
  • B - 2 : Defining and applying 3-D names

Unit 5 : Tables

  • Topic A : Sorting and filtering data
  • A - 1 : Examining the structure of data
  • A - 2 : Sorting data
  • A - 3 : Filtering data by using AutoFilter
  • A - 4 : Using cell color and attributes to sort and filter data
  • Topic B : Advanced filtering
  • B - 1 : Using Custom AutoFilter criteria
  • B - 2 : Using the Advanced Filter dialog box
  • B - 3 : Copying filtered results to another range
  • Topic C : Working with tables
  • C - 1 : Creating a table
  • C - 2 : Formatting a table
  • C - 3 : Adding and deleting rows and columns
  • C - 4 : Using structured references
  • C - 5 : Naming tables
  • C - 6 : Creating functions with the [@] argument

Unit 6 : Web and sharing features

  • Topic A : Saving workbooks as Web pages
  • A - 1 : Making Web commands available
  • A - 2 : Saving a workbook as a Web page
  • A - 3 : Using the Publish as Web Page dialog box
  • Topic B : Using hyperlinks
  • B - 1 : Inserting and editing hyperlinks
  • Topic C : Sharing workbooks
  • C - 1 : Examining workbook sharing options
  • C - 2 : Using e-mail to send an attachment

Unit 7 : Advanced charting

  • Topic A : Chart formatting options
  • A - 1 : Adjusting the scale of a chart
  • A - 2 : Formatting a data point
  • Topic B : Combination charts
  • B - 1 : Creating a combination chart
  • B - 2 : Creating a trendline
  • B - 3 : Inserting sparklines
  • Topic C : Graphical elements
  • C - 1 : Adding graphical elements
  • C - 2 : Formatting a graphical element
  • C - 3 : Adding a picture to a worksheet

Unit 8 : Documenting and auditing

  • Topic A : Auditing features
  • A - 1 : Tracing precedent and dependent cells
  • A - 2 : Tracing errors
  • Topic B : Comments in cells and workbooks
  • B - 1 : Viewing comments in a worksheet
  • B - 2 : Adding a comment to a cell
  • B - 3 : Adding comments to a workbook
  • Topic C : Protection
  • C - 1 : Password-protecting a worksheet
  • C - 2 : Unlocking cells and protecting part of a worksheet
  • C - 3 : Discussing digital signatures
  • Topic D : Workgroup collaboration
  • D - 1 : Sharing a workbook
  • D - 2 : Merging workbooks
  • D - 3 : Tracking changes in a workbook
  • D - 4 : Using the Document Inspector
  • D - 5 : Marking a workbook as final

Unit 9 : Templates and settings

  • Topic A : Application settings
  • A - 1 : Changing application settings
  • Topic B : Built-in templates
  • B - 1 : Using a downloaded template
  • Topic C : Creating and managing templates
  • C - 1 : Creating a template
  • C - 2 : Modifying a template
  • C - 3 : Specifying an alternate template location

Course Date  City Course Times    Cost  
July        
27 Jul Bristol 9AM - 4PM    £195 Book
August        
11 Aug London Bridge 9AM - 4PM    £195 Book
15 Aug Leeds - City Centre 9AM - 4PM    £195 Book
16 Aug Glasgow 9AM - 4PM    £195 Book
18 Aug Cardiff 9AM - 4PM    £195 Book
29 Aug Bristol 9AM - 4PM    £195 Book
September        
01 Sep Leeds - City Centre 9AM - 4PM    £195 Book
06 Sep London Bridge 9AM - 4PM    £195 Book
13 Sep Glasgow 9AM - 4PM    £195 Book
15 Sep Cardiff 9AM - 4PM    £195 Book
22 Sep Bristol 9AM - 4PM    £195 Book
26 Sep Leeds - City Centre 9AM - 4PM    £195 Book
October        
06 Oct London Bridge 9AM - 4PM    £195 Book
10 Oct Bristol 9AM - 4PM    £195 Book
18 Oct Glasgow 9AM - 4PM    £195 Book
20 Oct Cardiff 9AM - 4PM    £195 Book
20 Oct Leeds - City Centre 9AM - 4PM    £195 Book
November        
01 Nov London Bridge 9AM - 4PM    £195 Book
03 Nov Bristol 9AM - 4PM    £195 Book
15 Nov Glasgow 9AM - 4PM    £195 Book
17 Nov Cardiff 9AM - 4PM    £195 Book
21 Nov Leeds - City Centre 9AM - 4PM    £195 Book
30 Nov Bristol 9AM - 4PM    £195 Book
December        
01 Dec Leeds - City Centre 9AM - 4PM    £195 Book
06 Dec Glasgow 9AM - 4PM    £195 Book

Course Date  City Course Times    Cost  
       
27 Jul Bristol 9AM - 4PM    £195 Book
29 Aug Bristol 9AM - 4PM    £195 Book
22 Sep Bristol 9AM - 4PM    £195 Book
10 Oct Bristol 9AM - 4PM    £195 Book
03 Nov Bristol 9AM - 4PM    £195 Book
30 Nov Bristol 9AM - 4PM    £195 Book
       
18 Aug Cardiff 9AM - 4PM    £195 Book
15 Sep Cardiff 9AM - 4PM    £195 Book
20 Oct Cardiff 9AM - 4PM    £195 Book
17 Nov Cardiff 9AM - 4PM    £195 Book
       
16 Aug Glasgow 9AM - 4PM    £195 Book
13 Sep Glasgow 9AM - 4PM    £195 Book
18 Oct Glasgow 9AM - 4PM    £195 Book
15 Nov Glasgow 9AM - 4PM    £195 Book
06 Dec Glasgow 9AM - 4PM    £195 Book
       
15 Aug Leeds - City Centre 9AM - 4PM    £195 Book
01 Sep Leeds - City Centre 9AM - 4PM    £195 Book
26 Sep Leeds - City Centre 9AM - 4PM    £195 Book
20 Oct Leeds - City Centre 9AM - 4PM    £195 Book
21 Nov Leeds - City Centre 9AM - 4PM    £195 Book
01 Dec Leeds - City Centre 9AM - 4PM    £195 Book
       
11 Aug London Bridge 9AM - 4PM    £195 Book
06 Sep London Bridge 9AM - 4PM    £195 Book
06 Oct London Bridge 9AM - 4PM    £195 Book
01 Nov London Bridge 9AM - 4PM    £195 Book

Excel Level 3 Course

Followed by Microsoft Excel Beginners and Microsoft Excel Intermediate, this course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications

Excel Level 3 Course

Unit 1 : Advanced functions

  • Topic A : Logical functions
  • A - 1 : Using the IF function
  • A - 2 : Using OR, AND, and NOT as nested functions
  • A - 3 : Using nested IF functions
  • A - 4 : Using the IFERROR function
  • Topic B : Math and statistical functions
  • B - 1 : Using SUMIF
  • B - 2 : Using COUNTIF
  • B - 3 : Using AVERAGEIF
  • B - 4 : Using SUMIFS, COUNTIFS, and AVERAGEIFS
  • B - 5 : Using ROUND
  • Topic C : Financial functions
  • C - 1 : Using the PMT function
  • Topic D : Displaying and printing formulas
  • D - 1 : Showing, printing, and hiding formulas

Unit 2 : Lookups and data tables

  • Topic A : Using lookup functions
  • A - 1 : Examining VLOOKUP
  • A - 2 : Using VLOOKUP to find an exact match
  • A - 3 : Using VLOOKUP to find an approximate match
  • A - 4 : Using HLOOKUP to find exact matches
  • A - 5 : Using HLOOKUP to find approximate matches
  • Topic B : Using MATCH and INDEX
  • B - 1 : Using the MATCH function
  • B - 2 : Using the INDEX function
  • Topic C : Creating data tables
  • C - 1 : Creating a one-variable data table
  • C - 2 : Creating a two-variable data table

Unit 3 : Advanced data management

  • Topic A : Validating cell entries
  • A - 1 : Observing data validation
  • A - 2 : Setting up data validation
  • A - 3 : Setting date and list validations
  • Topic B : Exploring database functions
  • B - 1 : Examining the structure of database functions
  • B - 2 : Using the DSUM function

Unit 4 : PivotTables and PivotCharts

  • Topic A : Working with PivotTables
  • A - 1 : Creating a PivotTable
  • A - 2 : Adding fields to a PivotTable
  • A - 3 : Using slicers to filter PivotTable data
  • Topic B : Rearranging PivotTables
  • B - 1 : Moving fields
  • B - 2 : Collapsing and expanding fields
  • B - 3 : Refreshing the data in a PivotTable
  • Topic C : Formatting PivotTables
  • C - 1 : Applying a PivotTable style
  • C - 2 : Changing field settings
  • Topic D : PivotCharts
  • D - 1 : Creating a PivotChart

Unit 5 : Exporting and importing

  • Topic A : Exporting and importing text files
  • A - 1 : Exporting Excel data to a text file
  • A - 2 : Importing data from a text file into a workbook
  • A - 3 : Converting text to columns
  • A - 4 : Removing duplicate records
  • Topic B : Exporting and importing XML data
  • B - 1 : Using the XML Source pane
  • B - 2 : Importing XML data into a workbook
  • B - 3 : Exporting data from a workbook to an XML data file
  • B - 4 : Deleting an XML map
  • Topic C : Querying external databases
  • C - 1 : Getting external data from Microsoft Query
  • C - 2 : Using a Web query to get data from the Web

Unit 6 : Analytical tools

  • Topic A : Goal Seek and Solver
  • A - 1 : Using Goal Seek to solve for a single variable
  • A - 2 : Activating Solver and the Analysis ToolPak
  • A - 3 : Using Solver to solve for multiple variables
  • Topic B : The Analysis ToolPak
  • B - 1 : Using the Sampling analysis tool
  • Topic C : Scenarios
  • C - 1 : Creating scenarios
  • C - 2 : Switching among scenarios
  • C - 3 : Merging scenarios from another worksheet
  • Topic D : Views
  • D - 1 : Creating views
  • D - 2 : Switching among views

Unit 7 : Macros and custom functions

  • Topic A : Running and recording a macro
  • A - 1 : Running a macro
  • A - 2 : Recording a macro
  • A - 3 : Assigning a macro to a button
  • Topic B : Working with VBA code
  • B - 1 : Observing a VBA code module
  • B - 2 : Editing VBA code
  • Topic C : Creating functions
  • C - 1 : Creating a custom function

Unit 8 : Conditional formatting and SmartArt graphics

  • Topic A : Conditional formatting with graphics
  • A - 1 : Creating data bars
  • A - 2 : Using color scales
  • A - 3 : Creating icon sets
  • Topic B : SmartArt graphics
  • B - 1 : Inserting a SmartArt graphic
  • B - 2 : Modifying a SmartArt graphic