/
/
/
/

Excel Macros and VBA Course, Private 1-1

(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlistShortlisted by 59 people

https://www.hotcourses.com/courses-by-subject/Excel-Macros-and-VBA-Course-Private-1-1-courses/56184466/

Course description

Excel Macros and VBA Course, Private 1-1:

Recording and Running Macros in Excel

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar

Introduction to the Excel VBA Editor

Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros

Creating Procedures and Functions

Create simple macro procedures in code that use variable to store data and communicate with the user

  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User

Working with the Excel Object Model

Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks

  • Understanding Objects, Properties and Methods

Interacting with the spreadsheet :

  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
  • Updating values in the spreadsheet and putiing values into the spreadsheet

Functions

  • Using standard Excel functions in VBA
  • Creating new custom functions

Controlling Program Flow

Using decision making and looping structures to control the way your program works

  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Practical project and examples

Additional entry requirements

Advanced Excel Skills

Training for employers

This course has been specifically designed for companies training their employees.

Course info
313 views
Start Date: Thu 23rd May 2019
START DATES
MAY 2019
Sun Mon Tue Wed Thu Fri Sat
JUNE 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Manchester, M1 5AN, Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 4JF, You study this on your computer

Time:

11:00am - 6:00pm, Any time

Duration:

1 day, By arrangement

Attendance:

Full time, Online

Qualification:

Qualification awarded by the course provider

Level:

BeginnerIntermediate Advanced

From: £350

Other Microsoft Excel courses

Excel Introduction Course, Private 1-to-1

PCWorkshops

Duration: Variable

Beginner

Course Provider Diploma/Certificate/Award

Excel Intermediate Course, Private 1-to-1

PCWorkshops

Duration: Variable

Intermediate

Course Provider Diploma/Certificate/Award

View 6 courses

Summary of all course reviews for PCWorkshops

17 reviews

(94%)
(6%)

Average student ranking

Reviews of other courses at PCWorkshops

pcworkshops

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
2 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.
MORE REVIEWS

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Excel Macros and VBA Course, Private 1-1 by PCWorkshops on Hotcourses

Ask a question

Get course info