#like i automated the printing as best i could with excel and vba code but sheesh
Explore tagged Tumblr posts
Text
thinking about how they had me pretending 1000+ ids for a whole school with a dinky id printer

#i think about my old job a lot#i used to be an IT at a school#awful awful awful#before they left they tried to last minute ask me to do id photos during orientation day#NO#of course im not doing that lmaooo#i bitch about my current job but i gotta remind myself not to get too woe is me#like i automated the printing as best i could with excel and vba code but sheesh
3 notes
·
View notes
Text
95% off #The Ultimate Excel Programmer Course – $10
Learn Excel VBA from scratch with Dan Strong! I’ve trained over 40K students on YouTube, check it out!
All Levels, – 10 hours, 173 lectures
Average rating 4.4/5 (4.4 (1,932 ratings) Instead of using a simple lifetime average, Udemy calculates a course’s star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.)
Course requirements:
You should already have Microsoft Excel (version 2003, 2007, 2010 or 2013). Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options. Very very basic Excel skills needed for this course (like opening the program, how to click on cells and type things.) You really don’t need any Excel experience, because I’ll take you from Start to Finish in this course. I was just trying to be funny.
Course description:
Teach Excel to Do Your Work FOR YOU…
Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.
In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.
Excel programming utilizes a simple but effective tool called “VBA” – the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use.
I’ll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you’ll learn another essential skill that you can immediately use. You’ll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there’s one thing I’m good at – and my students are good at – it’s AUTOMATION.
My motto is, “If I’m not making everybody’s job easier, quicker and more enjoyable, I don’t deserve to have this job” – and that’s what I live by.
Take this course and access your true potential.
Oh, and I want to be the first to hear about your New Raise you get once you’re making Excel Programs and running everything on autopilot for your co-workers!
-Dan
Full details Automate and Customize data entry forms Choose the right Loop for each task Master the CELLS and RANGE objects in multiple scenarios Create multiple Variable styles to match your need Customize your VBA Editor and Understand all the Toolbars and options Debug and Troubleshoot code like a boss! Record, Modify or Write Macros from scratch Make Custom Formulas/Functions on the fly Breeze through IF THEN statements and conquer all the Logical Operators Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES! Generate Basic Reports that can be printed Add filters to report menus to narrow the records Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more… Trigger code from a number of different methods – from Clicking on a cell – to De-Selecting a worksheet. Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc… Manipulate Userforms for data entry, report generation, editing tables/databases – ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE. Streamline your work and the work of others. Put Excel ON AUTOPILOT…
Full details This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed. This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good. I don’t think Office 365 has programming abilities with VBA as of yet, so be wary of this if you only use Office 365. They may release that as a feature in the future, but we’re not there yet. If you’re using Excel for Mac, you will find that this course won’t cover all the various differences in Excel Mac, as this course was filmed using Excel for PC. Some Mac users have taken this course, but it’s best with Excel for PC.
Full details
Reviews:
“I believe this course overall is good and worth the money. The sound quality in places is deplorable and detracts from learning. The workbook and worksheet events are given too much emphasis. The lesson module in the later portion of the course are bigger “chunks” to explain bigger concepts but lost my interest because of bouncing back and forth within the modules that Doug was building I had a hard time keeping track of where in the process we were. Maybe preplan a bit more of what you are going to say before you record it. Additionally, maybe add modules where you give us a task to complete then show the answer. The best way to learn programming is to apply it, not just watch it.” (Scott Carman)
“Excellent course. Got to learn a lot. Great content. Half point deducted to not exclude the R&D part of code writing in some videos, as it wastes learner’s time. Learning more in less time creates more interest. Else, great job done. Thanks for sharing the knowledge.” (Rajesh Pathak)
“Great course! Danny boy did a great job going over how VBA is used in Excel. I am familiar with C coding so I thought the idea of having to go over the earlier chapters of loops, if statements etc would be painful but Udemy has x2 speed which helps. Once past this, Danny went over a lot of material. Whilst there is still much to learn such as all the VBA functions etc, I have the confidence to ‘take it from here’. I am looking forward to writing my own UserForms or even creating a VBA script to produce graphs/charts.” (Shane Spiteri)
About Instructor:
Daniel Strong
Hi! My name is Daniel and i’m 29. I’ve lived most my life in Scott City, Missouri, United States. I’ve been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it’s my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor’s coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn’t able to learn much that way. I had to dive into my first project for months and months – basically just teaching myself and “figuring it out”. I realized that if only someone was out there teaching Excel VBA like Mike Gervin (ExcelIsFun) taught Excel, making everything simple and visual – then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I’ve turned thousands of people into Excel programmers. Now, with Udemy, I’m going to teach the good stuff – the stuff I kept secret; the Advanced and “not-so-Advanced-but-Awesome” Excel VBA. The things that make people hire you – that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.
Instructor Other Courses:
Play Piano by Ear Today! SuperCourse Daniel Strong, Excel Instructor/Programmer (16) $10 $60 Excel VBA for Business: Barcodes …………………………………………………………… Daniel Strong coupons Development course coupon Udemy Development course coupon Programming Languages course coupon Udemy Programming Languages course coupon The Ultimate Excel Programmer Course The Ultimate Excel Programmer Course course coupon The Ultimate Excel Programmer Course coupon coupons
The post 95% off #The Ultimate Excel Programmer Course – $10 appeared first on Udemy Cupón/ Udemy Coupon/.
from Udemy Cupón/ Udemy Coupon/ http://coursetag.com/udemy/coupon/95-off-the-ultimate-excel-programmer-course-10/ from Course Tag https://coursetagcom.tumblr.com/post/155341427553
0 notes