Excel Training Manual for Financial Professionals
Book information
Description
This is an Excel training manual to be used either for instructor led classes or as a self-study guide. The audience for this book is mainly financial professionals. It can also be used by anyone wanting to increase their current Excel skills. This book assumes you are already using Excel frequently and have a good working knowledge of using the software as a starting point . The skills trained in this course are aimed at taking your existing skills and building and expanding on it. This course is not aimed at the beginner level. The skills taught in this course are generic Excel skills and you would be able to use this course in Excel 2010, 2013 or 2016. Some of the topics covered are: • Worksheet manipulations • Using the IF, AND and OR functions • VLOOKUP • Named Ranges • Conditional Formatting • Formula auditing • Pivot Tables • Text Functions • Data sorting • Sub-totalling • Auto filters • Charts • Data validation • Goal seek • Keyboard Shortcuts
Similar books
Fundamentals of Laser Powder Bed Fusion of Metals
2021 · PDF
EXCEL 2023 CRASH COURSE: Master Excel 2023 With This Complete Crash Course In 7 Days
2022 · EPUB
The arraignment and tryall with a declaration of the Ranters also, several sentences proceedings at the sessions in the Old-Baily, and Councel of War: their protestations and the hanging of one up by the thumbs; with divers penalties to be inflicted upon others. The dancing and revelling of Dr. Buckeridge and his wife, and other gent. dancing all in white, in Berkshire, and their Christmas carol. A dispute between a Ranter in Bridewel, and one that came to see him; with his creed and pater noster: and the names of the false gods they worship. As also, a list of many of the Ranters, from whence they are derived: and of many hundreds of them in England
2019 · EPUB
The discoverer; vvherein is set forth (to undeceive the nation) the reall plots and stratagems of Lievt. Col. John Lilburn, Mr. William Walwyn, Mr. Thomas Prince, Mr. Richard Overton, and that partie ... Namely, under the pretence and colour of libertie ... a most dangerous and destructive designe is carried on to deprive the nation of their religion, rights, liberties, proprieties, lawes, government, &c. and to bring a totall and universall ruine upon the land. And so much is here clearely proved. The first part
2019 · EPUB
An act to impower Sir John Molesworth: Baronet, and Joseph Moyle, Esquire, Two of the surviving Trustees, in an Indenture, dated the Twenty-Fifth Day of December One thousand Seven hundred and Forty-Three, to raise the several Sums in the said Indenture mentioned, or such of them as are still unsatisfied, and pay the same, as well as the rest of the personal Estate of Hugh Gregor, deceased, to such Person as Jane Gregor, an Infant, shall marry during her Infancy, with the Consent of the surviving Trustees, and of her Guardians
EPUB
Case Histories
2008 · EPUB
Pandora's Seed: The Unforeseen Cost of Civilization
2010 · EPUB
Obama's Wars
2010 · EPUB