![]() ![]() Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios. Relative, Absolute, Mixed, and Circular ReferencesÄo you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. By the time you finish this lesson, you'll really start to feel like an Excel pro. We'll also spend some time working with the Quick Analysis and Flash Fill tools. Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. ![]() ![]() In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas. In our first lesson, you'll develop a solid understanding of the Excel interface. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |