403 Spreadsheet courses

📊 Want to excel in Financial Analysis? Compete High’s online course covers everything from balance sheets to income statements—perfect for beginners and professionals alike! Learn at your own pace and earn a certificate! 🎓💼

Course Description Freelance writing is the practice of writing for money, in its simplest state. Freelance writers produce whatever written text is needed by their clientele, generally at home in their own office, for money. If you want to be freelance writer or want to get the success keys, you are welcome to join Freelance Writing Course. You will gain the skills necessary to thrive in the freelance writing world. Learn the secret self-promotion tactics of a seasoned freelancer quickly. Feel motivated and full of self-belief in a new home based career. You will learn everything you need to know about magazine article and travel writing, ghost writing, genre fiction writing, nonfiction book writing, children's book writing, to effective copy writing, and much more. What's In the Course? Discover why I am the right teacher for you. Indeed, I may be the ONLY writing teacher out there who has actually made a good living from writing. Most teachers either live in dusty classrooms teaching theory, or are so called 'gurus' who have no real world experience and yet spout even more theory from behind a blog or a flashy website. Not me, I'm the real deal. I've been making a living from freelance writing for over 25 years, online and offline - so I know how it's done, how it works, and how to make a shed-load of money doing it. Let me show you the best attributes to develop to make your new career a certainty. Talk to me about your problems within the course and let me help you gain the right mindset, attitude, and motivation. I'll be candid and assist you as much as is humanly possible. Plus, I'll be upfront about the money you can make, which is sometimes a lot more than you'd think! The key to making freelance writing work is to create multiple streams of income, so that you're getting a constant flow of money coming in from all kinds of writing work: magazine articles, travel writing, ghosting writing, editing jobs, writing fiction and nonfiction, getting published by the trade AND/OR self publishing certain things. The trick is to diversify and not rely totally on just one form of income. I'll explain fully how that is done effectively at the beginning of the course. Many new writers don't fully appreciate how to run a lucrative business. Basically writing for a living is a business too - and you need to approach it like one. In one crucial set of videos I explain how to plan and strategize your success and use priorities and measurement of your activities to maximize your earning potential. Plus tips on how to reduce your taxes and properly manage your finances. Writing success is about managing your activities - daily - and responding to feedback. My course ensures you don't get caught in a rut and that you respond quickly to the demands that writing for a living will engender. Included are downloadable activity sheets that will help you identify the best paying jobs. More than any other freelance business, you are a product of your own destiny when it comes to writing. You decide on what you want. You decide what you want to do with your time. You are the master of your universe - and you reap the rewards of true independence. During the course I explain how your mindset is your best friend, your best asset, and your key to true success. It's what is in your heart that matters - and I explain why. After this master class in self management I then go on introduce the concept of Practical Cash Creation. This detailed module explains the reality of writing for a living and what it means, how it can impact your life and those around you, how making money changes your life - and your partner's - all for the good. There are more downloadable income to activity schedules and spreadsheets in these modules to help you chart your progress and track your journey to success. Finally we reach the actual meat and potatoes of the course - actual money making activities explained in detail: how actual cash is generated from a myriad of sources. The information in these videos will literally blow you away. Never in one place have so many secrets been laid bare, especially about an industry normally shrouded in secrecy. Now it's no longer necessary for you to learn the hard way - all by yourself and over a long period of time (years!) because I have done all that FOR YOU. All the information you need is here. All the right tips and tactics that work are ALL HERE. Just for you. Writing for Magazines is traditionally seen as the freelancers main income source and the subject receives its full attention from me. The fact is, magazine articles may only make up a small part of your overall income but everything you learn about pitching for work will help sharpen your freelance writing skills. In this series of lectures I help you with Sample Query letters, assistance choosing topics that can't fail to have an editor salivating and a market listing to die for. Non Fiction Writing is covered in a series of SEVEN videos that show you how to construct sure-fire submissions to publishers on all kinds of books: science, fashion, history, whatever you like. You see the thing is that you don't have to write entire books to get paid to write them. Better to pitch nonfiction ideas to publishers FIRST and then let them commission you to write them. This is how true professionals work - and I show you the exact method by which you can compete and win with ease. Again I include an up to the minute listing of nonfiction publishers who are desperate for new book ideas from you. Writing Genre Fiction for big money is the dream of almost all new authors. But how is this achieved? Look no further. Over EIGHT info packed videos and FOUR full-length e-books, I explain how to write effective romance, thrillers, fantasy, horror, science fiction and cross-genre fiction for the modern marketplace, whether you're targeting traditional publishers or you want to self publish on Amazon. This module alone is worth far more than the super low price I'm asking for this extraordinary course. You won't believe what you get! Writing for Children is another favorite choice among new authors who sense there is much money to be made from spinning short tales for kids. It is true that the children's market is huge and lucrative but, do you really have what it takes to be a winner in this field? This special SEVEN part lecture series will put you on the right track. Compiled with the help of a multi-published children's author, this section alone is super valuable to any writer's career. Includes great instruction on technique and comprehensive market listing of children's book publishers Writing for the Corporate World has always been a great fallback for me. If ever there's a market that's always hungry, it's the business world. But many people misunderstand how most companies go about attracting freelance writers... because mostly they don't. We writers often have to make the first move. This section gives you the foolproof strategy I have always used to get business work. It's quick, easy, and costs nothing - but the pay is out of this world! Learn the one trick I present in this eye-popping SIX part section and you'll always be wealthy! Travel Writing - the dream ticket. What could be more exotic and glamorous? Writing travel articles is a bit like being James Bond without the gun! But what do travel magazines really want? What do travel book publishers need? In this wonderful new section I give you the facts. Everything you need to know about writing compelling articles, plus advice on how to get holiday gigs, and how best to do research on location and take photos that will become your way into the big time! Includes a complete list of travel writing publishers and high paying magazine markets. Becoming a Ghost Writer is about getting it all: money without the hassle of being a touring author. Honestly, if you're looking for sure-fire income, there is never a shortage of people looking for ghost writers. And it's incredibly well paid. Your biggest hurdle is finding the right kind of clients, by which I mean the PAYING ones. Only one in ten ghost writing clients want to pay you - even though they will lie and tell you they'll pay you later, which they often won't. This section is all about using business skills to attract paying clients, how to construct ghost writing contracts and how to do a great job quickly AND get paid UPFRONT. Getting Rich as a Copywriter is an ambition like no other. As we speak it is possible to spend up to $2000 on a copywriting course ALONE. But here, within Secrets of a Freelance Writer, over EIGHT packed lectures, you get every piece of information on copywriting you'll ever need. Don't waste your money on hack copywriters who have to sell their overpriced courses to make their mortgage payments. Find out everything you need to know from me, a freelancer - and a nice guy - who has used advanced copywriting skills to build a million dollar empire over the last decade and a half. Get in the know - and quickly! Self Publishing Online is now a necessary skill for all new writers. You simply can't survive as a credible author these days without having an online presence and a means by which to sell you own books. Many traditional authors are making the switch to digital author simply because the royalties publishers pay are too low. Amazon pays 70% to 90%. Traditional publisher pay 10%. It's easy to see why the majority of new authors now CHOOSE self publishing over the long and often disappointing slog of getting an agent then a literary deal where you'll end up barely able to pay the rent and bills. Learn how to self publish online like a professional and watch the money come rolling in! What are you waiting for? Offline Self-Publishing too is still a valid way of making cash quickly - if you know how to do it properly. There are many pitfalls to vanity publishing and you don't want to do that. But if you're a teacher, a coach, or a speaker then publishing your own book in a limited POD run to can be earning money you would normally be leaving on the table. In this four part section, let me show you the best advice for self publishing offline in this digital age. Includes downloadable resources. Grants and Funding for Writers. Did you know there are individuals, government departments, and corporations who regularly give money to authors, writers and poets? Getting grants and funding can be a useful tool to helping your bank balance and your kudos rating but many artists struggle over where and how to begin with this minefield of possibilities. This special section takes the mystery out of getting grants and applying for art funding. Helping Other Writers is one major key to getting wealthy as an author. As the number of wordsmiths taking themselves seriously these days, the larger the market grows for people who need help, help only YOU can give. You may not have considered this as a market before. You may not have thought yourself good enough. No matter. This unique look at cash creation shows you, over TEN fact filled lectures exactly how to make a great living simply helping other writers to succeed. And it's easy to attract the work and keep getting gigs for as long as you like! Self Promotion is necessary but need not be hard. Many writers don't want to promote themselves and then are overwhelmed by all the possibilities, many of which are a waste of time. Let me show you the best ways to promote yourself - the ones that work - so you can save time and get on with what really matters: the writing. Over this extraordinary FIVE part section - the likes of which you've never seen - I'll give you the lowdown on promotion tactics that make money and make sure you benefit from your new career. In the Conclusion, we look at maintaining a freelance career, which is all about combining self belief and proper business practice with writing. The fact is you don't need to be the best writer in the world to make a living as an author, a copywriter, a ghost writer or even a magazine article writer. Your enthusiasm and your dedication will take you a lot further than your talent. Freelance Writing is a dream job where you are rich, independent and FREE. Come join me. Let me show you how it's done! As well as giving all the information about writing for a living you could ever need, this unique course presents a step-by-step, motivational program for personal writing success, whatever your level of expertise. All you need is your enthusiasm and a willingness to learn and you will begin a new life of independence and freedom within days of taking this fun and insightful study aid. GO FOR IT! Join me now. Introduction to Freelance Writing Am I The Right Teacher For You? You Betcha! FREE 00:01:00 What You Need To Succeed FREE 00:02:00 Your Key is Your Attitude FREE 00:02:00 How Much Money Are We Talking Here? FREE 00:01:00 Creating Multiple Streams of Income The Main Point of This Course 00:02:00 Strategy and Measurement 00:02:00 Setting Your Priorities 00:02:00 Mindset of the Freelancer Mindset 00:02:00 Heart of Gold, Pot of Gold 00:02:00 Acquiring The Very Best Attitude 00:02:00 Practical Cash Creation Practical Cash Creation 00:01:00 The Reality of Writing for a Living 00:02:00 Activity To Income Schedule 00:00:00 Your Daily Writing Activities 00:00:00 Tracking Your income Tracking Your Income ONE 00:02:00 Tracking Your Income TWO 00:01:00 Income Tracking Sheet 00:00:00 Freelancer Spreadsheet Template 00:00:00 Writing For Magazines Writing For Magazines 00:02:00 Choosing Topics For Magazine Articles 00:01:00 Markets for Nonfiction Articles 00:00:00 Sample Magazine Query Letter 00:00:00 Writing Non Fiction For Publication and Sale Writing Non Fiction for Profit ONE 00:02:00 Writing Non Fiction For Profit TWO 00:02:00 Writing Non Fiction For Profit THREE 00:01:00 Writing Non Fiction For Profit FOUR 00:02:00 Writing Non Fiction For Profit FIVE 00:02:00 Writing Non Fiction For Profit SIX 00:02:00 Writing Non Fiction For Profit SEVEN 00:02:00 Writing Genre Fiction For Money and Kudos Introduction to Writing Genre Fiction 00:02:00 Writing Genre Fiction TWO 00:02:00 Writing Genre Fiction THREE - Romance 00:03:00 Writing Genre Fiction FOUR - Thrillers 00:01:00 Writing Genre Fiction FIVE - Science Fiction 00:01:00 Writing Genre Fiction SIX - Horror 00:02:00 Writing Genre Fiction SEVEN - Fantasy 00:01:00 Writing Genre Fiction EIGHT - Cross Genre 00:01:00 Writing For Children Writing for Children ONE 00:01:00 Writing for Children TWO 00:02:00 Writing for Children THREE 00:02:00 Writing for Children FOUR 00:02:00 Writing for Children FIVE 00:02:00 Writing for Children SIX 00:02:00 Writing for Children SEVEN 00:02:00 Marketing Listing of Children Book Publishers 00:00:00 Writing for Corporate Companies Writing for Business ONE 00:01:00 Writing for Business TWO 00:02:00 Writing for Business THREE 00:02:00 Writing for Business FOUR 00:02:00 Writing for Business FIVE 00:02:00 Writing for Business SIX 00:02:00 Travel Writing Travel Writing ONE 00:02:00 Travel Writing TWO 00:02:00 Travel Writing THREE 00:02:00 Travel Writing FOUR 00:02:00 Travel Writing FIVE 00:01:00 Travel Writing SIX 00:01:00 Travel Writing Publishers 00:00:00 Ghost Writing Ghost Writing ONE 00:02:00 Ghost Writing TWO 00:02:00 Ghost Writing THREE 00:02:00 Ghost Writing FOUR 00:01:00 Ghost Writing FIVE 00:02:00 Ghost Writing Resources 00:00:00 The Art of Writing Ad Copy The Art of Writing Copy ONE 00:02:00 The Art of Writing Copy TWO 00:02:00 The Art of Writing Copy THREE 00:02:00 The Art of Writing Copy FOUR 00:02:00 The Art of Writing Copy FIVE 00:02:00 The Art of Writing Copy SIX 00:02:00 The Art of Writing Copy SEVEN 00:02:00 The Art of Writing Copy EIGHT 00:02:00 Self Publishing Online Self Publishing Online ONE 00:02:00 Self Publishing Online TWO 00:02:00 Self Publishing Online THREE 00:01:00 Self Publishing Online FOUR 00:02:00 Self Publishing Online FIVE 00:02:00 Self Publishing Online SIX 00:02:00 Self Publishing Online SEVEN 00:01:00 Self Publishing Offline Offline Publishing Advice ONE 00:02:00 Offline Publishing Advice TWO 00:02:00 Offline Publishing Advice THREE 00:02:00 Offline Publishing Advice FOUR 00:02:00 Offline Publishing Resources 00:00:00 Grants and Funding for Writers Grants and Funding ONE 00:02:00 Grants and Funding TWO 00:01:00 Grants and Funding THREE 00:02:00 Grants Currently Available to Writers 00:00:00 Getting Wealthy by Helping Other Writers Helping Other Writers ONE 00:01:00 Helping Other Writers TWO 00:02:00 Helping Other Writers THREE 00:02:00 Helping Other Writers FOUR 00:02:00 Helping Other Writers FIVE 00:02:00 Helping Other Writers Six 00:01:00 Helping Other Writers SEVEN 00:01:00 Helping Other Writers EIGHT 00:02:00 Helping Other Writers NINE 00:01:00 Helping Other Writers TEN 00:00:00 Self Promotion Self Promotion Advice ONE 00:02:00 Self Promotion Advice TWO 00:01:00 Self Promotion Advice THREE 00:02:00 Self Promotion Advice FOUR 00:01:00 Self Promotion Advice FIVE 00:02:00 Self Belief and Your Career The End of the Course 00:01:00 Self Publishing - AGAIN 00:02:00 Maintaining a Freelance Career 00:02:00 Self Belief 00:02:00 Useful Websites for Self Publishing 00:00:00

PC fundamentals training course description A basic introductory course for those who have never worked with PCs before. The principle target audience is for those who will become PC support people. What will you learn Cable PCs. Perform preventive maintenance on PCs Run Windows and start applications. Use Microsoft Office applications. Customise Windows. PC fundamentals training course details Who will benefit: Anyone new to PCs. Prerequisites: None. Duration 3 days PC fundamentals training course contents PC hardware Overview of components inside a PC, cabling up a PC, preventive maintenance, cleaning mice, hardware screen controls, booting a PC. Windows overview Versions of Windows, Starting Windows, logging on, shutting down. Using Windows The desktop, the start menu and submenus, getting help, shutting down Windows, switching between applications, sizing and controlling windows, special keys on the keyboard. Accessing files and folders Folders and files, Windows explorer, IE, creating, viewing and manipulating folders, creating, viewing and manipulating files, permissions, bits and bytes, the recycle bin, undeleting and undoing, formatting floppy disks, using floppy disks DOS Accessing DOS, basic DOS commands, drives. Microsoft Office Word documents, Excel spreadsheets, emails, browsing the Internet, printing files, managing print queues. Printing Overview, printing, properties Customisation Customising the task bar, customising the start menu. The control panel, mouse and display properties, Desktop settings, setting the date and time. Networking overview Workgroups and domains, Accessing file and print resources

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. Lesson 1: Tableau Fundamentals Topic A: Overview of Tableau Topic B: Navigate and Configure Tableau Lesson 2: Connecting to and Preparing Data Topic A: Connect to Data Topic B: Build a Data Model Topic C: Save Workbook Files Topic D: Prepare Data for Analysis Lesson 3: Exploring Data Topic A: Create Views Topic B: Customize Data in Visualizations Lesson 4: Managing, Sorting, and Grouping Data Topic A: Adjust Fields Topic B: Sort Data Topic C: Group Data Lesson 5: Saving, Publishing, and Sharing Data Topic A: Save Data Sources Topic B: Publish Data Sources and Visualizations Topic C: Share Workbooks for Collaboration Lesson 6: Filtering Data Topic A: Configure Worksheet Filters Topic B: Apply Advanced Filter Options Topic C: Create Interactive Filters Lesson 7: Customizing Visualizations Topic A: Format and Annotate Views Topic B: Emphasize Data in Visualizations Topic C: Create Animated Workbooks Topic D: Best Practices for Visual Design Lesson 8: Creating Dashboards in Tableau Topic A: Create Dashboards Topic B: Enhance Dashboards with Actions Topic C: Create Mobile Dashboards Lesson 9: Creating Stories in Tableau Topic A: Create Stories Topic B: Enhance Stories with Tooltips

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros