Chandoo. org - Complete Archives of Excel tips, Charting Tutorials, Dashboard Templates and More.. Hillary in Swing States. Convert a Roman Numeral to a Number. Sara’s Copy Shop – Break even analysis and what- if modeling in Excel . Find the Cell Address for a value (2. D & 3. D Reverse Lookup)Formula Forensics No. Find Which Worksheet a Max or Min Value is located on. CP0. 46: Gantt charts & project planning using Excel. Use NUMBERVALUE() to convert European Number format. Document file extension list File extensions used for various document and document template file types. In computer terminology, document file format can be described as a text, or binary data file type, used to store. Transcript: When you think about word processing software, such as Microsoft Word, what probably enters your mind is typing, not necessarily just putting your. Excel is 3. 0!!! Use these 2. What is the coolest thing you made with Excel? Commission growth – Getting the message across ? Lukes Reward – Part IICP0. Sexy on spreadsheet, Ugly on Printout. Ready to use Excel Dashboard Templates – Official Trailer. Looking up when the data won’t co- operate (case study)What would you wear to an Excel themed Halloween party? CP0. 24: Customize Excel to boost your productivity. The ultimate VLOOKUP trick – Multi- condition Lookup. Back after a while & 3 announcements. Introducing? Introduction to Excel VBA, Macros & Automation. A better chart to visualize “Best places to live” – Top 1. Excel chart. Charmed Price Problem. CP0. 21: How to quickly compare 2 lists in Excel. Play your favorite games nownews & announcementsupcoming release upcoming event featured events sign up / sign in. ABC Inventory Analysis using Excel. Drag to multi- select slicer items ? How to Count and Sum Filtered Tables. Ask me your Excel questions & You could win an e. Book. How fireworks animated chart is made ? Lets ask Excel. Vote for your favorite US state migration dashboard. CP0. 11: 5 Excel magic tricks to impress your boss. Top 1. 0 things we struggle to do in Excel & awesome remedies for them. Excel Dashboards – 4. US State to State migration trends. Matching transactions using pivot tables . Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them. VBA Serenity. Tables, Pivot. Tables, and Macros: music to your ears. CP0. 03: Business Intelligence for Masses – Interview with Mike Alexander. Calculating Maximum Change ! Our Join Power Pivot class. Quick and easy Gantt chart using Excel ? Calculating Costs that Vary by Year and Age. Find last day of any month with this simple trick ? Average the last 3 values greater than 0. Power. Pivot – the ULTIMATE anti- bloat feature. I said your spreadsheet is really FAT, not real PHAT! What are best Excel interview questions? Extract words from a cell, where they occur in a list of words. Calculating average of every nth value ? Now interactive chart in Excel? Power Pivot online classes – now open for you. Excel Links for you – Busy busy edition. Details about upcoming Power Pivot course (and a bonus tip on dashboards)Formula Challenge 0. Return everything from a string after the first block of numbers (Part 4.)Formula Challenge 0. Return everything from a string after the first block of numbers (Part 3.)Are you interested in learning Power Pivot? Formula Challenge 0. Return everything from a string after the first block of numbers (Part 2.)Formula Challenge 0. Return everything from a string after the first block of numbers (Part 1.)Never use simple numbers in your dashboards (bonus tip: how to fix default conditional formatting)What do you use Tables for? Excel aka Bill Jelen tomorrow. What do you want to ask him? Declines chart to understand change in values. Last day for enrollments – Join our Power Pivot course & become awesome analyst. Love letters to Chandoo. Shading above or below a line in Excel charts . Interpolation. Power Pivot & Advanced Excel course is open, Join us today! Transpose a table quickly using Copy – Paste ? Bean to Defraud Latte? How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel. Formula Forensics No. Creating Dynamic Charts with Non- Contiguous Data. Become Awesome in Excel while saving money. Chandoo. org Holiday SALE, Starts on Monday – 3rd December! Macros for Automatically Implementing Modeling Best Practices. Extract data using Advanced Filter and VBAExcel Links – Lets meet in Chennai this Sunday edition. Financial Ratios – Cappuccino or Latte? Project Portfolio Dashboard in Excel ? Production Scheduling using Excel. Use Indexed charts when understanding change . Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence. Using pivot tables to find out non performing customers. Tips on Rounding numbers using Excel Formulas. Introducing Excel School + Excel Hero Academy Bundle. Confessions of a dad . Sum. If with Inconsistent Column Layouts. Customize Zebra lines Quickly using Table Styles ? It’s Just a Jump to the Left. Show Decimal Points if needed . Remove Leading Zeroes. Growing a Money Mustache using Excel . Highlight Only Duplicate Entries. Sorting values in Olympic Medal Table style . Count Unique Values in a Range. Show only few rows & columns in Excel ? Is this number a Prime Number ? Highlight Row & Column of Selected Cell using VBAVisualizing Roger Federer’s 7th Wimbledon Win in Excel. Creating a Masterchef Style Clock in Excel . Count and Sum a Filtered List according to Criteria. Sort Pivot Tables the way you want ? How much salary you make? Sum the Odd Numbers between 1 and 1. Chandoo Visits Perth Australia. Highlight due dates in Excel – Show items due, overdue and completed in different colors. Highlight Employees by Performance Rating – Conditional Formatting Challenge. Catchup with Chandoo in Perth. Formula Forensic No. Find the 4th Slash ! Please Enroll in our Excel & Dashboards Masterclass – Melbourne. VBA Move data from one sheet to multiple sheets. Interactive Sales Chart using MS Excel . Bhavik’s Monthly Workingdays Formula. Excel Links – Live from Sydney Edition. Thank you, I am flying to Australia today! Adding Macros & Final Touches to Customer Service Dashboard . Converting uneven Text Strings to Time. Creating Customer Service Dashboard in Excel . Retrieving the Nth number from a Range which has Gaps. Creating Cash Flow Statement by Indirect Method – IConsolidate data from different excel files (VBA)There are Easter eggs in this file!!! Formula Forensics No. A Solution to Maljzm’s problem. Sign- up for my Excel Dashboard Masterclass in Australia. Using Excel As Your Database. Comprehensive Guide to VLOOKUP & Other Lookup Formulas. Formula Forensics 0. Suzannes DJIA Average. Excel Speeding up Tips Shared by YOU! Cornelia’s Price Rises. In Cell Text Formats – 2 Quick Tips. Yet Another Sales Funnel Chart in Excel. Do you use Pivot Tables? What do you use them for & where do you struggle . Lykes Formula. Using external software packages to manage your spreadsheet risk . Count How Many Times a List of Values Occurs in a Range. Custom Number Formats (Multiply & Divide by any Power of 1. Excel Links – Live from Bangkok Edition. Cleaning Up Imported Data – A Recent Case Study. Formula Forensics No. Elkhan’s Max. If. Excel’s Auditing Functions . Pradhishnair’s Chainage Problem. Six Quick Updates. Finding Friday the 1. Excel (and learning cool formulas along way)Announcing Online VBA Classes from Chandoo. Please Join Today. Use CTRL+Enter to Enter Same Data in to Multiple Cells . No 0. 07 – Sumproduct. Join Excel School & Become Awesome in Excel Today! Formula Forensics 0. Palindromes. Shortcut for Long Models. Learn Any Area of Excel using these 8. Links. Formula Forensics No. Zebras and Checker- Boards. Introduction to Spreadsheet Risk Management. Tips to Make you a Formatting Pro. What is one area of Excel you want to learn more? Lukes Reward. Making Small Multiples in Excel . Joyces Question. Fancy Posts – using HTML Display Codes in Chandoo. Posts. A Technique to Quickly Develop Custom Number Formats. Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range. Compare 2 Lists Visually and Highlight Matches. Tell us what you would like to learn in our Excel for PMs course . In Other Words, How to use Advanced Filters? Offset() function to Calculate IRR for Dynamic Range. A Challenge from Hui. Incell Sales Funnel Charts. Sum of Values Between 2 Dates . Please join today! VBA Classes + a Demo Lesson. Dummy Data – How to use the Random Functions. Discount on PUP & Power. Pivot Contest – Hurry up! Online VBA Classes by Chandoo. Details & Dates. Place Key Information in Golden Triangle on your Reports, Dashboards etc. I need your help! Celebrating India’s Worldcup Cricket Victory – In Excel Dashboard Style! How to make a 5 Star Chart (Similar to Amazon)Auditing Spreadsheets? Consider Joining Excel School. How to Filter Odd or Even Rows only? Tell us about yourself to win a free training kit. Christmas Cards in Excel – Download and Spread Joy. Excel Links – Next Dashboard Contest Edition. Mutant Cell Modeling Problem . A short introduction to this website. Formatting Multiple Worksheets? Use Group Sheets option to Speed up ! Watch this tutorial video ! Actual Profit Loss Report using Pivot Tables. Introduction to Excel SUMIFS Formula. How to Select Right Chart for your Data. Quickly Turn off Gridlines in Excel 2. Forms Toolbar ? What to do when all you see is the formula, not result. Survey Results in Dot Plot Panel Chart ? Scroll- bar Mortgage Calculator or: Why you should not be borning and use form controls. Extract usernames from E- mail IDs ? Learn Excel Data Tables. Issue Trackers & Risk Management using Excel ? Actual Charts – 1. Charting Ideas You can Use. Search a Spreadsheet Full of Data using Conditional Formatting. Interview with John Walkenbach on Excel and Banjo Charts. Actual Performance. Highlight Top 1. 0 Values using Excel Conditional Formatting. New Improved Version of Excel Formula Help. Hot or Not – Mc. Kinsey’s Innovation Heatmap. Excel Conditional Formatting Basics. Us vs. Them – Compare Sales Performance using Charts & Form Controls. How to use Excel Chart Templates and Save Time. Excel Links of the Week – Free E- Book Edition. RSS Icon using Donut Charts – Because it is Weekend. Open Thread For First Time Commenters – What do you like in Excel? Japanese Candlestick Chart – Excel Tutorial. February 2. 00. 9’s Most Popular Posts. Areas where Mouse Kicks Keyboard’s Butt. Weekly Excel Links – After a Long Time Edition. The good news is: we get to choose between Apple i. Work (Pages, Numbers, and Keynote), Microsoft Office (Word, Excel, and Power. Point), and Google Docs (Docs, Sheets, and Slides). The bad news is: we have to choose between Apple i. Work, Microsoft Office, and Google Docs. And it can be a tough choice! Microsoft Office is the enterprise standard. Google Docs is increasingly everywhere. So, which one is best? We put them to the test so you can find out! Word processing: Pages vs Word vs Docs. One of the most common things we do with an Office suite is create documents or PDFs. Whether you need to update your resume, complete an assignment for school, or create a flyer for an event, or something else, you need to be able to get the text in efficiently and format it effectively. In terms of templates, both Pages and Word offer a decent selection to choose from. Everything from reports to resumes to outlines to fliers and more. Google Docs doesn't offer templates and simply launched you right into a blank text document. So if you're looking for templates, you're going to want to use either Pages or Word. When it comes to feature set and editing tools, Pages uses interactive formatting in order to let you select different elements. Editing tools and the format menu will change depending on what you have selected. When you're typing, a formatting bar will appear over the keyboard so you can easily adjust fonts, alignment, breaks, and more. You can also add tables, charts, graphs, shapes, and photos in just a few taps. Overall, Pages offers a robust feature set that remains easy to use and works great on a touch interface. When it comes time to export your documents, Pages supports . Pair Pages with a Bluetooth keyboard and it's almost comparable to the desktop version of Pages. Microsoft Word has been completely designed around a touch screen interface, but will be familiar to desktop Office users as well. In just two taps you can insert or format pretty much any object you'd like. Some features such as tracking and reviewing changes, section breaks, and a few others will require an Office 3. Premium subscription. Either way, the free version of Word offers enough features that a good majority of folks will be able to accomplish what they need with zero issues. One thing I do wish Word had was the formatting toolbar similar to what Pages offers. Google Docs is simpler than either Pages and Word, and the editing tools more basic. Like Word, I do wish Google had placed a formatting bar directly over the keyboard instead of at the top of the screen. Image insertion is also missing, which will be a deal breaker for many. However, certain features such as review tracking, section breaks, and more are free with Pages but require premium subscription with Microsoft Word. So unless you need Word or simply prefer the layout, Pages currently offers the best value for most people. Spreadsheets: Numbers vs Excel vs Sheets. Numbers proves that doing calculations doesn't have to be painful on an i. Pad or i. Phone. Just plot your data and then choose what kind of table, graph, or chart you'd like to use to represent it. The keyboard also changes dynamically in order suit what you're doing. So if you type an = sign in order to start a formula, Numbers automatically gives you a full number pad and relevant buttons you may want to use. There are also lots of templates to choose from in Numbers including ones to create budgets, calculate net worth, track grades (great for teachers), plan travel, and much more. There's no disputing that Microsoft Excel has been the king of spreadsheets. The main reason for that is the robust feature set. There's no denying in networked office environments, Excel can't be beat. Microsoft did good job bringing the experience to the i. Phone and i. Pad as well. When using formulas in Excel, the formatting bar automatically brings up suggestions to make handling complex formulas an easier job. The keyboard also is suited for entering numbers and editing formulas, a feature I wish the Word application received as well in terms of a formatting bar. Some features, however, will require a premium subscription. Google Sheets is a barebones spreadsheet application that allows you to create spreadsheets but without the help of a lot of formatting tools and templates that are offered in competitor apps such as Excel and Numbers. However, if your main purpose is to track data between large groups of people, Google's collaboration tools are some of the best around. Just share sheets with whoever you need to via email and once they accept you can view changes, make comments to each other, and even see who's changing what in real time. If feature set and advanced tools are your main concern, there's none better than Excel. If you're new to spreadsheets and would appreciate a balance between ease of use and feature set, Numbers is for you. If collaboration tools are what you're after and your feature requirements are minimal, Google Sheets will suit you just fine. Presentations: Keynote vs Power. Point vs Slides. Keynote has always been Apple's best office app, and the same holds true on i. OS. Aside from offering gorgeous templates to choose from, Keynote's interface feels as it if were made for the touch screen. Adding slides couldn't be easier, and neither could tweaking them to your liking. Just like the other i. Work apps, formatting and editing is interactive, so the menus will change depending on what type of content you're working with. The Keynote Remote feature also lets you use one i. OS device as a remote to control a presentation on another, or even on a Mac. Power. Point is no a slouch when it comes to creating presentations either. You can create animations, transitions, and much more in just a few taps. If you've ever used Power. Point on the desktop computer, the experience is very much the same on i. Pad and i. Phone. Inserting objects is also easy and includes support not only for tables and pictures, but videos as well. Unfortunately Google Slides doesn't provide as great of an experience as either Keynote or Power. Point do. Slides are technically . You can add text into existing text boxes but there isn't a way to add, move, or edit them. Basically, you have to pick from Google's pre- made slides and be happy with text- only slides with no image support, unless, of course, you are okay with finishing things up from a web browser. You can choose themes on the web and then they'll sync down to the mobile version, but again, not very convenient. Keynote and Power. Point run neck and neck when it comes to creating presentations. Both support inserting images, videos, and other kinds of objects as well as the option to choose from many great looking templates. Google Slides can't really offer any of that. Syncing, sharing, and collaborating. All of Apple's i. Work apps tie in with i. Cloud. That means no matter what device you create something on, you'll be able to access it on any other i. OS device or Mac that's linked to your account. You can also link Dropbox and pull files from there into any of the Office apps. Dropbox integration isn't something Google or Apple offer (though that may change in the future thanks to i. OS 8's third- party storage provider support), so if you're tied into that ecosystem due to file sharing or some other factor, Office may be the best option for you. Google uses Google Drive as a hub. There, you can view all your Docs, Sheets, and Slides files in one place, and they'll sync anywhere you can access Google Drive, including any desktop browser. You can easily share documents or export them from the apps and online. And when it comes to collaboration, Google can't be beat. Not only can you share Google Docs files with others so they can view and edit them, you can see what changes they're making live, which makes Google Docs a great option for workgroups and teams that need live collaboration options. Who should use i. Work? If you're tied into an Apple ecosystem consisting of Macs and multiple i. OS devices, and i. Cloud is your main syncing service of choice, Pages, Keynote, and Numbers will serve you well. All of the i. Work apps manage to strike a great balance between feature set and ease of use. If you don't need the most advanced tools on the planet, the i. Work apps are a great place to start. Also, if you're new to working with office documents, i. Work is a great place to start. Pages - $9. 9. 9, free for newer i. Phones, i. Pads, and Macs - Download Now. Numbers, $9. 9. 9, free for newer i. Phones, i. Pads, and Macs - Download Now. Keynote, $9. 9. 9, free for newer i. Phones, i. Pads, and Macs - Download Now. Who should use Microsoft Office? Microsoft Office has always been the most advanced productivity suite on the market. Anyone that's already familiar with Office 3. PC will feel right at home with Office for i. Pad or i. Phone. Office is also the only offering that includes Dropbox integration, which is something you'll want to consider if you keep most of your documents there. The more advanced features of Office will require a 3. If you already have an Office subscription, Microsoft Office is hands down the best option for you considering all the premium features you already have access to. Who should use Google Docs? Google Docs is a barebones productivity suites but it's completely free and offers some of the best collaboration tools you can ask for. If you don't need all the fancy formatting and media capabilities, want to work with multiple people, and like having everything in the cloud, Google Docs is your best option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2017
Categories |