![]() ![]() Creating dynamic datasets and exploring structured referencing.Data cleanup using Text functions - Value, Trim, Numbervalue, Substitute, and more.Data Management with Data Tools, Date and Time Functions.Many other productivity tips, tricks, techniques and speed shortcuts that can increase your speed and output significantly.Explore Conditional formatting for reports that add that extra bit of professionalism.Building professional charts – key concepts in making building and formatting charts well.Learn how to create PIVOT TABLES from raw data and how to manipulate them using a variety of report and field manipulation options - Report filters, field filters, subtotals, tools, formatting, multi-level tables and table options.Learn how to use key functions like Sumif, Countif, Sumifs, Vlookup, Date functions, Time functions, and others to summarize data effectively and build useful spreadsheet tables.Learn about building large formulas with nesting of functions like nested IFs, and considerations of formula economy and efficiency for robust and stable formulas. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |