Posts - 101 results

  • Udemy – Microsoft Excel – Excel Data Analytics and Simulations [100% OFF]

    Posted on 16/02/2019 by | 0 comments

    Course Description

    Excel simulations help in investigating a real-life phenomenon, process, problem using a model. This approach is automated one, result oriented, interactive and also user friendly. This method of working around with your data makes it challenging, creative and fun. These simulations actually bring out together loads of excel skills. These online tutorials are indeed self-paced and one can easily make way and learn business intelligence and understand the importance of data trending and create valuable data visualizations. We are going to learn the entire simulations procedure wherein we will understand various functions such as Data Simulation, single reference simulation, grid reference simulation, chart simulation, goal seek etc.

    Read more
  • Udemy – Ultimate Microsoft Excel Course: Beginner to Excel Expert [100% OFF]

    Posted on 14/01/2019 by | 0 comments

    Course Description

    ★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★

    It is time to master Excel. If you are a beginner and want to develop your Excel skills or have the desire to be an Excel guru, you have come to the right place.

    This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

    This course is perfect if you;

    • Use Excel everyday but want to improve your all-round skills and become the office expert
    • Have a basic knowledge but want to take the plunge and develop your Excel muscles
    • Learn all the essential skills in Excel to help get a new job or promotion

    The course has been designed as a one-stop shop for all of the essential skills of Excel. It is very comprehensive and you can come back again and again to re-visit material.

    The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel in 2019 and amazing features on the horizon – you can be sure to find lessons added to this course so that you stay ahead of the game.

    I teach in a hands-on way with unique examples demonstrating all of the essential features of Excel. You will not only understand HOW these Excel tools and formulas work, but see examples of WHY they are so awesome.

    By the end of the course you will be a confident user of Excel with the skills to progress your career further, or become the office Excel guru.

    During the course you will learn;

    • To use the power of PivotTables to summarise large amounts of data and produce dynamic reports in minutes.
    • Be confident in using over 30 of the most important Excel functions including INDEX, VLOOKUP, MID, IF, MATCH and COUNTIF.
    • Create charts in a flash that visualize data effectively.
    • Conditional Formatting to highlight data comparisons, progress and issues.
    • Utilise the awesomeness of Power Query to import, shape and transform data.
    • Clean up messy data with formulas, Flash Fill and other Excel features.
    • Understand the data model in Excel and PowerPivot.
    • To use macros to automate time-consuming tasks.
    • And much much more.

    Why learn from me?

    I have been training business all around the world on how to get the most out of Excel for over 20 years.

    Learning and teaching Excel is my passion. I am a full time Excel trainer and consultant, so every day I am in the thick of the action teaching others to master Excel.

    I set up the Computergaga blog and YouTube channel 10 years ago where I am lucky enough to have taught millions of people across the globe to increase their skills and overcome everyday real world Excel problems.

    The course includes the exact files that I use in the lessons to download and follow along, lifetime access and 1 on 1 instructor support every step of the way.

    Don’t delay. Take action. Grab a coffee and let’s get started.

    Your journey towards mastering Excel starts today.

    Read more
  • Udemy – Power Pivot in Microsoft Excel 2016 [100% OFF]

    Posted on 28/12/2018 by | 0 comments

    Course Description

    This course will help you to learn from the scratch level about excel its basic & advanced functions. In this course of Power Pivot in Excel you will be learning how to import millions of rows of data from multiple data sources into a single excel workbook. Knowing excel is must in this world and this course will help you to work with data more effectively. You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how power pivot will help to analyze the comprehensive data to make timely business decisions.

     

    Udemy Coupon Code : https://www.udemy.com/power-pivot-in-microsoft-excel-2016/?couponCode=XMAS2K19

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Excel Masterclass: Complete and Concise [100% OFF]

    Posted on 15/12/2018 by | 0 comments

    Course Description

    Welcome to the Microsoft Excel Masterclass course.

    The course is created on the basis of three pillars of learning:

    1. Know (Study)
    2. Do (Practice)
    3. Review (Self feedback)

    Know

    We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.

    Do

    With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

    Review

    Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.

    Apart from this, explore fun and exciting use cases of Excel in our bonus videos.

    The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of Excel in today’s corporate world.

     

    Udemy Coupon Code : https://www.udemy.com/microsoft-excel-masterclass-complete-and-concise/?couponCode=MASTEREXCEL_WBS1

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Excel – Getting Started With The Basics [100% OFF]

    Posted on 01/12/2018 by | 0 comments

    Course Description

    Welcome to Getting Started with Excel 2013 – a series of Excel video tutorials for beginners. If you’re new to Excel, I recommend taking this course now to learn more about how to get the most out of the Microsoft Excel, get your job done faster and improve your resume. If you have already used Excel but want a comprehensive knowledge of the basics, then you’re in the right place.

    This is based on the original getting started with Excel course that I have been teaching in person in the UK banking industry since 2007. Now fully updated for Excel 2013, this course has been used by students all around the globe.

    So if you’re looking how to get started with Excel quickly and easily, Getting Started with Excel 2013 will transform the way you work!

    Here is what students said about this Excel course:

    “This course is exactly as described: a beginner’s tutorial on the most basic and fundamental aspects of Excel. I haven’t used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect “Basics” course!”
    –  Vivian P.

    “The pace of tutoring and interactivity made the information easy to understand.”
    – Garith Parker

      “Useful and easy to follow. Great teacher. Im self taught on excel and have used for 17 years…. learning so much from this course that is already speeding up my work!”
    –  Graham Wilkinson

    Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation – they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it’s full of holes. Eventually they hit a point where their wall can’t sustain any more weight and it collapses. What a waste of time!

    This course takes a step-by-step approach to working with Excel. Each lesson builds upon the previous one, so your wall is solid. So whether you’re looking to do your job better, or if you’re looking to improve your resume, you are in the right place.

    A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board.

     

    Udemy Coupon Code : https://www.udemy.com/getting-started-with-excel-20132/?couponCode=FACEBOOKGROUP

     

     

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Word 2016: Writers: Beginner Writing and Outlining [100% OFF]

    Posted on 24/08/2018 by | 0 comments

    Description

    If you’re a writer you write.  That’s a lot of time spent writing.  Why not get to know the editor you use to write?

    Microsoft Word is the chosen standard for professional writers.  Odds are you’re already using it.  In either case, you should be familiar with the product.

    Fortunately, this video training course provides much more than a casual overview of Word:

    • Word Setup
    • Outlining
    • Writing

    All are discussed in detail.  With an additional section on using Word to address:

    • Social Media: Blog posts, Facebook memes and tweets
    • Fiction: Stories, novellas and novels
    • Non-fiction: Essays, documents, articles and books
    • Business: Reports and Tool Integration

    Take note!

    • This course is complete!
    • This course is detailed!
    • This course is up to date!
    • This course is easy!
    • This course is fast!
    • This course is fun!

    Watch this course first, the initial release in my Microsoft Word training series.

     

    Udemy Coupon Code : https://www.udemy.com/microsoft-word-2016-writers-beginner-writing-and-outlining/?couponCode=BBHF13

     

     

     

    Share with your friends :

    Read more
  • Udemy – Excel Macros/VBA: Create 4 Real World Projects from Scratch [100% off]

    Posted on 02/11/2017 by | 0 comments

    Excel Macros/VBA: Create 4 Real World Projects from Scratch
    Description

    Imagine if everything you had to do in Excel could be reduced to a click of a button. How much time would that save you in your workday? How much stress would disappear because now you don’t have to dread completing your tedious Excel work? If you’re reading this course description, I bet the answer is quite a bit.

    The entire purpose of my day job is to automate tedious work that people don’t want to do. This increases the productivity of my company, which is very valuable. It allows us to continue growing without adding many more employees, which increases our profits. I use many tools to achieve automation, but Excel is one of the best because it’s simple to learn yet very powerful in application. My goal with this course is to enable you to increase your own productivity, just like I do for many people at my day job.

    I will use real world projects, some that I have had to deal with myself. You will see the process that I go through to figure out how to automate these tasks. It may be surprising, but I usually don’t know how to accomplish an automation project from the get-go. It takes some planning and critical thinking for every project you take on. That’s why you should think of this course more as providing the tools for you to solve any problem, rather than an encyclopedia-like course that will give you a bunch of information. For those of you still reading, I hope you enjoy the course. I put a lot of work into creating the most useful course I could!

     

    Udemy Coupon Codehttps://www.udemy.com/excel-macros-create-4-real-world-projects-from-scratch/?couponCode=INSTRUCTORREVIEW

     

     

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Access VBA: Automating Import of Excel Files [100% off]

    Posted on 21/07/2017 by | 0 comments

    Microsoft Access VBA: Automating Import of Excel Files
    Description

    NOTE: The last section, where we create a button on a form and then link our import program to it, will be added on Friday, July 21.

    Many students have contacted me with requests on how to handle the periodic import of Excel files.  Typically an Excel file is received weekly or monthly and needs to be imported and used to update and/or add to a main data table.  This course will show you how to reduce this process to nothing more than selecting the import file.  The rest of the steps are handled automatcially in seconds!

    Even if you never need to import Excel files, there are several VBA techniques in this course that have not been covered in any of my other courses!  Topics like using the Immediate Window, using the Office File Dialog box to select files and how to use “Late Binding” to make sure your VBA code works with any version of Access!

    The program we will build together doesn’t only import the Excel file, it also analyzes the data for errors and creates a report showing the details of what needs to be corrected!  If you are willing to take the time to go through this course you could completely eliminate the headache of having to periodically import Excel files!

    This course is “hands on” and we completely build the database step by step in the course lectures.  The course is built so that you can watch the steps then pause the lecture and do them yourself!

    There is a HUGE need in the marketplace for people who REALLY know how to do Microsoft Access projects like this one.  This is your opportunity to break away from the pack of people who struggle to create effective systems and demonstrate that you have the skill to save huge amounts of time!  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

    __________________________________________________________________________

    In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!

    __________________________________________________________________________

    What I am NOT able to do for you in this Course..

    I can’t guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

    ________________________________________________________________________

    This course will not remain this price forever! It’s time to take action!

    Click the “Take This Course” button at the top right now!

    every hour you delay is costing you money…you could become the goto person for Microsoft Access VBA!

    See you in the course!

     

    Udemy Coupon Codehttps://www.udemy.com/microsoft-access-vba-automating-excel-import/?couponCode=IMPXL1000

     

     

    Share with your friends :

    Read more
  • Udemy – The Complete Word 2016 Course 2.0: Beginner To Advanced [100% off]

    Posted on 17/04/2017 by | 0 comments

    The Complete Word 2016 Course 2.0: Beginner To Advanced
    Description

    In this software training course from ClayDesk, you will learn beginner and advanced skills in Microsoft Word 2016, and be able to demonstrate the use of advanced and specialized features within the application. You should be able to create, manage, and distribute professional documents for a variety of specialized purposes and situations, and be able to customize Word 2013 environment to meet specific needs to enhance productivity.

    After a quick overview of Word 2013, you will start with how to manage and share documents, preparing documents, set tracking options, advanced editing features, protecting and designing advanced documents, applying advanced formatting and styles. Finally, you will learn shortcuts along with several quizzes to fully prepare you from not only the examination point of view, but acquire skills, giving you a competitive edge.

    This comprehensive tutorial covers all aspects and prepares you to take the Microsoft Office Specialist (MOS): Microsoft Office Word 2016 Expert certification exams 77 – 425 (Part 1) and 77 – 426 (Part 2). In addition, the American Council on Education (ACE) has reviewed and recommended college credit for selected Microsoft certifications. Approved certifications are eligible for one to six semester hours of college credit in bachelor’s degree or associate degree classes on computer applications, information technology, or computer information systems. The Accreditation Program helps your students achieve employability and academic goals, as well as bridging the gap between workforce training and the classroom.

    By the completion of this training video, you will be comfortable with using advanced features of Word 2016 and feel confident performing your work in an efficient manner. For those who already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Word 2016 at an expert level.

     

    Udemy Coupon Codehttps://www.udemy.com/word2016course/?couponCode=WORD2016FREE

     

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Powerpoint 2016 – Beginner To Advanced [100% off]

    Posted on 09/03/2017 by | 0 comments

    Microsoft Powerpoint 2016 - Beginner To Advanced

    Course Description

    Includes 12 Powerpoint files so you can practice what you have learned in the course + a checklist and 4 files to make sure you are creating high-quality presentations!

    Hey there! Are you ready to create amazing presentations with Microsoft Powerpoint 2016?

    Nowadays, Powerpoint knowledge is a must. You can use this software for so many different reasons; at work, in school and for personnal projects! Bosses also love seeing an employee having Powerpoint on his resume. This course can land you a new job!

    In this tutorial, you will learn everything that you need to know about Powerpoint 2016. It’s the perfect fit for you if you are a beginner or intermediate and want to be able to use this amazing and useful softare to the fullest!

    This course is divided into 4 sections of incredible content :

    • A Powerpoint Presentation
    • Overview Of The Basic Options
    • Creative Options
    • Rules Of A High Quality Presentation

    After completing this course, you will be able to create amazing slides and do everything you want to on Powerpoint.

    My ultimate goal is to be there for you and help you become a master at Microsoft Powerpoint 2016.

    Sign up and join me in this great course!

     

    Udemy Coupon Code : https://www.udemy.com/microsoft-powerpoint-2016-beginner-to-advanced/?couponCode=PPTFREE00

     

     

     

    Share with your friends :

    Read more