Learn VBA Fast, Vol. II: Excel function design course, with practice exercises (The VBA Function Design Course Book 2)

Learn VBA Fast, Vol. II: Excel function design course, with practice exercises (The VBA Function Design Course Book 2)

This book is part two of a course for people who want to learn VBA fast. It continues to introduce VBA step-by-step, providing examples, practice exercises, and explanations at each stage. Learn VBA by using it. See, do, review, and then build on what you learned in book one.

Why learn VBA?
VBA allows you to automate repetitive tasks when using Microsoft Office packages like Word and Excel.
VBA also allows you to make your own functions in Excel. These can replace what you do with formulae, and do more besides.

What’s the simplest way to continue learning VBA?
Keep following the course! Practice using more core VBA components by designing your own VBA functions in structured exercises, before moving on to macros.

Why should I buy this book?
This book continues to introduce VBA step-by-step, building on the content of book one. Examples, explanations and practice exercises are provided at each stage. All practice exercises have hyperlinked answers, so you can ‘flip’ the page from problem to solution and back, with ease. See, understand and then practice new concepts. Learn how to use them together, and how they fit into the bigger picture. This book will help you:
– use logic to select the data you want
– use input boxes to change a program’s behaviour as it runs
– use loops to work with ranges of numbers
– use recursion to make code repeat itself
– understand the modulus operator

This book is the second of three in a course. Learn more VBA today.

Buy ‘Learn VBA Fast, Vol. 2’ today and find out how easy it can be.

Lowest Price: £1.99
Buy from Amazon


ClimaxDigital CUD390 USB 3.0 Universal Docking Station with Dual Video Outputs (HDMI & DVI/VGA up to 2048×1152, Gigabit Ethernet, 2 USB 3.0 Ports with Fast Charging Function, 4 USB 2.0 Ports, Audio for Headset & Microphone , 12V/2A AC UK Power Adapter) for Windows 8.1, 8, 7, XP

ClimaxDigital CUD390 USB 3.0 Universal Docking Station with Dual Video Outputs (HDMI & DVI/VGA up to 2048x1152, Gigabit Ethernet, 2 USB 3.0 Ports with Fast Charging Function, 4 USB 2.0 Ports, Audio for Headset & Microphone , 12V/2A AC UK Power Adapter) for Windows 8.1, 8, 7, XP
  • Enables you to connect multi peripheral devices (two monitors, keyboard, mouse, printer and other USB devices) to your PC/Laptop simultaneously via a single USB 3.0 super-speed (5Gbps) cable. Recommend always to download the latest driver from Displaylink’s website
  • Dual video outputs. Enable you connect extra two monitors/TVs via HDMI, DVI(or VGA). Support reolution up to 2048 x 1152/1920 x 1200. Supports Extended Desktop Mode, Mirrored Desktop Mode and Primary Mode. It has 3.5mm plugs for speaker and microphone and you can get 5.1 Channel surround sound through DMI interface.
  • 4 USB 2.0 ports enables you to connect USB 2.0 devices such as scanner, digital camera, keybord, mouse, printer, ect.
  • 2 USB 3.0 ports for super transfer speed up to 5 Gbps. One fast charging port enables you to charge your iPhone,Samsung and other smartphones(does NOT charge iPad, tablets and laptops). Charging current up to 1.5A.
  • Gigabit Ethernet LAN port supports 1Gbps, 100Mbps, and 10Mbps transfer rates. Plug and play, compatible with hibernation and suspend modes.

The ClimaxDigital CUD390 USB 3.0 Universal Docking Station is an ideal solution to enhance laptop connectivity, especially for users that need to connect and manage multiple devices at home or in the office. It enables you to connect extra 2 monitors/HDTVs via HDMI, DVI (or VGA), connect extra 6 USB 3.0/2.0 devices and Ethernet LAN via a SINGLE USB 3.0 cable. One of the USB 3.0 fast charging port enables you to charge iphones, Samsung and other smartphones. It comes with 12 months UK warranty and free techincal support. System Requirements 1)Processor: 2.0GHz Core2Duo or better RAM: 1GB 2) Recommened requirments: (full screen Video Playback) processor: Core I5 or i7 2+GHz RAM: 4GB 3)Windows: XP (32-bit only) SP3/Vista/7/8 Supported Note: 64-bit Editions of XP and Windows Server Editions are not supported. Package includes 1x ClimaxDigital CUD390 USB 3.0 Universal Docking Station 1x USB 3.0 cable 1x DVI to VGA Adapter 1x DC 12V/2A Power adapter 1x CD Driver 1x User’s manual Note: Horizontal Base Mount not included

Lowest Price: £69.49
Buy from Amazon


Awinner Micro USB 2.0 OTG Cable On The Go Adapter Male Micro USB to Female USB for Samsung S7 S6 Edge S4 S3 Android or Windows Smart Phones Tablets with OTG Function 6 Inch (1-Pack)

Awinner Micro USB 2.0 OTG Cable On The Go Adapter Male Micro USB to Female USB for Samsung S7 S6 Edge S4 S3 Android or Windows Smart Phones Tablets with OTG Function 6 Inch (1-Pack)
  • The most practical&necessary on the go micro usb cable: Enabled android or windows micro usb phones or tablets work as PC host by connect female usb connector devices such as keyboard,game controller,flash drives,SD/TF card reader,wireless mice and more
  • Only 6 inch portable Awinner OTG cable provides a convenient and simple smart phones or tablets host replacement of PC to view picture,listen to music,data transform from flash drivers,edit files with keyboard or mice
  • Compatible with all micro USB connector mobiles and tablets with OTG function,such as Samsung Galaxy or Note series phones and tablets, Google Nexus series, Dell, Motorala, Sony, Nokia, Lenovo yoga/ThinkPad, Acer tab, HTC
  • Notes:It will charge the USB devices when connect two smart phones;The host will be power output status when connected;Ensure your device is OTG available before purchasing;Do not support OTG and charging simultaneously
  • What you receive: Awinner Micro USB OTG cable with 12 months warranty and manufacturer lifetime service

Specification:
1. Micro USB ‘B’ male connector; USB ‘A’ female connector port
2. Support High speed data rate up to 480Mbps
3. Compliant with USB2.0 standard and backward compliant with USB1.1 standard
4. Cable Rating: Hi-Speed USB 2.0 up to 480 Mbps data transfer rate
5. Durable PVC construction, and tinned copper to ensure signal performance
6. Cable length: 6inch/12cm

Notes:
1. Before purchasing,please search online to make sure your phone had OTG function
2. The host will be power output status when connect OTG cable,also do not support both OTG and charging at the same time
3. Watch movie from flash drivers directly is not suggested,it would be better to watch movies by copy file to host first
4. Support flash drivers format:fat16,fat32,exfat,No NTFS!
5. For first-time user,please connect the cable to your sets first,and then reset the device

Lowest Price: £2.99
Buy from Amazon


Reinforcement Learning and Dynamic Programming Using Function Approximators (Automation and Control Engineering)

Reinforcement Learning and Dynamic Programming Using Function Approximators (Automation and Control Engineering)
  • New
  • Mint Condition
  • Dispatch same day for order received before 12 noon
  • Guaranteed packaging
  • No quibbles returns

Reinforcement Learning and Dynamic Programming Using Function Approximators From household appliances to applications in robotics, engineered systems involving complex dynamics can only be as effective as the algorithms that control them. This title provides a comprehensive exploration of the field of Dynamic Programming (DP) and Reinforcement Learning (RL).

Lowest Price: £62.25
Buy from Amazon


Learn VBA Fast, Vol. I: Excel function design course, with practice exercises (The VBA Function Design Course Book 1)

Learn VBA Fast, Vol. I: Excel function design course, with practice exercises (The VBA Function Design Course Book 1)

This book is for people who want to learn VBA fast. It introduces VBA step-by-step, providing examples, practice exercises, and explanations at each stage. Learn VBA by using it. See, do, review, and then build on what you learn.

Why learn VBA?
VBA allows you to automate repetitive tasks when using Microsoft Office packages like Word and Excel.
VBA also allows you to make your own functions in Excel. These can replace what you do with formulae, and do more besides.

What’s the simplest way to learn VBA?
Start by learning to design your own VBA functions, before moving on to macros.

Why should I buy this book?
This book introduces VBA step-by-step. Examples, explanations and practice exercises are provided at each stage. All practice exercises have hyperlinked answers, so you can ‘flip’ the page from problem to solution and back, with ease. See, understand and then practice new concepts. Learn how to use them together, and how they fit into the bigger picture. This book will help you:
– Get started with the VBA editor
– Make and use functions
– Use function inputs and outputs
– Process different types of data
– Work with text and numbers
– Make calculations and comparisons
– Have VBA make decisions

This book is the first of three in a course. Find out if VBA is for you with this, beginner’s, section.

Try ‘Learn VBA Fast’ today and find out how easy it can be.

Lowest Price: £0.99
Buy from Amazon


Emartbuy® HP Pavilion x2 Detachable Laptop 10.1 Inch Silver Dual Function Ball Pen + Capacitive Resistive Touchscreen Stylus Pen

Emartbuy® HP Pavilion x2 Detachable Laptop 10.1 Inch Silver Dual Function Ball Pen + Capacitive Resistive Touchscreen Stylus Pen
  • Use with any app for greater comfort and control
  • Dual Function – Ball Point Pen & Stylus
  • Quality product
  • Bulk Pack

Emartbuy introduces the all new precision Dual Function 2 in 1 – Ball Point Pen + capacitive stylus pen. The stylus is compatible with all newest Multi-Touch devices with resistive / capacitive screens. We have them in 5 different colours.

Lowest Price: £1.99
Buy from Amazon


Betron HDMI to HDMI Cable, High Speed, 3D Support, Ethernet Function, 4K Support, HDMI Lead for TV, Laptops, PS3, PS4 , Xbox etc (1.2 Meter)

Betron HDMI to HDMI Cable, High Speed, 3D Support, Ethernet Function, 4K Support, HDMI Lead for TV, Laptops, PS3, PS4 , Xbox etc (1.2 Meter)
  • High Speed HDMI with Ethernet, 17.8 Gbps bandwidth support, Compatible with all previous versions
  • 4K Resolution Support (4096p) and beyond , 3D over HDMI Support
  • HDMI (v.1.4 with HDMI Ethernet Channel), HDMI (v.1.4 with Audio Return Channel)
  • All TV Hz rates supported, Dolby® TrueHD and DTS-HDTM Lossless Surround Sound support
  • 24 AWG oxygen-free copper, Nitrogen gas-injected dielectric , CL3 rating for in-wall use

BETRON HDMI CABLE

Betron HDMI cable Pro Series. This great new generation 1.4 Version HDMI-HDMI Cable was born especially for you to practice your tv`s true capabilities. 24K Gold-plated connectors Oxygen-free copper Nylon Braided (EMC) Multi-shielded cable Chrome-plated zinc alloy connector shafts (zero tolerance) Full 19pins connected for 100% compatibility RoHS Certified ATC V1.4a Certified (Full 1080p approved).

3D TV HDMI Cable,Support 4k*2K 1080p,Ethernet,ideal for Home theater,HDTV,PS3,Xbox and set-top boxes

FEATURES:

· A premium quality HDMI to HDMI cable is suitable for use in HDTV, Home Theater, DVD player, projector, PS3, Xbox360 and other HDMI devices

· 24k gold-plated connector resists corrosion and ensures an optimum connection for maximum signal transfer

· High pure Oxygen Free Copper conductor for maximum conductivity and reliability

· High density triple shielding for maximum rejection of EMI and RFI

· Compatible with multiple audio formats from stereo to multi-channel sound.

· Transfer Digital Audio & Video signals at warp speed of 17.8 Gigabytes per second

SPECIFICATIONS:

· 2×HDMI 19PIN,male connectors

· Support 3D,Ethernet,Audiot return channel

· Chromium metal casing

· Gold plated connectors

· With nylon protection layer protect cable from abrasion

· Digital Transfers at rates up to 17.8Gbps+

· High purity Oxygen Free Copper conductor

· Cable: UL20276 AWG(1P+D+AL+MY)*5+4C+AEB

· All materials conform to RoHs,CE,FCC,ATC,UL,HDMI standard of Europe

. Compatible with all HDMI backward versions

LIFE TIME WARRANTY

Full Life Time Warranty

FREE DELIVERY

Free delivery for all our products within the UK

Lowest Price: £5.95
Buy from Amazon


KiWiBiRD® Micro USB (male) to USB 2.0 (female) High Speed OTG Adapter for Android Smartphone/Tablet with OTG Function (Samsung Galaxy S7/S7E/S6/S6E/S6E+/S5/S4, Note 5/Edge/4/3/2/Pro/10.1/8.0 (2014), Galaxy Tab S/S2/Pro, LG G4/3/2/1/G Pro 1/2, Sony Xperia Z1/Z2/Z3/Z5, HTC one M8/M9, Google Nexus 5/6/7/9/10… and More!) – Sliver ***Pack of 2***

KiWiBiRD® Micro USB (male) to USB 2.0 (female) High Speed OTG Adapter for Android Smartphone/Tablet with OTG Function (Samsung Galaxy S7/S7E/S6/S6E/S6E+/S5/S4, Note 5/Edge/4/3/2/Pro/10.1/8.0 (2014), Galaxy Tab S/S2/Pro, LG G4/3/2/1/G Pro 1/2, Sony Xperia Z1/Z2/Z3/Z5, HTC one M8/M9, Google Nexus 5/6/7/9/10... and More!) - Sliver ***Pack of 2***
  • [NOTE: Your device must have a Micro USB port and support FULL OTG function.] This adapter features a Micro USB male (B-type) connector and a USB female (A-type) connector. USB 2.0 interface allows date transfer rate up to 480Mb/s.***Works with ‘Samsung Smart Switch’ APP!***
  • Offers a simple way to convert your Micro USB OTG capable tablet/Smartphone into a USB On-the-go host, and enables you to connect a USB peripheral device such as a thumb drive, or USB mouse or keyboard, USB card reader, etc.
  • Typical applications A: •Connects a USB drive to your tablet or mobile phone for removable data storage. •Connects a USB keyboard or mouse to your tablet. •Connects camera lead to your tablet to import media files.
  • Typical applications B: •Connects USB card reader to the tablet or mobile phone for data exchange. •Connects USB fan&led light. •Connects two phones togehter to allows 1st phone access to the 2nd phone’s data.
  • Operating system: Android 4.0 or later update. Plug and Play. OTG function is not supported on windows phone and tablet. Package includes: 2 X OTG Adapter

PRODUCT FEATURES:
1. Interface: 1x Micro USB ‘B’ male connector, 1x USB 2.0 ‘A’ female connector port
2. Connects external USB SD card reader (card up to 64GB), USB flash drive (up to 64GB), external keyboard&mouse, game console, camera sync lead, USB speaker&earphone, external USB fan&light with OTG compatible devices.
*Note: does NOT support external hard drive and other power-hungry devices.*
3. Made out of metal and plastic to ensure maximum durability.
4. USB 2.0 interface with data transfer speed up to 480Mbps.
5. Compact dimensions: 8x19x18mm. Small and convenient.

COMPATIBLE DEVICE(list is not comprehensive):
Samsung Galaxy S7/S7E/S6/S6E(+)/Alpha
Samsung Galaxy S5/S4 only
Not For Samsung Galaxy S3/S5 mini/S4 mini

Samsung Galaxy Note 5,4,3,2
Samsung Galaxy Note Edge
Samsung Galaxy Note Pro
Samsung Galaxy Note 10.1 from 2014 onwards
Samsung Galaxy Note 8.0 from 2014 onwards

Samsung Galaxy Tab pro
Samsung Galaxy Tab S/S2
Samsung Galaxy Tab 3 10.1, 8.0 (NOT FOR 7.0)
Samsung Galaxy Tab 4 10.1 (NOT FOR 7.0)

LG G4/3/2/1, G Pro 1/2
*Google Nexus 5/6/7/9/10 with help of third-party app such as ‘nexus USB OTG file manager, ES file explorer, Nexus media importer’ (NOT FOR Nexus 7 2013 edition!)*Supports other host/OTG compatible smartphones and tablets with Android operating system (4.0 or later) and a micro USB interface

NOT FOR HTC one M9/M8
NOT FOR Moto G, Huawei P8 lite/P9 lite
NOT FOR Hudl 1/2
*This kit does not support amazon Kindle & Fire tablets*

NOTE: In certain mobilephones, please enable ‘OTG storage’ function in the phone’s setting menu.
Android OS only recognises connected external device with FAT 32 file system. Not compatible with NTFS & exFAT file formats.

Lowest Price: £4.99
Buy from Amazon


UGREEN Micro USB 2.0 OTG Cable On The Go Adapter Male Micro USB to Female USB for Samusung S6 Edge S4 S3 Android or Windows Smart Phones Tablets with OTG Function 12cm Black

UGREEN Micro USB 2.0 OTG Cable On The Go Adapter Male Micro USB to Female USB for Samusung S6 Edge S4 S3 Android or Windows Smart Phones Tablets with OTG Function 12cm Black
  • USB On-The-Go OTG Cable allows you transform your USB OTG enabled Android or Windows smartphones and tablets with Micro USB port into a host for connecting USB peripherals such as keyboards, mice, flash drives, external hard drives, USB card readers, game controllers and more Convenient.
  • Compatible with Google Nexus 4/Nexus 5/Nexus 7, Samsung Galaxy S2/Galaxy S3/Galaxy S4/Galaxy S5/Note 2/Note 3/Note 4/Note 8.0/Note 10.1/Note Pro 12.2/Tab 3 8.0/ Tab 3 10.1, Nvidia Shield tablet, Motorola Moto X, Dell Venu Pro, LG G2/G3/G Pro, Sony Xperia Z2/Z3, HTC Butterfly/One/One X/One X+/One 8, Asus T100/Memo Pad/Transformer, Motorola Razr HD Maxx, Nokia Lumia 1520, Acer Iconia Tab, Lenovo Yoga 8/ThinkPad 8
  • USB OTG Adapter also would share power to another samrtphone or tablet through a usb cable.Ensure your device is OTG available before purchasing;USB OTG does not support both OTG functions and charging at the same time
  • Flexible cable adapter with 12cm cable provides a convenient and simple smart phones or tablets host replacement of PC to view picture,listen to music,data transform from flash drivers,edit files with keyboard or mice.
  • What you receive:1*Micro USB OTG cable with 12 months warranty and manufacturer lifetime service

Faster and Convenient transformation
Ugreen Micro USB 2.0 OTG cable allows you to connect devices like flash drive,card reader,mouse or a keyboard to you micro usb otg enabled tablet or phone directly, that means you can control your phone or tablet with a mouse and keyboard, watch movies with your phone by connecting a flash driver and send files directly on your phone or tablet.
In a word,it offers a faster and convenient tansformation, let you have fun everywhere without a host.

Huge Compatibility
This OTG cable compatible with all micro usb 2.0 smart phones and tablets such as Samsung Galaxy S7 S7 Edge S6 S6 Edge S5 S4 S3 S2, Samsung Galaxy Note 5, Note 4, Note 3, Note 2 Note 1, Galaxy Alpha, Ace, A5 A7, E5 E7 Samsung I9250 9100 9220 P7500 P7510 P7310 P7300 S3 I9100 I9103 I997, Note 2 N7100, LT261 XT910, NEXUS 7, Nokia 810 and more.

Specification
1. Micro USB ‘B’ male connector;1 USB ‘A’ female connector port;
2. Support High speed data rate up to 480Mbps;
3. Compliant with USB2.0 standard and backward compliant with USB1.1 standard;
4. Support for USB OTG (On-the-Go) capable devices;
5. Durable PVC construction, and tinned copper to ensure signal performance;
6. Cable length:12cm.

Notes
1.Before purchasing,please search online to make sure your phone had OTG function
2.The host will be power output status when connect OTG cable,also do not support both OTG and charging at the same time
3.Watch movie from flash drivers directly is not suggested,it would be better to watch movies by copy file to host first
4.Support flash drivers format:fat16,fat32,exfat,No NTFS!
5.For first-time user,please connect the cable to your sets first,and then reset the device

Package Contents Ugreen USB 2.0 A Female to Micro B Male Converter OTG Adapter Cable x1;

Lowest Price: £4.02
Buy from Amazon


iGadgitz Green PU Leather Case Cover for Google Nexus 7 2012 1st Generation Android 4.1 Tablet 8GB 16GB. With Sleep/Wake Function, Integrated Hand Strap + Screen Protector (NOT suitable for the 2nd Generation released August 2013)

iGadgitz Green PU Leather Case Cover for Google Nexus 7 2012 1st Generation Android 4.1 Tablet 8GB 16GB. With Sleep/Wake Function, Integrated Hand Strap + Screen Protector (NOT suitable for the 2nd Generation released August 2013)
  • Not Suitable for the Nexus 7 FHD 2nd Generation (Released in August 2013)
  • Custom made PU Leather case for the Google Nexus 7 with microfibre inner
  • Incorporates 2 angle stands. 1 for viewing and 1 for typing
  • Integrated elastic hand strap offers a secure hand-held viewing position. Supplied with stick-on screen protector
  • Sleep/Wake technology utilises magnets to align the front cover securely & put your tablet to sleep

Our custom made PU leather case for the Google Nexus 7 has unique features to enhance the use of your tablet.

This case is made from durable PU leather. It has the textured look of top quality full grain leather and provides good overall protection for your tablet.

Our clever sleep/wake technology utilises magnets to put your tablet to sleep. The case has a quick release hook for ease of use, rather than a magnetic fastener.

The practical flip stand function offers 2 angle positions, providing an optimum angle for both viewing and typing. Simply unclip your tablet from the lower clasps to access the stand positions.

We also provide a fully integrated hand strap which is perfect for hand-held viewing, great for browsing!

Supplied with stick-on screen protector.

We think this case ticks all the boxes. Give it a try and see..

Lowest Price: £8.59
Buy from Amazon